O'Reilly logo

MySQL Workbench: Data Modeling & Development by Michael McLaughlin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

image
CHAPTER
4
Creating and Managing Tables and Relations
imagen 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required