<ul><li>The process of structuring data in a way to curb redundancy and ensure data integrity</li><li>1NF: Arranging numbers from smallest to largest without indexing, mixing data types within a column, designing a table without a primary key, and storing a repeating group of data items on a single row violate 1NF</li><li>2NF: Each non-key attribute must depend on the entire primary key</li><li>3NF: Every non-key attribute should depend on the (primary) key, the whole key, and nothing but the key. There should be no dependency between non-key columns</li><li>Boyce-Codd Normal Form: Same as 3NF, where every non-key attribute should depend on the (primary) key, the whole key, and nothing but the key. There should be no dependency between non-key columns</li><li>4NF: Multivalued dependencies in a table must be multivalued dependencies on the (primary) key</li><li>5NF: The table, which must be in 4NF, can't be described as the logical result of joining some other tables together</li></ul>

Database Normalization Summary

Discover more