Entity Relationship Diagram (ER – Diagram)

Entity Relationship Diagram (ER – Diagram)

The entity-relationship diagram is a set of entities that describes the database through the diagram. It is also known as the ER – diagram. The ER model defines the conceptual view of a database. It works around real-world entities and the associations among them. At the view level, the ER model considered a good option for designing the database.

An entity-relationship diagram consists of an entity, attributes, and relationship. Short explanations for its components are as follows:

Entity

An entity can be a real-world object, either animate or inanimate, that can be easily identifiable. For e.g. in a school database students, teachers, classes, and courses offered can be considered as entities. May an entity is a collection of similar types of entities. An entity set may contain entities with attributes sharing similar values.

Attributes

Entities presented by means of their properties called attributes. All attributes have values. For e.g. a student entity may have name, class, and age as attributes. There exists a domain or range of values that can be assigned to attributes.

Another e.g. a student’s name cannot be a numeric value. It has to be alphabetic. A student’s or people age cannot be negative, etc.

Relationship

The association among entities is a relationship. For e.g. an employee works at a department, a student enrolls in a course. Here, works and enrolls called relationships.

For offline read download PDF file below,

Also, read

Database system definition & objectives

Solution of financial accounting PU 2018

Symbols used in Entity Relationship Diagram (ER – Diagram)

ms access entity relationship diagram symbols
ER-Diagram Symbols
ms access entity relationship diagram symbols
ER-Diagram Symbols

Example:

PU 2016 Spring Q. No. 17

What is an ER Diagram? Draw ER Diagram of your choice with at least 3 entities and 4 attributes each.

Ans: Solution to this questions is through this image

ms access er diagram
ER-Diagram

Leave a Comment

%d bloggers like this: