- 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
What is an Entity relationship model in DBMS?
Entity relationship (ER) models are based on the real-world entities and their relationships. It is easy for the developers to understand the system by simply looking at the ER diagram. ER models are normally represented by ER-diagrams.
ER diagram basically having three components:
Entities − It is a real-world thing which can be a person, place, or even a concept. For Example: Department, Admin, Courses, Teachers, Students, Building, etc are some of the entities of a School Management System.
Attributes − An entity which contains a real-world property called an attribute. For Example: The entity employee has the property like employee id, salary, age, etc.
Relationship − Relationship tells how two attributes are related. For Example: Employee works for a department.
An entity has a real-world property called attribute and these attributes are defined by a set of values called domain.
In a university,
A student is an entity,
University is the database,
Name and age and sex are the attributes.
The relationships among entities define the logical association between entities.
Given below is another example of ER:
In the above example,
Entities − Employee and Department.
Employee − Name, id, Age, Salary
Department − Dept_id, Dept_name
The two entities are connected using the relationship. Here, each employee works for a department.
Features of ER
The features of ER Model are as follows −
Graphical Representation is Better Understanding − It is easy and simple to understand so it can be used by the developers to communicate with the stakeholders.
ER Diagram − ER diagrams are used as a visual tool for representing the model.
Database Design − This model helps the database designers to build the database.
The advantages of ER are as follows −
The ER model is easy to build.
This model is widely used by database designers for communicating their ideas.
This model can easily convert to any other model like network model, hierarchical model etc.
It is integrated with the dominant relational model.
The disadvantages of ER are as follows −
There is no industry standard for developing an ER model.
Information might be lost or hidden in the ER model.
There is no Data Manipulation Language (DML).
There is limited relationship representation.
- What is Entity-Relationship Modeling?
- Extended Entity-Relationship (EE-R) Model
- Entity-Relationship Diagram
- What is an ER model in DBMS?
- Entity Relationship Participation in Database
- What is Hierarchical model in DBMS?
- Identifying Entity Relationships in DBMS
- What is the degree of relationship set in DBMS?
- What is a Data Model in DBMS?
- Types of Entity Relationships in DBMS
- Importance of Entity-Relationship diagram in database design
- One-to-One Relationship in DBMS
- Many-to-Many Relationship in DBMS
- What is an instance in DBMS?
- One-to-Many Relationship Model