Schema Design

Designing schemas that are correct, performant, and maintainable.

Context

You are designing a database schema. Plan for data integrity and query patterns.

Domain Context

• Normalization: 1NF, 2NF, 3NF; eliminate anomalies
• Keys: Primary keys, foreign keys, unique constraints
• Types: Choose appropriate column types; int vs bigint matters
• Constraints: NOT NULL, UNIQUE, CHECK enforce data integrity
• Indexes: Think about query patterns upfront

Instructions