Difference Between E-R Model and Relational Model in DBMS

In this post, we will understand the difference between entity relation model and a relational model in DBMS.

ER model

• It can be expanded as an entity relationship model.

• It is a high-level/conceptual model.

• It is generally used to understand how a database would be implemented.

• It represents a collection of entities, and describes the relationship between these entities.

• It is easy to understand the relationship between entities.

• It consists of components such as ‘Entity’, ‘Entity Type’, and ‘Entity Set’.

• It describes the cardinality of attributes.

Relational Model

• It is a representational or implementation model.

• It is used by programmers to understand relationship between tables.

• It represents the data in the form of tables.

• It also describes the relationship between these tables.

• It consists of components such as ‘domain’, ‘attributes’, and ‘tuples’.

• It is not easy to understand/extract the relationship between multiple tables.

• It doesn’t describe the cardinality.

AmitDiwan

Published on 15-Apr-2021 07:49:03

• Related Questions & Answers
• Converting E-R model into relational model
• Comparison between E-R Model and Object Oriented Model
• Explain the Relational Model in DBMS?
• Examples of E-R model
• Difference between Waterfall Model and RAD Model
• Difference between V-Model and WaterFall Model
• Difference between Incremental Model and WaterFall Model
• Difference between Spiral Model and Waterfall Model
• Difference Between Waterfall Model and Spiral Model
• Relational Database Model
• Relational Data Model
• Difference between Bottom-Up Model and Top-Down Model
• Object-relational Data Model
• Difference between OSI and TCP/IP Reference Model
• Difference between Relational Algebra and Relational Calculus