The data modeling process: access patterns, table types, foreign keys and table templates
Design a schema from its queries, not from boxes on a diagram: four kinds of tables, when to denormalize, whether to keep foreign keys (with parent-row locking measured on PostgreSQL 16 and MySQL 8.4), where the reference column goes, and a table template with technical columns.