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
Size: 377.29 KB
Language: en
Added: Dec 07, 2021
Slides: 6 pages
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.