Entity Relationship Diagram in DBMS
In a database management system (DBMS), a group of information or data which is of interest to an organization that is called an Entity. A model that represents system data by entity and relationship sets that is called an Entity Relationship Diagram (E-R Diagram) or Entity-Relationship Model (E-R Model).
The E-R model is based on a perception of real-world which consists of a set of basic objects. This E-R diagram was initially developed by P.P. Chen.
Components of Entity Relationship Diagram:
E-R Model consist of the following major components :
Entity :
An entity is a class of persons, place, objects, events or concepts about which we need to collect and store data. Here showing different entities include :
Entity Set :
An entity set is the collection of entities of the same type entities which share common properties or attributes.
Such as : The set of all employees of an organization can be called as the entity set Employee.
Attributes :
Each entity can have a number of characteristics. The characteristics of an entity are called Attributes. An attribute is a descriptive property or characteristic of an entity. Some attributes can be logically grouped into super attributes called Compound Attribute.
Key attributes :
The Key attributes is an attribute that uniquely identifies an entity in the entity set.
Relationships :
An association of several entities in an Entity Relation model is called Relationship.
There are three types of relationships are exist :
(i) One to One Relationship (1:1)
(ii) One to Many Relationship (1:M)
(iii) Many to Many Relationship (M:M)
(i) One to One Relationship (1:1) : (i) One to One Relationship is an association only between two entities.
Such as : In a College, each department has only one head of the department.
(ii) One to Many Relationship (1:M) : One to Many Relationship exists when one entity is related to more than one entity.
Such as : A father may have many children but a child has one father.
(iii) Many to Many Relationship (M:M) : A Many to Many Relationship (M:M) indicates that entities may have many relationships among each other.
Such as : One customer may buy many item of goods and one item of goods may be bought by many customers.