38

I'm looking for a one-page quick-reference or cheatsheet (preferably in PDF) to the meanings of the various ERD symbols in Crowsfoot/Martin notation.

I've done a lot of googling, but have not found a good, concise quick-reference guide, though I'm sure one must exist.

wadesworld
  • 13,535
  • 14
  • 60
  • 93
  • 1
    Hi wadesworld! None of the other answers pointed to a single-page reference, so I went ahead and built one. Let me know if that's along the lines of what you were looking for. Cheers! – Vivek M. Chawla Apr 09 '13 at 20:03
  • 1
    I searched for "sql database association symbols" and found [ER Diagram Symbols & Notation | Lucidchart](https://www.lucidchart.com/pages/ER-diagram-symbols-and-meaning). That page probably was not there when this question was asked but now there are web pages such as that with the material. – Sam Hobbs Nov 12 '16 at 02:01
  • Is there a Unicode version of any of these? Especially the crow's foot symbol? – Purplejacket May 06 '20 at 06:38

2 Answers2

82

I've also been looking for a single-page "quick reference" PDF for ERD relationship symbols (i.e. "Crows Feet"). I haven't found anything I've liked, so I created this.

I've posted the Full Page, Printable PDF on my blog.

Hope this helps! ERD "Crow's Foot" Relationship Notation Quick Reference

Vivek M. Chawla
  • 4,587
  • 1
  • 18
  • 14
23

This one is very good explanation:

Entity relationship model explanation

ujeenator
  • 26,384
  • 2
  • 23
  • 28
  • 2
    Who made this diagram and where did you find it? Please provide attribution. – David J. Sep 06 '21 at 20:42
  • From a Google reverse image search, it looks like this came from Oracle's "Java Stored Procedures Developer's Guide" from 1999: https://docs.oracle.com/cd/F49540_01/DOC/java.815/a64686/05_dev1.htm#18622 – vergenzt Jul 25 '22 at 18:26