Concept:
ER model describes data as entities, relationships, and attributes. It is a high-level conceptual data model. This model is used to define the data elements and relationships for a specified system.
Entity:
The entity is a thing in the real world with an independent existence. An entity may be an object with physical existence. For example particular person, car or it may be an object with a conceptual existence For example company, job, etc.
Attributes:
Each entity has attributes – the particular properties that describe it.
Relationship:
It is used to describe the relation between two entities.
Explanation:
E-R Diagram is design level task and Relational model is implementation.
The relational model is implemented from E-R Diagram and in this, it gets rid of the multivalued attributes.
Relations produced from the E - R Model will always be in 1NF, that is, Simple atomic values with non-multivalued attributes.
NOTES:
The relation is also referred to as a table.
