SC2207 Introduction to Databases Lab Assignment

Goal

1. Create a SQL schema from project requirements that satisfies 3NF.
2. Implement the schema using Microsoft Server SQL.
3. Populate data and provide proof of working through various SQL queries.

Deliverables

1. SQL Table DDL Statements
2. SQL Query Code
3. SQL Query Execution Videos (Screen Recordings)
4. CSV Files of Final Table Contents
5. PDF Report Containing Query Explanations