Entity Relationship Diagrams (Crow's Foot notation) is used to show cardinality between entities:

  • minimum zero, maximum one (optional)
  • minimum one, maximum one (mandatory)
  • minimum zero, maximum many (optional)
  • minimum one, maximum many (mandatory)

Examples