For your course project, you will design and implement a relational database with at least $3$ tables, and it needs to be in $3NF$ form.

This will be an individual project.

On$-$ground Students: Submit and present your work in class $(10$ minutes$),$ where you have to$-$

Online Students: Submit and upload recorded presentation of your work $(10$ minutes$),,$ where you have to$-$

$(10$ points$)$give brief description of the problem domain, and features$/$requirements of the database design you implemented

present and explain the ER$-$diagram of the relational database. While presenting $-$

$(30$ points$)$ explain the ER diagram $($entities$,$ attributes, relationships, cardinalities, etc.$),$

@ $(10$ points$)$ justify why the design is in $3$NF form $.$

$(10$ Points$)$ create a database with all the tables in your design, and populate enough data $($at least $10$ records in each table$)$ so that all the queries in the following section return

some results.

$(6*5$ Points$)$ write and demo SQL query which utilizes the following in SSMS$/$Azure Data Studio.

@ $-$ Join, left outer join, right outer join

@ $-$ aggregate functions

@ $-$ having, group by

@ $-$ nested query

@ $-$ trigger

stored procedure

Deliverables:

ER diagram $(5$ points $)$

All SQL Queries in a $.$sql file $(5$ points$)$

You can prepare slides, but it's optional

Note: For the demo, load the $.$sql files where you saved all your queries, and select one query at a time, explain what it does$/$returns$,$ execute the query and show us the result. You don't

have to write queries during the demonstration.