Question: please develop a entity relationship diagram. A health care organization keeps track of its doctors and outpatient locations For each doctor it keeps track of
please develop a entity relationship diagram.
A health care organization keeps track of its doctors and outpatient locations For each doctor it keeps track of the DoctorID (unique), DoctorName, and DoctorYear OfMDGraduation (year of graduating from medical school) For each outpatient location it keeps track of the ORID (unique) and OLName Each doctor works at between one and many outpatient locations and each outpatient location must have at least one but can have many doctors working at it Each doctor manages between zero and one outpatient locations and each outpatient location has exactly one doctor managing it
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
