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
