Back to glossary

Normalization

The process of organizing data in a database to reduce redundancy and improve data integrity.

Categoryai

Overview

Database Normalization is the process of structuring a relational database in accordance with a series of so-called normal forms in order to reduce data redundancy and improve data integrity.

Normal Forms

  • 1NF: Atomic values, no repeating groups.
  • 2NF: 1NF + no partial functional dependencies.
  • 3NF: 2NF + no transitive dependencies.
  • BCNF: A stronger version of 3NF.

Related Terms

Denormalization