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)
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines
Order Paper NowPATIENT(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
Thanks for installing the Bottom of every post plugin by Corey Salzano. Contact me if you need custom WordPress plugins or website design.
