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.

Blueprint

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

Amit Diwan

Updated on 15-Jun-2020 13:14:49

• Related Questions & Answers
• Entity-Relationship Diagram
• Entity Relationship Participation in Database
• What is Entity-Relationship Modeling?
• Extended Entity-Relationship (EE-R) Model
• What is an Entity relationship model in DBMS?
• Importance of Database Normalization
• Binary Relationship in Database
• Ternary Relationship in Database
• N-ary Relationship in Database
• Generate Database diagram within SAP
• Database Design Methodologies
• Objectives of a good Database Design
• The benefits of good Database Design
• How to Auto Generate Database Diagram in MySQL?
• Major Concerns with Database Design