Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Anyone have an ERD symbols quick reference? [closed]

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.

like image 260
wadesworld Avatar asked Jul 20 '09 15:07

wadesworld


People also ask

What do the lines in an ERD mean?

In entity relationship modeling, solid lines represent strong relationships and dashed lines represent weak relationships.

What does a dotted circle mean in ER diagram?

The primary key of an. entity set is a candidate key that is chosen by the database designer. as the principle means of identifying entities within an entity set. (see Sectiown 4). Dashed Circle: A dashed ellipse represents a derived attribute.

What is cardinality ERD?

ERD components: Entity, Attribute and Relationship. Cardinality is the number of relationships or instances one entity has with another.

What are the symbols used in an ER diagram?

Entity Relationship Diagram Symbols & Notations mainly contains three basic symbols which are rectangle, oval and diamond to represent relationships between elements, entities and attributes. There are some sub-elements which are based on main elements in ERD Diagram.


1 Answers

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

like image 95
Vivek M. Chawla Avatar answered Sep 29 '22 03:09

Vivek M. Chawla