1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Discuss in my forum

Entity-Relationship Diagram

By

E-R Diagram

E-R Diagram

Definition: An entity-relationship (ER) diagram is a specialized graphic that illustrates the relationships between entities in a database. ER diagrams often use symbols to represent three different types of information. Boxes are commonly used to represent entities. Diamonds are normally used to represent relationships and ovals are used to represent attributes.

For more information, see our full feature story on Entity-Relationship Diagrams.

Also Known As: ER Diagram, E-R Diagram, entity-relationship model

Examples: Consider the example of a database that contains information on the residents of a city. The ER digram shown in the image above contains two entities -- people and cities. There is a single "Lives In" relationship. Each person lives in only one city, but each city can house many people.

  1. About.com
  2. Technology
  3. Databases
  4. Design
  5. Entity-Relationship Diagram

©2014 About.com. All rights reserved.