[SOLVED] Csc8017 coursework 1

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.