MySQL Workbench: Data Modeling & Development

CHAPTER

4

Creating and Managing Tables and Relations

n Entity Relationship Model (ER Model) or Entity Relationship Diagram (ERD) defines the tables, views, and relationships between them. MySQL Workbench uses the ER Model to describe these diagrams.

The relationships in ER Model diagrams show what’s related to what and their cardinality. A 0..1 or 1..1 cardinality typically points to a table holding a primary key, and a 0..* (alternate syntax of *) or 1..* points to the table holding a foreign key.

MySQL Workbench treats ERDs as Enhanced Entity ...