Task:

Textbook Exercise $2\mathrm{.}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 requirements:

E$2\mathrm{.}2.$ b $-$ Each doctor works at either one outpatient location or none $($strictly working in the main hospital$),$ and each outpatient location must have at least one but can have many doctors working there.

E$2\mathrm{.}2.$ d $-$ Each doctor works at either one outpatient location or none $($strictly working in the main hospital$),$ and each outpatient location can have between none $($rehab and minor health issues only$)$ and many doctors working there.

E$2\mathrm{.}2.$ f $-$ Each doctor works at between one and many outpatient locations, and each outpatient location must have one but can have many doctors working at it$.$

E$2\mathrm{.}2.$ h $-$ 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$.$

E$2\mathrm{.}2.$ j $-$ Each doctor works at either one outpatient location or at none $($strictly working in the main hospital$),$ and each outpatient location can have between none $($rehab and minor health issues only$)$ and one doctor working at it$.$