Summary - Normalization

Bring a denormalised table up to 3NF.

Normalization reduces data repetition: 1NF atomic values, 2NF no partial dependency, 3NF no transitive dependency.

-- 1NF → 2NF → 3NF → BCNF

Normalize step by step.

Exercise Summary - Normalization

Summary: create a cities table (split city for 3NF).

Show example solution

CREATE TABLE cities (
  id INT PRIMARY KEY,
  name VARCHAR(50)
)