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 ...

Get MySQL Workbench: Data Modeling & Development now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.