Task:

In this project, you will work as a group to design and implement a database related to University of Nizwa departments using SQL$.$ You need to find information about one of the departments in the college$/$university and create a database for it$.$ For example, the information system department staff, courses, programs, etc. Your database must be created in Visual Studio. All the steps of implementing and using the database must be documented in a well$-$formatted report. The following will be required to be included in the report:

$1-$ Front page with your details.

$2-$ Introduction to the database you designed. Here you will introduce the database you want to create, including an ER diagram and a description.

$3-$ Database creation section, which should explain and show the main steps you did to create the database. All SQL used for the tables creations and data insets must be stated. Primary and foreign keys must be implemented and shown as constraints.

$4-$ Database usage. You will make a scenario where you use some of the SQL commands such as SELECT to showcase your database data and how you can retrieve data from your database. You need to use the commands we learned after the first project, such as join, group by$,$ datediff, etc.

$5-$ Future work. Suggest a few things that may be implemented in the future for your database to improve it$.$

In summary, the report should include the following:

$1-$ Front page

$2-$ Introduction to the database

$3-$ Creation steps using SQL

$4-$ Showing the data using SQL

$5-$ Future work

The more details and efforts you put into your work the higher the mark will be$.$ The report must be organized, and it should be easy to understand. Please read the notes and marking rubrics carefully.