$$ 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$)$