PDF Version of this document Search Help Glossary

Lesson Navigation IconRelational database model

Unit Navigation IconConcepts

Unit Navigation IconTransforming ER-schema

Unit Navigation IconData integrity

Unit Navigation IconNormalization

LO Navigation IconDependencies

LO Navigation IconFirst normal form (1NF)

LO Navigation IconSecond normal form (2NF)

LO Navigation IconThird normal form (3NF)

LO Navigation IconExercise normalization

LO Navigation IconUnit summary

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

Unit summary

This Unit showed how and why relations should be normalised. It prevents problems and saves money. A careful planning in the conceptual phase helps implementing and normalising a table properly. Although there is a fourth and a fifth normal form (that were not discussed here), usually it is enough to normalise up to the third normal form.

Top Go to previous page Go to next page