tag: schema-design
articles: 3 · beats: 2
latest: November 14, 2026
---
Schema Design
3 Crashtech articles on Schema Design, spanning System Design & Architecture and Databases, published in November 2026. Every piece is full-text HTML with sources, structured data and an authored FAQ.
They span System Design & Architecture (2), Databases (1). System Design & Architecture Databases
Relational Schema Design That Survives Contact With Production
Keys, relationships, constraints and indexes: the schema decisions that decide integrity and speed, with worked SQL for one-to-many and many-to-many.

A Safer Database Rename Takes Three Deployments
Expand-and-contract migrations keep old and new application versions compatible while a schema changes, but they require observability and a rollback plan.
Database Normal Forms, Worked Through One Ugly Table
1NF to 4NF are easier to remember as the specific anomaly each one removes. One messy orders table, fixed step by step, shows what each form is for.
Questions we answer about Schema Design
- Should every table have a surrogate primary key?
- How do I model a many-to-many relationship?
- Why use database constraints when the application validates input?
- When is it acceptable to denormalize?
- What is an expand-and-contract migration?
- Why not rename a database column in one deployment?
- Does expand-and-contract guarantee a zero-downtime migration?
- What problem does normalization actually solve?
- What is the practical difference between 3NF and BCNF?
- When should I denormalize on purpose?
Covered alongside
Frequently asked questions
What does Crashtech publish about Schema Design?
3 articles tagged Schema Design, the most recent published November 14, 2026. They span System Design & Architecture (2), Databases (1). Each carries numbered sources, an authored FAQ and full structured data.
What questions about Schema Design does Crashtech answer directly?
10 questions have a dedicated answer page under this tag, including “Should every table have a surrogate primary key?”. Each answer is authored prose from the article it belongs to, not a generated summary.
Can AI assistants read Crashtech's Schema Design coverage?
Yes. Crashtech serves full static HTML to every crawler, allows all major AI user agents in robots.txt, and publishes an llms.txt manifest plus a full-text corpus, so assistants can retrieve and cite these articles directly.