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 :
|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.|
Attention reader! Don’t stop learning now. Get hold of all the important DSA concepts with the DSA Self Paced Course at a student-friendly price and become industry ready.
- Difference between RDBMS and IBM DB2
- Difference between RDBMS and Hive
- Difference between RDBMS and HBase
- Difference between RDBMS and Couchbase
- Difference between RDBMS and OODBMS
- Difference Between RDBMS and Hadoop
- Difference between RDBMS and MongoDB
- Difference between RDBMS and DBMS
- Difference between Shared Memory Model and Message Passing Model in IPC
- Difference between Waterfall Model and Spiral Model
- Difference between E-R Model and Relational Model in DBMS
- Difference between Prototype Model and Spiral Model
- Difference between Relational model and Document Model
- Difference between Waterfall model and Incremental model
- Difference between RAD Model and Waterfall Model
- Difference between V-model and Waterfall model
- Difference between Bottom-Up Model and Top-Down Model
- Difference between Agile Model and V-Model
- Difference Between Model Parameters VS HyperParameters
- Difference between Network and Relational data model
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to email@example.com. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.