Should the following design be decomposed into two or more tables? Why or why no
ID: 3910119 • Letter: S
Question
Should the following design be decomposed into two or more tables? Why or why not? And if decomposing, what columns belong in each resultant table?
1. Doctor, Patient -> Hospital Admit Date and Time, Doctor’s Pager #
2. Doctor -> Department, Department Office Location
(Note: a department can have only one office location)
3.
Doctor, Patient, Date and Time -> Diagnosis, Typical Prognosis
(By Typical Prognosis, assume of the diagnosis in general, not the particular doctor diagnosing the particular patient.)
Explanation / Answer
If you have any doubts, please give me comment...
Doctor(Pager#, DoctorName, Dept#);
Department(Dept#, OfficeLocation);
Patient(Patient#, PatientName);
Admit(DoctorPage#, Patient#, AdmitDate, AdmitTIme);
Diagnosis(DoctorPage#, Patient#, Date, Time);