Assignment Task
Context
In this assessment, you will be provided with a large dataset. You are required to design a database in MySQL Workbench that conforms to the design concepts taught during the lectures, input the data and print out multiple outputs using queries
Task
Demonstrate your understanding of database creation and maintenance by creating tables and running queries using the supplied dataset. Please refer to the Task Instructions for details on how to complete this task.
1. Design the database
The first task is to design the database in MySQL Workbench by creating tables to store this data. You need to ensure that:
- Syntax for creating tables is correct.
- Multiple tables are created to show each relationship in the database.
- Correct relationships are identified.
- There is proper use of primary keys.
- There is proper use of foreign keys. You should use a single SQL script to create the database that can be run once in its entirety without error.
2. Input all the data
Once the tables are created, you should write another SQL script to populate your database by extracting the data from the provided excel spreadsheet (not using an excel reader).
You should ensure that the whole SQL script need only be run once,after the script from Task 1 has been executed, in its entirety without error.