IDEAS
IN PROGRESS.

Schema design becomes clearer when you start from entities, relationships, constraints, and query patterns rather than tables alone.

A SQL query is a request for a result, but PostgreSQL still has to decide how to produce that result efficiently.