Each doctor works at between none $($strictly working in the main hospital$),$ and many

outpatient locations, and each outpatient location must have at least one but can have many doctors working at it$,$

E$2\mathrm{.}2$f Additional requirement

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$g Additional requirement

Each doctor works at between none $($strictly working in the main hospital$)$ and many

outpatient locations, and each outpatient location can have between none $($rehab and minor health issues only$)$

and many doctors working at it$.$

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

E$2\mathrm{.}2$i Additional requirement

Each doctor works at exactly one outpatient location, and each outpatient location has exactly one doctor working

at it$.$

E$2\mathrm{.}2$j Additional requirement

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$.$

E$2\mathrm{.}2$k Additional requirements

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$,$

$$ For each occurrence of a doctor working at an outpatient location, we keep track of the

NoOfHoursPerWeek $($number of hours per week that a doctor works at an outpatient

location$).$

E$2\mathrm{.}21$ Additional requirement

Each doctor works at between two and four outpatient locations, and each outpatient location has between three

and ten doctors working at it$.$

E$2\mathrm{.}2$m Additional requirements

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$.$

E$2\mathrm{.}4$ Create the ER diagram based on the following requirements:

A health care organization keeps track of outpatient locations and examination rooms within the

outpatient locations.

For each outpatient location it keeps track of the OLID $($unique$)$ and OLName.

For each examination rooms it keeps track of the ERoomNumber $($unique within its outpatient center, but

examination rooms in different outpatient locations can have the same ERoomNumber$),$ and ERoomSize.

Each outpatient location must have at least one but can have many examination rooms.

Each examination room is located in one outpatient location.