Anyone have an ERD symbols quick reference?

database-design notation erd
wadesworld picture wadesworld · Jul 20, 2009 · Viewed 35.4k times · Source

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.

Answer

Vivek M. Chawla picture Vivek M. Chawla · Apr 8, 2013

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

Related questions

Can I have multiple primary keys in a single table?

Can I have multiple primary keys in a single table?

Read More
Database, Table and Column Naming Conventions?

Whenever I design a database, I always wonder if there is a best way of naming an item in my database. Quite often I ask myself the following questions: Should table names be plural? Should column names be singular? Should …

Read More
What's the difference between identifying and non-identifying relationships?

I haven't been able to fully grasp the differences. Can you describe both concepts and use real world examples?

Read More