HomeDiagramsER diagramER: Word-Form Cardinalities and .- / -. Lines

ER: Word-Form Cardinalities and .- / -. Lines

Cardinalities written as words (`one to many`, `1 to 0+`, `zero or one to one or more`), the mirrored symbol pairs `o|--||` and `o{--o{`, and the `.-` / `-.` line forms, which draw a dashed (non-identifying) relationship.

er-word-form-cardinalities-and-lines.mmd
erDiagram
  CUSTOMER one to many ORDER : places
  ORDER 1 to 0+ LINE_ITEM : contains
  LINE_ITEM zero or one to one or more PRODUCT : lists
  PRODUCT o|--|| SUPPLIER : sourced_from
  SUPPLIER o{--o{ WAREHOUSE : stocks
  WAREHOUSE ||.-o{ SHELF : holds
  SHELF ||-.o{ BIN : holds
Output
ER diagram, Zombie Mermaid CUSTOMER (no attributes) ORDER (no attributes) LINE_ITEM (no attributes) PRODUCT (no attributes) SUPPLIER (no attributes) WAREHOUSE (no attributes) SHELF (no attributes) BIN (no attributes) places contains lists sourced_from stocks holds holds

More ER diagram examples

ER diagram, Zombie Mermaid CUSTOMER (no attributes) ORDER (no attributes) places
ER: Basic Relationship
ER diagram, Zombie Mermaid CUSTOMER PK int id string name UK string email date created_at
ER: Entity with Attributes
ER diagram, Zombie Mermaid ORDER PK int id FK int customer_id UK string invoice_number decimal total date order_date string status
ER: Attribute Keys (PK, FK, UK)
ER diagram, Zombie Mermaid PERSON (no attributes) PASSPORT (no attributes) has
ER: Exactly One to Exactly One (||--||)
ER diagram, Zombie Mermaid CUSTOMER (no attributes) ORDER (no attributes) places
ER: Exactly One to Zero-or-Many
ER diagram, Zombie Mermaid SUPERVISOR (no attributes) EMPLOYEE (no attributes) manages
ER: Zero-or-One to One-or-Many