Description
Assignment Questions
Based on the requirements narrative above, design and draw an EER diagram for the described
application. Your solution must include the following:
Design Explanation (5 marks)
• Explain your design process and state any assumptions that you have made. What decisions did
you make and why? Include the following information:
o Choose one entity type and describe why its key attribute is unique.
o Choose one relationship and how it relates the participating entity types.
o Explain how at least one attribute can be derived from other attributes.
A 5/5 solution will be well-organized, clearly address all the points listed, and outline the main
decisions when designing the EER model. The design explanation should be approximately half a
page or less in length.
Technical Criteria (20 marks total)
• (16 marks) Your EER diagram must include at least 70% of the following components (i.e. Of the
22 numbered components below, at least 16 different types of components should be identifiable
in your model).
o Entities:
1. Entity Type(s)
2. Weak Entity Type(s)
o o Relationships:
3. Relationship Type(s)
4. Identifying Relationship Type(s)
o o Attributes:
5. Simple Attribute(s)
6. Key Attribute(s)
7. Multivalued Attribute(s)
8. Composite Attribute(s)
9. Derived Attribute(s)
10. Partial Key Attribute(s)
o Participation Constraints:
11. Total Participation(s)
12. Partial Participation(s)
o Cardinality Constraints (not Min/Max notation):
13. 1:1 Cardinality(ies)
14. 1:N Cardinality(ies)
15. N:1 Cardinality(ies)
16. M:N Cardinality(ies)
o Specialization/Generalization (with constraints shown)
17. Disjoint & Total
18. Disjoint & Partial
19. Overlapping & Total
20. Overlapping & Partial
o Attribute Inheritance
21. Evidence that attributes are inherited, not duplicated
• (1 mark) All key attributes must be identified
• (1 mark) Relationships should be marked with cardinality/participation constraints
• (1 mark) Specializations and generalizations should be marked with
• disjoint/overlapping/total/partial constraints
• (1 mark) Your diagram must be clear, organized, and readable
• You may add any EER diagram components not listed above
Marks will be distributed as outlined above. Points will be taken off for inaccuracies in translating between
the narrative and the EER model.
