Tables are normalized to eliminate redundant information, to make updates easier, and to save storage space.
There are three different normalization levels, or forms.
The following slideshow describes the three normal forms.
- second, and .
- third normal forms
An entity is in First Normal Form (1NF) when all tables are two-dimensional with no repeating groups. A row is in first normal form (1NF) if all underlying domains contain atomic values only. 1NF eliminates repeating groups by putting each into a separate table and connecting them with a one-to-many relationship.