Instruction
5- Normalization
Perform decompositions of the relations, such that the entire database is in 3NF or BCNF. You need to analyze each relation, draw its dependency diagram, and describe which normal form it satisfies. If the form is not 3NF or BCNF, you need to apply the normalization steps and produce 3NF or BCNF tables.
Deliverable: A PDF file including the normal form analysis of each table.