Please refer to attached file for details: Design a database starting from the c

Please refer to attached file for details: Design a database starting from the conceptual design to the
implementation of database schemas.
a) Identify the entity types, attributes, keys.
b) Identify the relationship and cardinalities.
c) Draw the ERD.
d) Schemas before Normalization.
e) Schemas after Normalization.
f) Create the tables.
g) Populate your tables with at least 5 rows.
h) Execute the requested sample queries
Screenshots for answering SQL questions (f, g, and h).