First page Back Continue Last page Graphics
Third Normal Form
Decomposition into 3NF
Principles
- The algorithm takes as set of dependencies and adds one schema at a time, instead of decomposing the initial schema repeatedly
- The result is not uniquely defined since
- A set of functional dependencies can have more than one canonical cover
- In some cases, the result of the algorithm depends on the order which it considers the dependencies in Fc
(minor bug in the algorithm, see later)
Notes: