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

UNF, UnNormalised Form

Unnormalised Form, one table with all data elements 		Introduction 1. Scope
2. Logical Design
Normalisation steps
UNF
FNF SNF TNF Make ERD Test 3. Technical Optimisation 4. Implementation End
  1. Identify data elements, e.g. by highlighting values on sources such as:
    • a paper administration,
    • existing screens,
    • a design for desired screens.
  2. Put each data element on a yellow sticky pad. Align them all, next to each other.
  3. Put parameters (temporary information) and derived information aside. Ignore them for the time being. Later, during technical optimisation, you'll need them again.

Attention

  • Avoid double data.
  • Keep the definition of each data element mono interpretable. Avoid complex constructions such as:

    If element abc contains code 123, then data element def will have a ghi, or else a jkl, or is empty, which means...

Next: FNF, First Normal Form