About Lesson
Difference Between E-R Model and Relational Model:
| Sr. No. | Title | E-R Model | Relational Model |
|---|---|---|---|
| 1. | Type | E-R Model is the high-level Conceptual Model. | It is Representational and Implementational Model. |
| 2. | Used By | Who don’t know how database is Implemented. | It is used by Programmer. |
| 3. | Relationship | It is representing Collection of Entities and Describe Relationship between them. | It is representing data in the form of Tables and describe Relationship between them. |
| 4. | Components | It Consists of Components like Entity, Entity Type, Entity Set. | It Consists of Components like Domain, Attributes, Tuple. |
| 5. | Basic | It’s used to describe a set of objects known as Entities, as well as the Relationships between them. | It’s used to describe a collection of Tables as well as the Relationships between them. |
| 6. | Mapping | This Model explains how to map cardinalities. The uniqueness of data values in a row is referred to as cardinality. | This model does not describe mapping cardinalities. |