all these question need to be done to Schema, not ERD

Module $3$ Assignment

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

$$

$$

$$

$$

$$

$$

Module $2$ Assignment

$$

E$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 requirement:

$$

$$

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

$$

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

$$ Each doctor works at either one outpatient location or at none $($strictly working in the main hospital$),$ and each outpatient location must have at least one but can have many doctors working at it$.$

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

$$

E$2\mathrm{.}2$d 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 many doctors working at it$.$

$$

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

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

$$

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

$$

Mini Case $6,$ consulting for Ava.

$$

$$