The Psychology of Quality and More |
Entity-Relationship DiagramA 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:
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 |
Site Menu |
Quality: | Quality Toolbook | Tools of the Trade | Improvement Encyclopedia | Quality Articles | Being Creative | Being Persuasive | |
And: | C Style (Book) | Stories | Articles | Bookstore | My Photos | About | Contact | |
Settings: | Computer layout | Mobile layout | Small font | Medium font | Large font | Translate | |
You can buy books here |
And the big |