Entity Relationship Diagram Example: Hockey League


ER diagrams symbolically shows the high level business objects within a particular problem domain. Here is an ERD for hockey league, which covers entities like team, player, game and injury record.

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.

Steps in designing an Entity-Relationship schema

  • Identify entity types (entity type vs. attribute)
  • Identify relationship types
  • Identify and associate attributes with entity and relationship types
  • Determine attribute domains
  • Determine primary key attributes for entity types
  • Associate (refined) cardinality ratio(s) with relationship types
  • Design generalization /specialization hierarchies including constraints

Keen to try VP Online?

No limitations, no obligations, no cancellation fees.

Start a Free Trial

We use cookies to offer you a better experience. By visiting our website, you agree to the use of cookies as described in our Cookie Policy.