Entity Relationship Diagram Example: Movie Rental


This is an ERD for movie rental system. This is a detailed physical ERD that cover a wide range of entities to be created in database, which include inventory, payment, customer, city, staff, film, language, city, country, store, actor, etc. You can learn ERD by studying this ERD example.

This ER design example and template can be edited with Visual Paradigm Online, an online diagramming software. Click Use this Template to edit this ERD template, or click Create Blank to create a new one.

What is Entity Relationship Diagram?

The ERD was introduced by Chen (1976) in early 1976. An ERD can be served as the basis for databases, which store data about the problem domain, and which use, manipulate, and constrain that data. Experts in systems analysis and database design are adept at identifying user requirements and then translating them into corresponding components of the model. The entity relationship diagram is a graphical representation of a conceptual structure of a problem domain being modeled. The ERD assists the database designer in identifying the data and the rules that will be represented and used in a database.

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.