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
tablePatient Location Report,tablePhysicianNo:PhysicianName:Dunn, A JDate: PatientNo PatientName,Location,DateAcmitted,Gonzales, P TAThomas, Marie,CCuadra, L RB
ONF
PLRPLRdatePhysicianNo PhysicianName, PatientNo PatientName, Location, DateAdmitted
NF
PLRPLRdate
PLRPhysPLRdate PhysicianNo, PhysicianName
PhysPat PhysicianNo PatientNo, PatientName, PatLocation, DateAdmitted
NF
PLRPLRdate
PLRPhysPLRdate PhysicianNo
PhysicianPhysicianNo PhysicianName
PhysPat PhysicianNo PatientNo
PatPatientNo PatientName, PatLocation, DateAdmitted
NF
PLRPLRdate
PLRPhysPLRdate PhysicianNo
PhysicianPhysicianNo PhysicianName
PhysPatPhysicianNo PatientNo,
PatPatientNo PatientName, DateAdmitted
LocationPatientNo PatientLocation
please create this image ina simialr format to the one above
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
