CSC8017 Coursework 1 Solution

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.