Hello all . . .

I need your help plz . . .



In the above schema i have the table SYSTEMATIC_RASH_EPISODES witch storing for any of the columns after the column SYRE_PATIENT_ID only Boolian values. This table get a record each time the patient goes to the doctor.

Now what is the problem ? ? ?

For each of the boolean columns of the table SYSTEMATIC_RASH_EPISODES witch the value is true the doctor mast create three sub-records with the drugs(medicens) that must gve t the patient.

How can i do that ? ? ?

Creating N sub-records generally means creating a new table with a foreign key ( SYRE_ID in this case ) to connect it back to your main ( Systematic_Rash_Episodes ) table.