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

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$3\mathrm{.}5$f I$)$ Map the ER diagram created in exercise E$\mathrm{.}2\mathrm{.}2$f 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 mandatory participation on the other side.

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

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

E$3\mathrm{.}5$h I$)$ Map the ER diagram created in exercise E$\mathrm{.}2\mathrm{.}2$h 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$3\mathrm{.}5$i I$)$ Map the ER diagram created in exercise E$\mathrm{.}2\mathrm{.}2$i 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 mandatory participation on the other side.

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

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