In the course textbook, complete exercises E$\mathrm{.}3\mathrm{.}5$a thru E$\mathrm{.}3\mathrm{.}5$e

Submit your answers in a Microsoft Word document and upload for grading.

E$3\mathrm{.}5$ For the ER diagrams created in the following exercises, do the following:

E$3\mathrm{.}5$a I$)$ Map the ER diagram created in exercise E$\mathrm{.}2\mathrm{.}2$a into a relational schema.

II$)$ Show several records in each relation and mark those values that indicate mandatory participation on the $1$ side and those that indicate optional participation on the M side.

E$3\mathrm{.}5$b I$)$ Map the ER diagram created in exercise E$\mathrm{.}2\mathrm{.}2$b into a relational schema.

II$)$ Show several records in each relation and mark those values that indicate optional participation on the $1$ side and those that indicate mandatory participation on the M side.

E$3\mathrm{.}5$c I$)$ Map the ER diagram created in exercise E$\mathrm{.}2\mathrm{.}2$c into a relational schema.

II$)$ Show several records in each relation and mark those values that indicate mandatory participation on the $1$ side and those that indicate mandatory participation on the M side.

E$3\mathrm{.}5$d I$)$ Map the ER diagram created in exercise E$\mathrm{.}2\mathrm{.}2$d into a relational schema.

II$)$ Show several records in each relation and mark those values that indicate optional participation on the $1$ side and those that indicate optional participation on the M side.

E$3\mathrm{.}5$e I$)$ Map the ER diagram created in exercise E$\mathrm{.}2\mathrm{.}2$e into a relational schema.

II$)$ Show several records in each relation and mark those values that indicate mandatory participation on one side and those that indicate optional participation on the other side.

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