Activity $2$: SQL Queries $($Case Study$)$:

Activity $2$ is the continuation for the assessment $1.$ The board member of VIT Construction Co$.$

is very pleased with the report and has approved the report. Based on the ER diagram created

in assessment $2,$ you are to create the database.

Write SQL queries to create the table. Select suitable data types for each attribute and

identify appropriate primary and foreign keys as needed. $(5$ marks$)$

Write SQL queries to insert some data into each table $($At least $10$ records$).(5$ marks$)$

Write the SQL queries for the tables created.

$3\mathrm{.}1.$ Create $5$ SQL queries. $(5$ marks$)$

$3\mathrm{.}2.$ Create a View. $(5$ marks$)$

$3\mathrm{.}3.$ Complexity of the query. $(5$ marks$)$

$3\mathrm{.}4.$ Bonus points $(5$ marks$)$

$3\mathrm{.}4\mathrm{.}1.$ Create a simple system with main menu.

$3\mathrm{.}4\mathrm{.}2.$ Using the system to access the cloud database.

You are required to use database tool to run the query. Screenshot for the query and result

should be included in the report.