jeudi 12 février 2009

Third Normal Form refresher

Database normalization refresher for myself:

First Normal Form (1NF): no repeating groups of elements.

Second Normal Form (2NF): each column must depend on the entire key (in other words, no partial dependencies on a concatenated key).

Third Normal Form (3NF): each column must depend directly on the key (in other words, no dependencies on non-key attributes).