Consider the list of individual 3NF relations below. These relations were developed from several separate normalization 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 relations. 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 to Problem and Exercise 9.46a.