Merge & Diagram 3NF Relations

Merge & Diagram 3NF Relations

Consider the list of individual 3NF relations below. These relations were developed from several separate normaliza-tion activities.

PATIENT(Patient_ID,Room_Number,Admit_Date,Address)

ROOM(Room_Number,Phone,Daily_Rate)

PATIENT(Patient_Number,Treatment_Description, Address)

TREATMENT(Treatment_ID,Description,Cost)

PHYSICIAN(Physician_ID,Name,Department)

PHYSICIAN(Physician_ID,Name,Supervisor_ID)

a. Merge these relations into a consolidated set of 3NF rela-tions. State whatever assumptions you consider necessary (including but not limited to foreign keys) to resolve any potential problems you identify in the merging process.

b. Draw an E-R diagram for your answer