GITTA-Logo
PDF Version of this document Search Help Glossary

Lesson Navigation IconRelationales Datenmodell

Unit Navigation IconKonzepte

Unit Navigation IconAbbildung ER-Schema

Unit Navigation IconData integrity

Unit Navigation IconNormalisierung

LO Navigation IconDependencies

LO Navigation IconFirst normal form (1NF)

LO Navigation IconSecond normal form (2NF)

LO Navigation IconThird normal form (3NF)

LO Navigation IconExercise Normalisation

LO Navigation IconUnit-Zusammenfassung

Unit Navigation IconSummary

Unit Navigation IconRecommended Reading

Unit Navigation IconGlossary

Unit Navigation IconBibliography

Unit Navigation IconMetadata


GITTA/CartouCHe news:


Go to previous page Go to next page

Normalisation

Normalisationis a process which we analyze and alter a database relation in order to get more concise and organized data structures. Normalised data is stable and has a natural structure. We call a relation normalized if:

  • it does not contain any redundancy
  • it does not cause maintenance problems
  • it is an accurate representation of the data

Relations that aren't normalised contain non-atomic attributes and therefore can contain redundant information. Detailed planning of the ERM can help creating normalised relations. The following steps will explain how existing relations can be normalised step by step.

Top Go to previous page Go to next page