Question: E 2 . 2 h Create the ER diagrams for a scenario based on these requirements: A health care organization keeps track of its doctors
Eh 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 either one outpatient location or at none strictly working in the main hospital and each outpatient location has exactly one doctor working at it
Show me how this would look in ERD Plus please
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
