Now as part of your project in response to the requirements presented above, you are required to:

I. $(40$ points$)$ Conceptual Modeling: Create a conceptual model for the above requirements using the ER Model $($Specify your relationship types$)$ or EE$$R model. You can use drawing tools to create your ER models.

II$.(30$ points$)$ Logical Modeling: Convert your ER model $($or EER model$)$ to a relational model.

III. $(50$ points$)$ Specify all the functional dependencies that you have in your relation model above. Next, normalize your relations to BCNF$.$

IV$.(50$ points$)$ Database Implementation: Based on the normalized database relations above, create the following SQL queries.

Write SQL queries to create the NSS database and all your relations for the database. Add primary keys for your relations and foreign keys where necessary and all other necessary integrity constraints.

Write queries that insert $15$ or more records in all your relations you have created above.

Write simple select statements that retrieve records from the tables without any condition. $(1$ Select statement per table$)$

Write $1$ simple select statement that retrieves records from all the tables using some simple condition. $(1$ Select statement per table$)$

Write $3$ advanced select statements that select data from two or more of your tables. You can use exists, and, join etc.

Write a query that retrieves students who have all A letter grades.

Write a query to retrieve the names of students who have not taken more than $5$ courses.

Write $6$ update statements that update certain records based on some conditions.

Write $3$ statements that delete a record from a table based on some condition.

Write a query to retrieve the names of students who were caught cheating in at least one course.

Write a query to retrieve the names of instructors who have reported most cheating incidents.