Schema Design: When to Normalize and When Not To

Database normalization is one of those topics where the textbook gives you rules and reality gives you trade-offs. Third normal form is the right starting point for most schemas, and exactly the wrong place to stop. Here's how I think about when to normalize, when to denormalize on purpose, and the patterns that age well.