1. Generate an E-R diagram for the situation in the following scenario. Clearly indicate the entities, attributes, Relationships, Multiplicity, and Keys. [ 10 Marks] Hint: Entities (3 marks), Attributes (2 marks), Relationship( 2 Marks), Multiplicity (2 marks), and keys (Primary and foreign) (1 mark). a. Every school has many pupils and many teachers. Each pupil is assigned to one school and each teacher work for one school only. and last), sex, and qualifications. The data held on each subject includes subject title and type. 2. Describe what relationship types represent in an ER model and provide examples of binary, ternary, and quaternary relationships with examples. [3 Marks] 3. Describe how fan and chasm traps can occur in an ER model and how they can be resolved. [4 Marks] 4. Describe what attributes represent in an ER model and provide examples of simple, composite, single-value, multi-value, and derived attributes. [ 3 Marks]