data-modelling

Relational data modelling for PostgreSQL - entities and relationships, normalisation to 3NF and deliberate denormalisation, surrogate uuid vs natural keys, many-to-many join tables, soft delete tradeoffs, temporal and history modelling, JSONB boundaries, multi-tenancy models, audit columns, modelling for reads vs writes, and dimensional modelling basics with facts and dimensions. Load when designing or changing a schema, choosing keys, modelling history or tenants, deciding between JSONB and columns, or shaping analytics tables.