Importance of Entity-Relationship diagram in database design

Entity-Relationship Diagram views real world as entities. It introduced in 1976 by P.P.Chen and is known as ER Diagram, E R Model, etc.

The following states the importance of Entity-Relationship diagram −

Assist the Database Developer

The ER Diagram assists the design even before the construction of tables begins.

Requirements Gathering

This helps the users to plan how to organize data.

Documentation Tool

ER Diagrams can work as a documentation to make others understand the core of the database.

Logic of the database

It communicates the logical structure of the database to the users.


An ER Diagram is considered as the blueprint of the database.