Components of an er diagram

Ducat3 107 views 6 slides Dec 07, 2021
Slide 1
Slide 1 of 6
Slide 1
1
Slide 2
2
Slide 3
3
Slide 4
4
Slide 5
5
Slide 6
6

About This Presentation

An entity type is defined in ER diagrams as a rectangular box enclosing the entity type name. Attributes name are attached in ovals and are connected to their entity type by using straight lines.
https://www.ducatindia.com/datascienceusingpython


Slide Content

Components of an ER Diagram CONTACT:- 70-70-90-50-90 [email protected] WELCOME TO DUCAT INDIA

An ER Diagram includes the following components:- - Entity - Attributes - Relationships Entity An entity is a person, place, element, event, or idea about which information is recorded. In an entity-relationship diagram, an entity is described by using a rectangle. Some of the examples of the entities are given below

Person: STUDENT, PATIENT, EMPLOYEE, DOCTOR, ENGINEER Place: CITY, COUNTRY, STATE Event: SEMINAR, SALE, RENEWAL, COMPETITION Object: BUILDING, AUTOMOBILE, MACHINE, FURNITURE, TOY Concept: COURSE, ACCOUNT, TRAINING CENTRE, WORK CENTRE

Entity Types An entity is represented as a collection of entities that have similar attributes. For instance, an employee in a company database. The employee entities share similar attributes, however, such an entity has its value for each attribute. The entity type, the employee, is display in the figure:

An entity type is defined in  ER diagrams  as a rectangular box enclosing the entity type name. Attributes name are attached in ovals and are connected to their entity type by using straight lines as display in fig: Entity Set The collection of all entities of a specific entity type inside the database at any point in time is known as an entity set. It is also referred to as the  extension  of the entity type.

THANK YOU CONTACT:- 70-70-90-50-90 [email protected]