Tuesday, May 19, 2009

Database

First Normal Form: No Repeating Elements or Groups of Elements.
NF1 addresses two issues:
  1. A row of data cannot contain repeating groups of similar data (atomicity); and
  2. Each row of data must have a unique identifier (or Primary Key).


Second Normal Form: No Partial Dependencies on a Concatenated Key.
For each column ask:
  1. Can this column exist without one or the other part of the concatenated primary key?If the answer is "yes" — even once — then the table fails Second Normal Form.

Once the initial combined table is split, as the above question of each new sub-table that has been created till all columns are in tables that can be identified by a single non-concatenated primary key.

Third Normal Form: No Dependencies on Non-Key Attributes

No comments: