Entity Relationship Diagram Example: University Registration Office


ER diagrams can be used to depict the business entities of an organization. For instance, this ERD shows the business entities of a university registration office, which include student, course and instructor.

To edit this ERD template, simply click on Use this Template, then adjust the ERD to your liking. Alternatively, click Create Blank to draw your ER diagram from scratch.

What is ER Diagram?

An entity relationship diagram (also known as ER model or ER diagram in short) describes interrelated things of interest in a specific domain of knowledge. An ER diagram is usually the result of systematic analysis to define and describe what is important to processes in an area of a business. It does not define the business processes; it only presents a business data schema in graphical form. It is usually drawn in a graphical form as entities that are connected by relationships which express the associations and dependencies between entities.

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

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.