CSC455

Normalization Example

The schema below defines four functional dependencies in a dependency diagram.  Two of them violate normalization rules.  Decompose to normalize the schema:

 

fig10_11