3/11/24, 8:22 PM ER (Entity Relationship) Diagram Model in DBMS Examples - javatpoint

ADVERTISEMENT

ER (Entity Relationship) Diagram in DBMS

ADVERTISEMENT ADVERTISEMENT

Sinorock Self Drilling Bolt

The major supplier for
providing rock bolt

ER model stands for an Entity-Relationship model. It is a high-level data model. This model is
used to define the data elements and relationship for a specified system.

It develops a conceptual design for the database. It also develops a very simple and easy to
design view of data.

In ER modeling, the database structure is portrayed as a diagram called an entity-relationship

diagram.

For example, Suppose we design a school database. In this database, the student will be an entity
with attributes like address, name, id, age, etc. The address can be another entity with attributes like
city, street name, pin code, etc and there will be a relationship between them.

https://www.javatpoint.com/dbms-er-model-concept 2/14
3/11/24, 8:22 PM ER (Entity Relationship) Diagram Model in DBMS Examples - javatpoint

Component of ER Diagram

https://www.javatpoint.com/dbms-er-model-concept 3/14
3/11/24, 8:22 PM ER (Entity Relationship) Diagram Model in DBMS Examples - javatpoint

1. Entity:

An entity may be any object, class, person or place. In the ER diagram, an entity can be represented
as rectangles.

Consider an organization as an example- manager, product, employee, department etc. can be taken
as an entity.

a. Weak Entity

An entity that depends on another entity called a weak entity. The weak entity doesn't contain any
key attribute of its own. The weak entity is represented by a double rectangle.

https://www.javatpoint.com/dbms-er-model-concept 4/14
3/11/24, 8:22 PM ER (Entity Relationship) Diagram Model in DBMS Examples - javatpoint

2. Attribute

The attribute is used to describe the property of an entity. Eclipse is used to represent an attribute.

For example, id, age, contact number, name, etc. can be attributes of a student.

ADVERTISEMENT

Sinorock Self Drill Bolt

Consists of Hollow Anchor Bar,
Coupler, Drill Bit, Nut, Plate,
Centralizer.

Sinorock Open

a. Key Attribute

The key attribute is used to represent the main characteristics of an entity. It represents a primary key.
The key attribute is represented by an ellipse with the text underlined.

https://www.javatpoint.com/dbms-er-model-concept 5/14
3/11/24, 8:22 PM ER (Entity Relationship) Diagram Model in DBMS Examples - javatpoint

b. Composite Attribute
ADVERTISEMENT

An attribute that composed of many other attributes is known as a composite attribute. The
composite attribute is represented by an ellipse, and those ellipses are connected with an ellipse.

https://www.javatpoint.com/dbms-er-model-concept 6/14
3/11/24, 8:22 PM ER (Entity Relationship) Diagram Model in DBMS Examples - javatpoint

c. Multivalued Attribute

An attribute can have more than one value. These attributes are known as a multivalued attribute.
The double oval is used to represent multivalued attribute.

For example, a student can have more than one phone number.

d. Derived Attribute

An attribute that can be derived from other attribute is known as a derived attribute. It can be
represented by a dashed ellipse.

For example, A person's age changes over time and can be derived from another attribute like Date
of birth.

https://www.javatpoint.com/dbms-er-model-concept 7/14
3/11/24, 8:22 PM ER (Entity Relationship) Diagram Model in DBMS Examples - javatpoint

3. Relationship

A relationship is used to describe the relation between entities. Diamond or rhombus is used to
represent the relationship.

Types of relationship are as follows:

a. One-to-One Relationship

https://www.javatpoint.com/dbms-er-model-concept 8/14
3/11/24, 8:22 PM ER (Entity Relationship) Diagram Model in DBMS Examples - javatpoint

When only one instance of an entity is associated with the relationship, then it is known as one to
one relationship.

For example, A female can marry to one male, and a male can marry to one female.

ADVERTISEMENT ADVERTISEMENT

b. One-to-many relationship

When only one instance of the entity on the left, and more than one instance of an entity on the right
associates with the relationship then this is known as a one-to-many relationship.

For example, Scientist can invent many inventions, but the invention is done by the only specific
scientist.

c. Many-to-one relationship

https://www.javatpoint.com/dbms-er-model-concept 9/14
3/11/24, 8:22 PM ER (Entity Relationship) Diagram Model in DBMS Examples - javatpoint

When more than one instance of the entity on the left, and only one instance of an entity on the right
associates with the relationship then it is known as a many-to-one relationship.

For example, Student enrolls for only one course, but a course can have many students.

d. Many-to-many relationship

When more than one instance of the entity on the left, and more than one instance of an entity on
the right associates with the relationship then it is known as a many-to-many relationship.

For example, Employee can assign by many projects and project can have many employees.

← Prev Next →

ADVERTISEMENT ADVERTISEMENT

https://www.javatpoint.com/dbms-er-model-concept 10/14