Tables are:
Patient(PatientID, FirstName, LastName)
Disease(DiseaseID, DiseaseName)
PatientDisease(PatientID, DateID, DiseaseID)
It's clear that Patient and Disease tables have PatientID and DiseaseID as PKs, but what about PatientDisease table knowing that each patient in a single day can be diagnosed with a single disease?
I think, that it here you should use composite PK with all 3 fields: PatientId, DateId, DiseaseId. No matter one disease per day can be diagnosed or not, all 3 fields are mandatory for patient disease.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments