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