Question: Convert the following user view ( M ) to third normal form. Use Word for the process. Be sure the user view has a title.

Convert the following user view (M) to third normal form. Use Word for the process. Be sure the user view has a title.
Think this one through carefully before you finish it.
A patient can move to various rooms during their stay at the hospital. Each day, when doctors are ready to make their rounds, they will stop by the desk and pick up this report so they know where their patients are that day.
M.
\table[[Patient Location Report,],[\table[[Physician-No:4024],[Physician-Name:Dunn, A. J.]],Date: 2001/04/03,,],[Patient-No. Patient-Name,Location,Date-Acmitted,],[12870,Gonzales, P. T.,103A,2001/02/22],[23819,Thomas, Marie,214C,2001/1/03/03],[61431,Cuadra, L. R.,281B,2001/02/29]]
ONF
PLR(PLRdate[PhysicianNo, PhysicianName, [PatientNo, PatientName, Location, DateAdmitted]])
1NF
PLR(PLRdate)
PLR-Phys(PLRdate, PhysicianNo, PhysicianName)
Phys-Pat (PhysicianNo, PatientNo, PatientName, PatLocation, DateAdmitted)
2NF
PLR(PLRdate)
PLR-Phys(PLRdate, PhysicianNo)
Physician(PhysicianNo, PhysicianName)
Phys-Pat (PhysicianNo, PatientNo)
Pat(PatientNo, PatientName, PatLocation, DateAdmitted)
3NF
PLR(PLRdate)
PLR-Phys(PLRdate, PhysicianNo)
Physician(PhysicianNo, PhysicianName)
Phys-Pat(PhysicianNo, PatientNo,)
Pat(PatientNo, PatientName, DateAdmitted)
Location(PatientNo ,PatientLocation)
please create this image ina simialr format to the one above
Convert the following user view ( M ) to third

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!