Tuesday, 27 October 2009

The 5 Steps of Normalisation

The 5 Steps of Normalisation

  1. List the 'unnormalised' data and identify repeating groups by placing them in ()
  2. Choose a key for the main group. This is the Unique Identifier.
  3. Extract the repeating group and give that a key.
  4. Identify and extract Partial Key Dependencies

Identify and Extract Non-Key Dependencies.

No comments:

Post a Comment