What is Normalization

normalization is a technique for designing relational database tables to minimize redundancy.

What are different normalization forms?
  • 1NF: Eliminate Repeating Groups
  • 2NF: Eliminate Redundant Data
  • 3NF: Eliminate Columns Not Dependent On Key
  • 4NF / BCNF: Boyce-Codd Normal Form
  • 4NF: Isolate Independent Multiple Relationships
  • 5NF: Isolate Semantically Related Multiple Relationships
  • ONF: Optimal Normal Form
  • DKNF: Domain-Key Normal Form