Database normalization

Applies to: sql

Database normalization organizes tables to reduce duplication and update anomalies, often by separating entities into related tables.

users(id, email)
orders(id, user_id)

See also: schema, foreign-key