Database Design & ER Diagrams

Summary

The process of planning your tables, columns, relationships and constraints before writing any code — Entity-Relationship diagrams are the standard way to visualize this.

• 1Draw an ER diagram for a small app (e.g. an e-commerce store) before building it.
• 2Practice identifying one-to-many and many-to-many relationships and how to model each.
• 3Review a real open-source project's database schema for design patterns.