Production Schema Step 5: Draw It

Draw the entity relationship diagram for your project. Every entity, every relationship, cardinality marked at both ends, and the foreign key side shown. Then check each relationship by asking the question out loud in both directions, and fix any you had wrong. Commit the diagram next to the schema. Finally, add the facts about relationships that were homeless: anything you had awkwardly stuck on one side because there was nowhere else for it.