Open In App

Difference between ER Model and RDBMS

Last Updated : 03 May, 2020
Improve
Improve
Like Article
Like
Save
Share
Report

1. ER (Entity- Relationship) Model :
ER model stands for entity relationship model. It specifies the structure of a database by giving the relationship between the entities of the system. An entity set is a group of entities that are similar to each other. It is considered as a conceptual design which can further be used to implement a database. It helps us to understand the association between different entities in a easy way with the help of a pictorial representation. ER model is generally constructed before making the database. The ER model is used to portray the real world entities and the associations between them.



2. RDBMS (Relational Database management system) :
RDBMS stands for Relational Database management system which is a database management system that is designed for relational databases according to the model which was given by E.F.Codd. Relational database stores data in a well structured format in the form of tables which makes it easier to retrieve data when it is required. It has efficient query processing techniques for retrieval of data.In RDBMS multiple tables can be present and the tables can be related to each other. RDBMS is the most used database management model nowdays.



Difference between ER Model and RDBMS :

S.NO. ER Model RDBMS
1. ER model is a high level data model which tells us about the relationship between the entities. RDBMS is a database management system which has a collection of tables which are related to each other.
2. ER model is easier to understand as it is in pictorial form. RDBMS is comparatively more complex than ER model.
3. ER model is made before the construction of database to get an idea of the database. RDBMS is an implementation of the ER diagram.
4. ER model has attributes, entities and relationships as its main components. RDBMS has tuples, domains, keys as its main components.
5. ER model has mapping cardinalities. RDBMS doesn’t have mapping cardinalities.
7. It requires comparatively less skillful people to construct the ER model. It requires more skillful people to deal with the database systems.


Similar Reads

Difference between RDBMS and HBase
RDBMS (Relational Database Management System) and HBase are both types of database management systems, but they differ in several ways: Data Model: RDBMS uses a relational data model, where data is stored in tables with predefined columns and rows. HBase, on the other hand, uses a column-family data model, where data is stored in column families, w
5 min read
Difference between RDBMS and OODBMS
RDBMS: RDBMS stands for Relational Database Management System. It is a database management system based on the relational model i.e. the data and relationships are represented by a collection of inter-related tables. It is a DBMS that enables the user to create, update, administer and interact with a relational database. RDBMS is the basis for SQL,
2 min read
Difference between RDBMS and MongoDB
MongoDB is an open-source document-oriented database used for high volume data storage. It falls under the classification of a NoSQL database. NoSQL tool means that it doesn't utilize the usual rows and columns. MongoDB uses BSON (document storage format) which is a binary style of JSON documents. Features of MongoDB: Multiple Servers: It can run o
2 min read
Difference between RDBMS and Hive
RDBMS: RDBMS stands for Relational Database Management System. RDBMS is a such type of database management system which is specifically designed for relational databases. RDBMS is a subset of DBMS. A relational database refers to a database that stores data in a structured format using rows and columns and that structured form is known as table. Th
2 min read
Difference Between RDBMS and Hadoop
RDMS (Relational Database Management System): RDBMS is an information management system, which is based on a data model.In RDBMS tables are used for information storage. Each row of the table represents a record and column represents an attribute of data. Organization of data and their manipulation processes are different in RDBMS from other databa
2 min read
Difference between RDBMS and Couchbase
1. RDBMS : RDBMS stands for Relational Database Management Systems. It is most popular database. In it data is store in the form of row that is in the form of tuple. It contain numbers of table and data can be easily access because data is store in the table. This Model was proposed by E.F. 2. Couchbase : Couchbase Server is an open-source, distrib
2 min read
Difference between RDBMS and IBM DB2
1. RDBMS : RDBMS stands for Relational Database Management Systems. It is most popular database. In it data is store in the form of row that is in the form of tuple. It contain numbers of table and data can be easily access because data is store in the table. This Model was proposed by E.F. 2. IBM Db2 : IBM Db2 is a family of data management produc
2 min read
Difference between Cassandra and RDBMS
Cassandra: Cassandra is a high-performance and highly scalable distributed NoSQL database management system. Cassandra deals with unstructured data and handles a high volume of incoming data velocity. In Cassandra data is written in many locations also data come from many locations this row represents a unit of replication and the column represents
2 min read
Difference Between RDBMS and DBMS
Database Management System (DBMS) is a software that is used to define, create, and maintain a database and provides controlled access to the data. Why is DBMS Required?Database management system, as the name suggests, is a management system that is used to manage the entire flow of data, i.e, the insertion of data or the retrieval of data, how the
4 min read
Difference between RDBMS and ORDBMS
1. RDBMS : RDBMS stands for Relational Database Management System. In this database management, the data is organized into the related tables. To access the database it uses Structured Query Language (SQL). This model is based on the mathematical theory of relational algebra and calculus. The original concept for the model is proposed by Dr. E.F. C
3 min read