Overview

In this task, you will implement the database designed in Task $4\mathrm{.}2$C Mini$-$project Part $1.$ You will write

SQL statements using MySQL to create tables, insert records and interact with the database to

manipulate data. It is assumed that you have completed Task $4\mathrm{.}2C$ and you have designed the

normalized database for a company of your choice.

Tasks to do

Write SQL statements to create all tables in the final normalized ERD in Task $4\mathrm{.}2$C$.$

Use appropriate data types and required constraints for attributes.

Ensure all relationships and relationship constraints are maintained.

Note that the order of table creation can be important when tables have Foreign Keys.

Provide SQL statements to create all tables in your report.

Insert at least FIVE records in each table using SQL$.$

Provide all SOL statements used to insert data and screenshots of results of 'SELECT $*$ FROM