E-R model and Relational model are two types of data models present in DBMS. Let’s have a brief look of them:
1. E-R Model :
E-R model stands for Entity Relationship model. ER Model is used to model the logical view of the system from data perspective which consists of these components: Entity, Entity Type, Entity Set.
An Entity may be an object with a physical existence – a particular person, car, house, or employee – or it may be an object with a conceptual existence – a company, a job, or a university course.
An Entity is an object of Entity Type and set of all entities is called as entity set. e.g.; E1 is an entity having Entity Type Student and set of all students is called Entity Set.
2. Relational model :
Relational Model was proposed by E.F. Codd to model data in the form of relations or tables. After designing the conceptual model of Database using ER diagram, we need to convert the conceptual model in the relational model which can be implemented using any RDMBS languages like Oracle SQL, MySQL etc.
Consider a relation STUDENT with attributes ROLL_NO, NAME, ADDRESS, PHONE and AGE shown in Table 1.
Let’s see the difference between ER model and relational model:
|S.No.||ER model||Relational model|
|1.||ER model is the high level or conceptual model.||It is the representational or implementation model.|
|2.||It is used by people who don’t know how database is implemented.||It is used by programmers.|
|3.||It represents collection of entities and describes relationship between them.||It represent data in the form of tables and describes relationship between them.||4.||It consists of components like Entity, Entity Type, Entity Set.||It consists of components like domain, attributes, tuples.||5.||It is easy to understand the relationship between entities.||It is less easy to derive the relationship between different tables.||6.||It describes cardinality.||It does not describes cardinality.|
Don’t stop now and take your learning to the next level. Learn all the important concepts of Data Structures and Algorithms with the help of the most trusted course: DSA Self Paced. Become industry ready at a student-friendly price.
- Difference between Relational model and Document Model
- Relational Model in DBMS
- Introduction of Relational Model and Codd Rules in DBMS
- Mapping from ER Model to Relational Model
- Difference between Shared Memory Model and Message Passing Model in IPC
- Difference between Waterfall model and Incremental model
- Difference between Prototype Model and Spiral Model
- Difference between Waterfall Model and Spiral Model
- Difference between Agile Model and V-Model
- Difference between Bottom-Up Model and Top-Down Model
- Difference between V-model and Waterfall model
- Difference between RAD Model and Waterfall Model
- Anomalies in Relational Model
- Constraints on Relational database model
- Types of Keys in Relational Model (Candidate, Super, Primary, Alternate and Foreign)
- Difference between ER Model and RDBMS
- Difference Between Model Parameters VS HyperParameters
- Difference between Relational Algebra and Relational Calculus
- TCP/IP Model
- Domain Relational Calculus in DBMS
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.