Originally Posted by
ssanfu
I think you need to step back and look at your table design/structure. It looks like you are missing 3 tables.
Look at the "Patient" table and the "Doctor" table.
Can 1 patient have many doctors? Can 1 doctor have many patients? If the answer is YES, then you need a junction table.
Look at the "Patient" table and the "Medical Procedure" table. (shouldn't have spaces in object names)
Can 1 patient have many Medical Procedures? Can 1 Medical Procedure be performed on many patients? If the answer is YES, then you need a junction table.
Look at the "Patient" table and the "Medication" table.
Can 1 patient take many medications? Can 1 medication be given many patients? If the answer is YES, then you need a junction table.