ERD modeling, table relationships, indexing strategies, and migration patterns for evolving schemas.
Five passes over the same idea, each from a different angle. Do them in order, or jump to whichever you need.
Schema design covers entity-relationship modeling, primary/foreign keys, junction tables, and index strategies (B-tree, GIN, GiST). For NoSQL: embedding vs referencing, denormalization trade-offs. Migration strategies: expand-contract, blue-green schema changes, and backward-compatible migrations.
