Entity relationship diagram
1 / 10

By: Marisha Richards - PowerPoint PPT Presentation

  • Uploaded on

ENTITY-RELATIONSHIP DIAGRAM. By: Marisha Richards. Introduction. An entity-relationship (ER) diagram is a specialized graphic that illustrates the interrelationships between entities in a database.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'By: Marisha Richards' - braden

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Entity relationship diagram


By: Marisha Richards


  • An entity-relationship (ER) diagram is a specialized graphic that illustrates the interrelationships between entities in a database.

  • An Entity Relationship Diagram (ERD) is a snapshot of data structures. ERDs show entities in a database and relationships between tables within that database.

Introduction cont d
Introduction Cont’d

  • It is essential to have one of these if you want to create a good database design. The patterns help focus on how the database actually works with all of the interactions and data flows, although another useful tool is a Data Flow Diagram (DFD) which more directly describes this.

Erd symbols
ERD Symbols

  • ER diagrams often use symbols to represent three different types of information. Boxes are commonly used to represent entities. Diamonds are normally used to represent relationships and ovals are used to represent attributes.


  • An entity is an object or concept about which you want to store information.


  • A attribute is the unique, distinguishing characteristic of the entity. For example, an employee's social security number might be the employee's key attribute.


  • Relationships illustrate how two entities share information in the database structure.

One to one relationship
One-to-One Relationship

  • In a one-to-one relationship, each row in one database table is linked to one and only one other row in another table. In a one-to-one relationship between Table A and Table B, each row in Table A is linked to another row in Table B. The number of rows in Table A must equal the number of rows in Table B.

  • An example of one-to-one relationship would be a car runs on one engine

One to many relationship
One-to-Many Relationship

  • In a one-to-many relationship, each row in the related to table can be related to many rows in the relating table. This allows frequently used information to be saved only once in a table and referenced many times in all other tables.

  • An example of one-to-many relationship is a mother giving birth to triplets.

Many to many relationship
Many-to-Many Relationship

  • In a many-to-many relationship, a row in table A can have many matching rows in table B, and vice versa. You create such a relationship by defining a third table, called a junction table, whose primary key consists of the foreign keys from both table A and table B.