ER Model In DBMS Explain With Notions & Examples

Explain ER Model With Example In DBMS, Entity Relationship Model With Example & Notion Of ER Model

The E-R model is the most commonly used conceptual model.

In this model, the real world consists of a collection of basic objects called entities and the relationships among these objects.

The end product of the modeling process is an entity-relationship diagram (ERD) or ER diagram.
 
But it is not implemented but design for creating the database.

The E-R data model employs three basic notions:

Entity: It is an object with a physical existence.
For example, each person in an enterprise , car, house, a company, student.

Attributes: Attributes are the particular properties that describe an entity.
Ex: A STUDENT entity may be described by student’s name, student’s roll_number.

Relationship: Relates two or more distinct entities with a specific meaning.
For example, EMPLOYEE John works on the ProductX PROJECT

Tweet