- Trending Categories
- Data Structure
- Operating System
- C Programming
- 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.
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.
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.
- 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