$1\mathrm{.}1$ Data Definition Language operations

a$.$ Using SQL queries, create the five $(5)$ identified tables from the scenario including ALL related Primary and Foreign constraints where appropriate.

$(15$ Marks$)$

b$.$ Store at least five $(5)$ records into each table created in $1\mathrm{.}1.$ a using INSERT statement.

$(10$ Marks$)$