You$$re selected as a team of engineers to design the database that will be used to

store data for the management of the blocks of courses in AIMS and follow all

academic activities that happen there.

The aim of this project is to design the database that will host the data from the

system.

You should have at least data on : Teachers, tutors, Students, courses, Tutorials,

quizzes with their marks, assignments with their marks, periods of the blocks.

All the activities that are being done in a block are to be included in the design of

the database.

The students have to:

provide a data dictionary for this problem,

Provide de ER diagram for the problem $($Entities should have as much

details as you can$)$

Give the rules and constraints governing the system

Provide the list of tables and the links between the tables

Give the role of each chosen table in the system

Give the SQL script of all the tables

Fill the database with some sample data

Provide at least ten queries $($in SQL$)$ of great importance for the system