Hospital DB ERD

Exercises E2.2

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:
  • E.2.a Additional requirement
  • Each doctor works at exactly one outpatient location, and each outpatient location can have between none (rehab and minor health issues only) and many doctors working at it.