Maximum mark: 50
This coursework is worth 50% of the total assessment for this module.
Aims:
To assess your ability to:
β’ Design a relational database, expressing that design in an entity-relationship diagram.
β’ Implement the design in MySQL.
Learning Outcomes:
β’ Design a database from a problem statement.
β’ Implement a database designed with an E-R diagram.
Problem Statement:
Tasks:
2) Implement your design in MySQL. Populate your database tables with data of your choice (this does not need to be a huge amount of data, maybe 5-10 rows for each base table). If you make any changes to your original design from Task 1, these must be explained. Include the following TWO items:
i) SQL statements you used to create your tables in your answer document (plus a description of any changes made from Task 1). This MUST be pasted into your answer document and MUST NOT be a screenshot. Screenshots of SQL will score 0/10.
What to submit: A single Word or PDF document containing your answers to the above tasks. You should submit your work electronically through NESS.
