Entity Relationship Diagram Example: Favorited Team Statistics

Description:

ERD is a graphical representation of a conceptual structure of a problem domain being modeled. This simple ER diagram contains two entities Match and Player, and a linked entity Match_Player. A link entity is created when there exists a many to many relationship between two entities.

Use this ERD template to get started building your own. Customize the ERD to reflect the entities of your problem. Click Use this Template to start.

What is Entity Relationship Diagram?

Entity relationship diagrams (ERD) are widely used in database design and systems analysis to represent systems or problem domains. An ER diagram is a pictorial representation of the information that can be captured by a database. It allows database professionals to describe an overall data model of a system concisely yet accurately and can be easily transformed into the relational schema. The ERD is an implementation-independent representation of a problem domain and it facilitates communication between the end-user and the analyst.

Guidelines for creating ERD

List below are some tips that will help you create ER diagrams:

  • Identify all the relevant entities in a given system
  • An entity should normally appear only once in a particular diagram.
  • Provide a precise and appropriate name for each entity, attribute, and relationship in the diagram.
  • Determine the relationships among these entities.
  • Remove vague, redundant or unnecessary relationships between entities.
  • Never connect a relationship to another relationship.
  • Make effective use of colors for classifying similar entities.

Keen to try VP Online?

No limitations, no obligations, no cancellation fees.


Start a Free Trial