Q$1\mathrm{.}1[25$ points$]$ Design conceptual model that would support the operations of the MH and represent it as

Entity$-$Relationship model using the diagramming technique presented in class. Specify all applicable

entity sets $($their attributes, and primary keys$),$ as well as all relationships between entity sets $($and their

descriptive attributes, if applicable$).$ Clearly state, in natural language, the assumptions that you made $($if

any$)$ and the constraints not captured in your diagram $($if any$).$ Make sure to note on the diagram all

relationship cardinalities, mandatory or optional participation constraints, primary keys, etc.

Q$1\mathrm{.}2[10$ points$]$ Translate your conceptual model into a relational model using the techniques presented

in class. List all resulting relations and clearly identify all primary keys and all foreign key constraints.

Q$1\mathrm{.}3[3$ points$]$ Identify and list $5$ functional dependencies in your model using the format discussed in

class.