Consider the list of individual 3NF relations that follows. These relations were developed from several separate...

Transcribed Image Text:

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. 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.

Answer rating: 100% (QA)

A PHYSICIAN Physician ID Name Department PHYSICIAN PhysicianID Name SupervisorID Both the relations ... View the full answer