Skip to Main Content
MySQL Workbench: Data Modeling & Development
book

MySQL Workbench: Data Modeling & Development

by Michael McLaughlin
May 2013
Intermediate to advanced content levelIntermediate to advanced
480 pages
9h 38m
English
McGraw Hill Computing
Content preview from MySQL Workbench: Data Modeling & Development
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Advanced MySQL 8

Advanced MySQL 8

Eric Vanier, Birju Shah, Tejaswi Malepati
MySQL 8 Cookbook

MySQL 8 Cookbook

Karthik Appigatla
The MySQL Workshop

The MySQL Workshop

Thomas Pettit, Scott Cosentino, Dr. Vlad Sebastian Ionescu

Publisher Resources

ISBN: 9780071791885