Project Instructions

• You can work on this project as a group (minimum 2 and maximum 3 students). Each group member must submit the project individually with all group member names mentioned on the cover page.

• This project is worth 14 marks and will be distributed as the following:

o Design a Conceptual Schema using ER modeling concepts, including (Entities, Relationships, Attributes, Participation (Total or Partial), and Cardinality). (3 marks)

o Tables before Normalization. (2 marks)

o Tables after Normalization Using mapping Algorithm. (3 marks)

o Use MySQL or any other DBMS to create the normalized tables and

populate your tables with at least 10 rows. (3.5 marks)

o Execute the requested sample queries. (2.5 marks)

• Each student must submit one report about their chosen Project via the Blackboard (Email submission will not be accepted and will be awarded ZERO marks) containing the following:

a) ER Diagram.

b) All schemas before normalization.

c) All schemas after normalization.

d) All SQL statements of:

 Creating tables.

 Inserting data in tables.

e) All requested queries/results.

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

• You are advised to make your work clear and well presented; marks may be reduced for poor presentation. This includes filling in your information on the cover page.