Database Normalization

Difficulty: Intermediate

Question

Explain the first three Normal Forms (1NF, 2NF, 3NF).

Answer

- **1NF**: Atomic values, no repeating groups. - **2NF**: In 1NF and all non-key attributes fully dependent on the primary key. - **3NF**: In 2NF and no transitive dependencies (non-key attributes depend only on the primary key).

**Goal**: Reduce data redundancy and prevent update/delete anomalies.

Concepts covered

1NF, 2NF, 3NF, Redundancy, Anomalies