Assignment title: Information
Task one (15 marks) Construct an Enhanced ER (EER) model for the above scenario. Identify and justify the use of generalization/specialization, weak entity types, and attributes on the relationships in the model. State any assumptions necessary to support your design. Check that the local conceptual data model supports the required transactions. Provide in a table all the assumptions you are making, and the justification behind each such assumption. The appendix below provides a sample EER diagram to help you in this task. Task two (5 marks) We have further learned of two business rules: a) There is no overlapping (clash in terms of time, date or location) between lecture, tute sessions and prac classes for any particular unit. b) No staff involved in teaching a particular unit can supervise the final exam of that unit. How would you express these constraints in the EER diagram? If you cannot express it, explain briefly. Your answer to this question should not exceed 100 words