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.
Published on 15-Apr-2021 07:49:03
