Part 1 of 5 · 1 min read
Why this page comes first
In this module you will
- Map a simple entity to a table.
- Map a one-to-many relationship to a foreign key.
- Map a many-to-many relationship to a junction table.
- Map a one-to-one relationship, and justify the choice of which side gets the foreign key.
The previous two modules planned diagrams without writing any SQL. This page gives the fixed, mechanical rules for turning that diagram into actual tables, closing the gap between planning and a real schema.