SQL Assignment

The purpose of this assignment to allow you to practice interpreting the database design described in an ER diagram and writing a SQL script accordingly.

In this assignment you are required to create a SQL Script that creates the database described in the ER Diagram shown below:

Notes:

1. Primary Keys are red
2. Foreign Keys are green
3. Columns that are both primary and foreign keys are blue

Submission:

The assingment should be created and saved in MS Office Word or PDF file format. Please name your file appropriately before attaching the file.