This project worth 10 marks, will be distributed as following:

a.	Design the database, following an ER model.	(2 marks)
b.	Normalize the tables ( each table should be in 3NF at least)	(2 marks)
c.	Use MySQL or any other database to create the normalized tables.	(2 marks)
d.	Populate your tables with 5 rows at least.	(2 marks)
e.	Execute the sample requested queries.	(2 marks)

Each student has to submit one report about his/her project via the Blackboard contains the following:

ER Diagram.

All schemas before and after normalization.

All SQL statements of :

creating tables

inserting data in tables

queries.

Screenshots from MySQL (or any other software you use) of all the tables after population and queries results.

Project 3

Grade Book Database

This is supposed to develop a database to manage a grade book. Your product should contain information about courses, students, grades for homework, quizzes, midterm, ?nal, and various grades.

Each course has id, title, credit hour.

You should store an id, name, email for each student.

Each homework has number, submission date and time, due date, marks.

Each quiz has number, marks, date.

You have to store also number and marks for the exams (midterm and final).

Students enroll to courses and you have to store their final grade.

Database should also store the various activity grades for each student.

SQL Queries:

1. Find all students who are taking math course along with their grades in mid and final exam.

2. Find the students who submitted a homework after the deadline in biology course.

3. Find the quizzes of math course along with their dates and marks.

4. Show the total grades of each course that a student has taken.

5. Show the students who obtained grades less than 60 in physics course.