{br} STUCK with your assignment? {br} When is it due? {br} Get FREE assistance. Page Title: {title}{br} Page URL: {url}

 

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

 

Our customer support team is here to answer your questions. Ask us anything!
WeCreativez WhatsApp Support
Support Executive
Frank
Available
WeCreativez WhatsApp Support
Support Supervisor
Brian
Available