What is normalization?

The branch of relational theory that provides design insights.

When is a table in 1NF?

Only single values are permitted at the intersection of each row and column, hence, there are no repeating groups.

When is a table in 2NF?

Only if the Primary Key is made from a single attribute.

When is a table in 3NF?

All transitive dependencies must be removed; a non-key attribute may not be functionally dependent on another non-key attribute.

Fill in the blanks:

Denormalization produces a lower normal form.

Any attribute whose value determines other values within a row is called a functional dependency.

An attribute that cannot be further divided is said to display atomic attribute.

Granularity refers to the level of detail represented by the values stored in a table’s row.

A relational table must not contain repeating groups.