Database Normalization

Normalize database schemas to eliminate redundancy and anomalies by applying normal form principles step by step.

Usage

Share your current table structure and this skill will identify normalization issues and guide you through decomposition.

Examples

• "Normalize this flat table into proper 3NF structure"
• "Identify the functional dependencies in my schema"
• "Should I denormalize this join-heavy query for performance?"

Guidelines

• Identify all functional dependencies before starting normalization
• Achieve 3NF for most OLTP applications
• Document the rationale for any intentional denormalization
• Consider the read vs write pattern when choosing normalization level
• Use views to provide denormalized access without schema changes