Database schema design 101 for relational databases

This post provides a foundational guide to relational database schema design. It breaks down the process into four key steps: understanding business needs, identifying entities (tables), defining properties (fields and primary keys), and establishing relationships (foreign keys). It uses a retailer example to illustrate these concepts and introduces ERDs as a design tool. The post concludes by linking schema design safety to PlanetScale's branching feature.