Question 1

How many types of relationships are there in an ER Diagram?

Accepted Answer

There are mainly four types of relationships in the Entity Relationship diagram.
- One-to-one Relationship
- One-to-Many Relationship
- Many-to-one Relationship
- Many-to-Many Relationship

Question 2

What is the use of an ER Diagram in a Database Management System?

Accepted Answer

An entity Relationship Diagram is used to visualise the database in an effective way. It is like a blueprint for the database you are planning to implement. It uses different concepts, guidelines, and representations to make the database more effective.

Question 3

What are some of the popular tools for creating ER Diagrams?

Accepted Answer

Some of the popular tools that can be used to make ER diagrams are Microsoft Visio, draw.io, Ludic hart, etc.

Question 4

What are some of the attributes used in the ER diagram?

Accepted Answer

Some of the attributes used in the entity relationship diagrams
- Key attributes
- Composite attributes
- Multi-valued attributes
- Derived attributes

Question 5

What is the use of a relationship in an ER diagram?

Accepted Answer

Relationships in the ER Diagram are used to represent the connections between entities. It is very important to show how two or more entities are connected to each other. A diamond shape symbol represents them.

attributes in ER Diagram

ER Diagram in DBMS: Understanding the Entity Relationship Model