Question: E 2 . 2 c Create the ER diagrams for a scenario based on these requirements: A health care organization keeps track of its doctors

E2.2c Create the ER diagrams for a scenario based on these requirements:
A health care organization keeps track of its doctors and outpatient locations.
For each doctor it keeps track of the DoctorID (unique), DoctorName, and DoctorYearOfMDGraduation (year of graduating from medical school).
For each outpatient location it keeps track of the OLID (unique) and OLName, and the following additional requirement:
Additional requirement
Each doctor works at exactly one outpatient location, and each outpatient location must have at least one but can have many doctors working at it.
Show me in ERD Plus please

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!