question archive Consider the list of individual 3NF relations that follows
Consider the list of individual 3NF relations that follows
Subject:Mechanical EngineeringPrice: Bought3
Consider the list of individual 3NF relations that follows. 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. Make and state whatever assumptions you consider necessary to resolve any potential problems you identify in the merging process. b. Draw an E-R diagram for your answer to part a.
