entity relationship diagrams n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
ENTITY RELATIONSHIP DIAGRAMS PowerPoint Presentation
Download Presentation
ENTITY RELATIONSHIP DIAGRAMS

Loading in 2 Seconds...

play fullscreen
1 / 6

ENTITY RELATIONSHIP DIAGRAMS - PowerPoint PPT Presentation


  • 202 Views
  • Uploaded on

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

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

PowerPoint Slideshow about 'ENTITY RELATIONSHIP DIAGRAMS' - wayne


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
what is an entity relationship diagram
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
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.
what is a one to one relationship
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:
what is a one to many relationship
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.
what is a many to many relationship
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).