1 / 6

ENTITY RELATIONSHIP DIAGRAMS

ENTITY RELATIONSHIP DIAGRAMS. Moya messam. What is an entity relationship diagram?. Definition: An entity-relationship (ER) diagram is a specialized graphic that illustrates the interrelationships between entities in a database. What are the symbols used in a entity relationship diagram? .

wayne
Download Presentation

ENTITY RELATIONSHIP DIAGRAMS

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. ENTITY RELATIONSHIP DIAGRAMS Moyamessam

  2. What is an entity relationship diagram? • Definition: An entity-relationship (ER) diagram is a specialized graphic that illustrates the interrelationships between entities in a database.

  3. What are the symbols used in a entity relationship diagram? • 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.

  4. What is a one-to-one relationship? • a one to one relationship is where each record in a table(A) can have only one matching record in table(B). This type of relationship is not common, because most information related in this way would be in one table. • Example:

  5. What is a one to many relationship? • A one to many relationship is the most common type of relationship. This is where a record in a table (A) can have many matching records in table(b). • For example one suppler can supply more than one product to a company, but each product has only one supplier.

  6. What is a many to many relationship? • A many to many relationship is where a record in table (A) can have many matching records in table (B), and record in table (B) can have many matching records in table (A).

More Related