DB Normalization

Overview

Use this skill to decide normalization depth intentionally, preserving integrity without ignoring workload realities.

Scope Boundaries

• Duplicate mutable data causes inconsistency bugs.
• Schema design needs explicit normalization versus denormalization trade-offs.
• Teams are preparing for domain growth and evolving query patterns.

Core Judgments

• Normal form target per entity group (3NF/BCNF and justified deviations).
• Redundancy acceptance criteria and ownership.
• Denormalization scope and refresh semantics.
• Constraint placement for anomaly prevention.