normalization-patterns
Installation
SKILL.md
Normalization Patterns — Normalization/Denormalization Pattern Library
Normalization rules, denormalization strategies, and domain-specific ERD patterns used by the data-modeler agent during data modeling.
Target Agent
data-modeler — Directly applies the normalization rules and ERD patterns from this skill to data model designs.
Normalization Stage Identification & Transformation
1NF (First Normal Form)
Rule: Every column must contain atomic (indivisible) values.
| Violation Pattern | Problem | Solution |
|---|---|---|
| Multi-value column | tags = "java,python,go" |
Separate table (M:N) |
| Repeating groups | phone1, phone2, phone3 |
Separate table (1:N) |
| Composite values | address = "123 Main St, City, State" |
Split into street/city/state columns |