• Two ER diagrams of your ER schema resulted after all the design refinements have been completed:

- (80 pts) ER diagram with structural constraints using 1, M, N (written in next to a relationship type rhombus) for cardinality ratio and double and single lines for total and partial participation.

- (10 pts) Another ER diagram version, where the structural constraints are expressed using the alternative(min, max) notation (as on p. 22 in the notes for Ch. 7). - (10 pts) Include also the role names of each entity type participating in relationship into this version of the ER diagram.