Assessment: Database design Required: Design and specify a relational database for a specific topic of your choice. The scenario must not replicate any examples used in tutorials, exercises, or assessments in this module. You may choose your own topic, provided it requires a comparable level of complexity. Credit will be given for models that are specialised to your chosen scenario rather than generic designs. Example topics might include: • Hobbies (e.g., sports, hiking, climbing) • Reviews (e.g., books, films, restaurants, travel, music) • Library catalogues • E-commerce systems • Electronic health records Assessment Guidance You will create a conceptual and logical database design using Draw.io. Your database model must: • Contain at least four entities • Include at least one event/action entity • Ensure each entity has at least two attributes • Fully specify all primary keys You will then translate your conceptual design into a relational model. 1. Scenario description and example queries (10 marks) • Write a clear, 100-word description of your proposed system. • Provide five example SQL query statements showing how the database would be used. Marks are awarded for clarity, relevance, and alignment between the scenario and the proposed queries. 2. Conceptual model – entity relationship diagram (40 marks) Create an ERD using Draw.io. The diagram must: • Identify all entities required by your scenario. • Include at least one event/action entity. • Define attributes for each entity. • Clearly indicate primary keys. • Show all relationships between entities. • Specify multiplicity (e.g., one-to-many). • Specify optionality (mandatory or optional participation). All entities and relationships necessary to support your five example queries must appear in the model. Marks are awarded for completeness, correctness, clarity of modelling, and appropriate use of notation. 3. Logical relational model (30 marks) Translate the ERD into relational tables using the mapping rules covered in the module. You must: • Correctly assign primary keys. • Clearly specify foreign keys. • Ensure consistency with the conceptual model. Marks are awarded for correct mapping and structural accuracy. 4. Design justification (20 marks) Provide a short, written justification (maximum 300 words) explaining: • Key modelling decisions. • Any assumptions made. • How the model supports the example queries. Marks are awarded for analytical reasoning and demonstration of thinking. (Total – 100 marks) Word count: Maximum 600 words (-/+10%). No word limit applies to diagrams, relational tables, or SQL query statements.