1 / 6

Components of an ER Diagram

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.<br>https://www.ducatindia.com/datascienceusingpython

ducathub
Download Presentation

Components of an ER Diagram

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. WELCOME TO DUCAT INDIA Components of an ER Diagram CONTACT:- 70-70-90-50-90 info@ducatindia.com

  2. 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

  3. 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

  4. 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:

  5. 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.

  6. THANK YOU • CONTACT:- • 70-70-90-50-90 • info@ducatindia.com

More Related