Description
a) Identify the entity types, attributes, keys.
b) Identify the relationship and cardinalities.
c) Draw the ERD.
d) SchemasbeforeNormalization.
e) Schemas after Normalization.
f) Create the tables.
g) Populate your tables with at least 5 rows.
h) Execute the requested sample queries.
(2 marks) (2 marks) (2 marks) (1.5marks) (1.5 marks) (1.5 marks) (1.5 marks) (2 marks)
for poor presentation. This includes filling your information on the cover page.
A) Late submission will result in ZERO marks being awarded.
B) The work should be your own, copying from students or other resources will
result in ZERO marks.