Logical Design, Normalisation steps

Scope Logical Design Technical Optimisation Implementation

1. Scope

2. Logical Design

3. Technical Optimisation

4. Implementation

The aim of a locigal database design is a design where Codd's law applies to every table:

The values in a row are dependent on
the key,
the whole key
and nothing but the key.
So help me Codd.

Normalisation towards a logical design consits of the following steps:

UNF UnNormalised Form Identify all data elements
FNF First Normal Form Find the key with which you can find all data
SNF Second Normal Form Remove part-key dependencies. Make all data dependent on the whole key.
TNF Third Normal Form Remove non-key dependencies. Make all data dependent on nothing but the key.