« How To Set Up URL Forwarding in AWS Using Only Route 53 (Amazon DNS) and S3 | Main

Sunday, April 07, 2013

TrackBack

TrackBack URL for this entry:
http://www.typepad.com/services/trackback/6a01156efc45c1970c017c386f085d970b

Listed below are links to weblogs that reference ERD "Crow's Foot" Relationship Symbols [Quick Reference]:

Comments

Feed You can follow this conversation by subscribing to the comment feed for this post.

Mohammad

Nice reference design, but:

What is the difference between:
[ENTITY]--|---- [one], (<--- This what confuses me against other two)
[ENTITY]-|0---- [zero or one], and
[ENTITY]-||---- [One and ONLY one]

Vivek M. Chawla

Typically, I've seen the use of the...

[ENTITY]--|--- (one)
and
[ENTITY]>--- (many)

...syntax on quick, "informal" Entity Relationship Diagrams. I wanted to paint a complete picture of what people might come across, so I added them to my Quick Reference chart.

The reality is that any relationship that has a direction ending in "one" should really be "zero or one", "one or many", or "one and only one". Same goes for "many", minus the logical absence of "many and only many", which doesn't exist.

Hope that helps clear things up!

Thanks,
Vivek

The comments to this entry are closed.

My name is Vivek M. Chawla. I help small business owners understand, use, and manage Information Technology.

Contact me directly or connect via one of the following accounts to find out how I can help your business.

Vivek is Reading...

Blog powered by Typepad
Member since 04/2009