a. Design the database, following an ER model. (4 marks)
b. Normalize the tables ( each table should be in 3NF at least) (2 marks)
c. Use MySQL or any other database to create the normalized tables and populate your tables with at least 5 rows. (2 marks)
d. Execute the sample requested queries. (2 marks)