Identify the entity types, attributes, keys. Identify the relationship and cardinalities.Draw the ERD.

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.