Hey , this is a database project so be aware of any thing that is required in th

Hey , this is a database project so be aware of any thing that is required in the file and make sure to check the Marking Criteria for the Project so you can follow up the requirements
This project worth 14 marks and will be distributed as in the following:
a) Identify the entity types, attributes, keys. (2 marks)
b) Identify the relationship and cardinalities. (2 marks)
c) Draw the ERD. (2 marks)
d) Schemas before Normalization. (1.5 marks)
e) Schemas after Normalization. (1.5 marks)
f) Create the tables. (1.5 marks)
g) Populate your tables with at least 5 rows. (1.5 marks)
h) Execute the requested sample queries. (2 marks)