1NF, 2NF, 3NF

Normal forms are levels of schema design quality. 1NF: atomic values, no repeating groups. 2NF: additionally, no partial dependency on part of the key. 3NF: additionally, no dependency of a non-key attribute on another non-key attribute. They reduce redundancy.

Example

Separate customers and orders rather than repeating the customer's address in every order.

Related concepts

The whole glossary