www.sum-it.nl > Courses
> DB Design course > Method > 2. Logical Design > Normalisation steps		Previous Terug Volgende Next
Nederlands · Search...

Logical Design, Normalisation steps

 Introduction 1. Scope
2. Logical Design
Normalisation steps
UNF FNF SNF TNF Make ERD Test 3. Technical Optimisation 4. Implementation End
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.
Next: UNF, UnNormalised Form