Part III · Normalization¶

The third partial exam: given a relation in non-normalized form and its functional dependencies, find the keys, spot the dependencies that violate Boyce–Codd normal form, draw the conceptual schema behind the data and decompose the relation.