$$ 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\mathrm{.}5$ marks$)$

o Execute the requested sample queries. $(2\mathrm{.}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.

$$ You MUST show all your work, and text must not be converted into an image unless specified otherwise by the question.

$$ Late submission will result in ZERO marks being awarded.

$$ The work should be your own. Copying from students or other resources will result in ZERO marks.