

- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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.
- 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