A Complete Guide to ER Diagrams in DBMS

An Entity Relationship Diagram is a diagram that represents relationships among entities in a database. It is commonly known as an ER Diagram. An ER Diagram in DBMS plays a crucial role in designing the database. Today’s business world previews all the requirements demanded by the users in the form of an ER Diagram. Later, it's forwarded to the database administrators to design the database.

ERDiagramsInDBMS_1

What is an ER Diagram?

An Entity Relationship Diagram (ER Diagram) pictorially explains the relationship between entities to be stored in a database. Fundamentally, the ER Diagram is a structural design of the database. It acts as a framework created with specialized symbols for the purpose of defining the relationship between the database entities. ER diagram is created based on three principal components: entities, attributes, and relationships.

The following diagram showcases two entities - Student and Course, and their relationship. The relationship described between student and course is many-to-many, as a course can be opted by several students, and a student can opt for more than one course. Student entity possesses attributes - Stu_Id, Stu_Name & Stu_Age. The course entity has attributes such as Cou_ID & Cou_Name.

Post Graduate Program in Business Analysis

In partnership with Purdue UniversityVIEW COURSE
Post Graduate Program in Business Analysis

What is an ER Model?

An Entity-Relationship Model represents the structure of the database with the help of a diagram. ER Modelling is a systematic process to design a database as it would require you to analyze all data requirements before implementing your database.

History of ER models

Peter Chen proposed ER Diagrams in 1971 to create a uniform convention that can be used as a conceptual modeling tool. Many models were presented and discussed, but none were suitable. The data structure diagrams offered by Charles Bachman also inspired his model.

Why Use ER Diagrams in DBMS?

  • ER Diagram helps you conceptualize the database and lets you know which fields need to be embedded for a particular entity
  • ER Diagram gives a better understanding of the information to be stored in a database
  • It reduces complexity and allows database designers to build databases quickly
  • It helps to describe elements using Entity-Relationship models
  • It allows users to get a preview of the logical structure of the database

Symbols Used in ER Diagrams

  • Rectangles: This Entity Relationship Diagram symbol represents entity types
  • Ellipses: This symbol represents attributes
  • Diamonds: This symbol represents relationship types
  • Lines: It links attributes to entity types and entity types with other relationship types
  • Primary key: Here, it underlines the attributes 
  • Double Ellipses: Represents multi-valued attributes

ERDiagramsInDBMS_2

Components of ER Diagram

You base an ER Diagram on three basic concepts:

  • Entities
    • Weak Entity
  • Attributes
    • Key Attribute
    • Composite Attribute
    • Multivalued Attribute
    • Derived Attribute
  • Relationships
    • One-to-One Relationships
    • One-to-Many Relationships
    • Many-to-One Relationships
    • Many-to-Many Relationships

Entities

An entity can be either a living or non-living component.

It showcases an entity as a rectangle in an ER diagram.

For example, in a student study course, both the student and the course are entities.

ERDiagramsInDBMS_3.

Weak Entity

An entity that makes reliance over another entity is called a weak entity

You showcase the weak entity as a double rectangle in ER Diagram.

In the example below, school is a strong entity because it has a primary key attribute - school number. Unlike school, the classroom is a weak entity because it does not have any primary key and the room number here acts only as a discriminator.

ERDiagramsInDBMS_4

Attribute

An attribute exhibits the properties of an entity. 

You can illustrate an attribute with an oval shape in an ER diagram.

ERDiagramsInDBMS_5

Key Attribute

Key attribute uniquely identifies an entity from an entity set.

It underlines the text of a key attribute.

For example: For a student entity, the roll number can uniquely identify a student from a set of students.

ERDiagramsInDBMS_6

Composite Attribute

An attribute that is composed of several other attributes is known as a composite attribute.

An oval showcases the composite attribute, and the composite attribute oval is further connected with other ovals.

ERDiagramsInDBMS_7

Multivalued Attribute

Some attributes can possess over one value, those attributes are called multivalued attributes.

The double oval shape is used to represent a multivalued attribute.

ERDiagramsInDBMS_8

Derived Attribute

An attribute that can be derived from other attributes of the entity is known as a derived attribute.

In the ER diagram, the dashed oval represents the derived attribute.

ERDiagramsInDBMS_9.

Relationship

The diamond shape showcases a relationship in the ER diagram.

It depicts the relationship between two entities.

In the example below, both the student and the course are entities, and study is the relationship between them. 

ERDiagramsInDBMS_10.

One-to-One Relationship

When a single element of an entity is associated with a single element of another entity, it is called a one-to-one relationship.

For example, a student has only one identification card and an identification card is given to one person.

ERDiagramsInDBMS_11

FREE Course: Introduction to Data Analytics

Mastery to Data Analytics Basics is a Click Away!Start Learning
FREE Course: Introduction to Data Analytics

One-to-Many Relationship

When a single element of an entity is associated with more than one element of another entity, it is called a one-to-many relationship

For example, a customer can place many orders, but an order cannot be placed by many customers.

ERDiagramsInDBMS_12

Many-to-One Relationship

When more than one element of an entity is related to a single element of another entity, then it is called a many-to-one relationship.

For example, students have to opt for a single course, but a course can have many students.

ERDiagramsInDBMS_13

Many-to-Many Relationship

When more than one element of an entity is associated with more than one element of another entity, this is called a many-to-many relationship.

For example, you can assign an employee to many projects and a project can have many employees.

ERDiagramsInDBMS_14

How to Draw an ER Diagram?

Below are some important points to draw ER diagram:

  • First, identify all the Entities. Embed all the entities in a rectangle and label them properly.
  • Identify relationships between entities and connect them using a diamond in the middle, illustrating the relationship. Do not connect relationships with each other.
  • Connect attributes for entities and label them properly.
  • Eradicate any redundant entities or relationships.
  • Make sure your ER Diagram supports all the data provided to design the database.
  • Effectively use colors to highlight key areas in your diagrams.
Looking forward to a career as a Business Analyst? Check out the Business Analytics Certification Training with Excel and get certified today.

Conclusion

ER Diagram in DBMS is widely used to describe the conceptual design of databases. It helps both users and database developers to preview the structure of the database before implementing the database. 

If you have any questions or inputs for our editorial team regarding this “ER Diagram in DBMS” article, do share them with us in the comments section below. Our team will review them and help solve them for you very soon!

To get certified in SQL and start your career in it, check this course link: SQL Training.

Happy learning!

About the Author

SimplilearnSimplilearn

Simplilearn is one of the world’s leading providers of online training for Digital Marketing, Cloud Computing, Project Management, Data Science, IT, Software Development, and many other emerging technologies.

View More
  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.