Skip to content
Share
Explore
Learn by Watching
Entity Relationship Diagrams
Entity Relationship Diagrams
About Entity Relationship Diagrams
One-to-one relationships
A one-to-one relationship is when one record in one table is associated with only one record in another table.
One-to-one relationship graph looks like this:
One-to-many relationships
A one-to-many relationship is when one record in one table is associated with one or more records in another table.
For example each customer can have multiple sales orders
Many-to-many relationships
Many-to-many relationships are when multiple records in one table are associated with multiple records in another table.
For example customers can purchase many products and products can be purchased by many customers.
Drawing Entity Relationship Diagrams
Glossary
Primary Key
Foreign Key
Data Entity
An object in a data repository
Data Entity Relationship Diagram
Object
Data
Data Attribute
Unit of information inside a data entity
Relational Database
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.