Descriptions and Definitions of Quality Terms, Tools and Techniques

 

Changing
Minds

 

Creating
Minds

 

Quality
Toolbook

 

Tools of
the Trade

 

Improvement
Encyclopedia

 

 

Home
Page

 

C style
(book)

 

Business
Articles

 

Thinking
Stories

 

Inspirational
Teaching

 

Heledd's
Site

 

My
Photos

   

 

Here's my
latest book!

Add/share/save
this page:

 

 

 

 

Entity-Relationship Diagram

A diagram that shows how a number of pieces or sets of data are related. It is also called an Entity Chart.

Each arrow between data items may be labeled to help clarify the relationship between the two items on either end of the arrow. Other conventions in the diagram below:

  • 1 one and only one
  • 0,1 = zero or one
  • N = from one to many
  • 0,N = from zero to many

The diagram shows the cardinality of the relationship. That is, how many of one data items there are for each related item. For example, every person has one mother. A mother, on the other hand, can have a theoretically indefinite number of children.

There are a number of different diagramming conventions to show cardinality. The method below is pretty clear. Other methods include using 'crow's feet' for 'N', a bar across the arrow for '1' and a O across the arrow for a '0'.

The Entity-Relationship Diagram can be used in database design, where it shows how data elements are related. 

See also:

Relations Diagram, IDEF0, Data Flow Diagram

Contact —  — My page

 

 

  © Syque 2002-2011

  Massive Content -- Maximum Speed

TOP