Database Schema

---
title: Database Schema Design
category: development
tags: [database, schema, sql, normalization, data-modeling]
difficulty: intermediate
models: [claude, gpt-4, gemini]
---

# Database Schema Design

Design normalized, performant database schemas with proper relationships,
indexes, constraints, and migration strategies.

## When to Use

- Greenfield database design for new applications
- Schema refactoring for scaling bottlenecks
- Data model review and normalization assessment
- Migration planning between database systems
- Adding new features requiring schema changes

## The Technique

Good schema design balances normalization for data integrity with practical
query performance, considering the application's read/write patterns.

## Template