Creating a data model, ER diagram, Converting the relation to BCNF, for this you have to show the normalization starting from 1 NF, Creating tables, add constraints (PK, FK), etc. More questions in the word file below, 2 case studies to chose from.
BCNF, for this you have to show the normalization starting