1 / 5

WHAT IS AN ENTITY RELATIONSHIP DIAGRAM?

WHAT IS AN ENTITY RELATIONSHIP DIAGRAM?. An Entity Relationship (ER) Diagram is a graphic that shows the interrelationship between entities in a database. WHAT ARE THE SYMBOLS USED IN ENTITY RELATIONSHIP DIAGRAMS?. The symbols used in ER Diagrams are Boxes, Diamonds and Ovals.

lundy
Download Presentation

WHAT IS AN ENTITY RELATIONSHIP 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. WHAT IS AN ENTITY RELATIONSHIP DIAGRAM? An Entity Relationship (ER) Diagram is a graphic that shows the interrelationship between entities in a database.

  2. WHAT ARE THE SYMBOLS USED IN ENTITY RELATIONSHIP DIAGRAMS? The symbols used in ER Diagrams are Boxes, Diamonds and Ovals. Boxes are commonly used to represent entities. Diamonds are normally used to represent relationships. Ovals are used to represents attributes.

  3. WHAT IS A ONE TO ONE RELATIONSHIP? A one-to-one relationship is when the primary record have only one related record.A stock table contains exactly one record in a stock detail table. Both tables have the same Stock Id as primary key. In the stock detail table, Stock Id is the primary key and also a foreign key to stock table. This is one of the common ways to define one-to-one relationship.

  4. WHAT IS A ONE TO MANY RELATIONSHIP? A one to many relationship is a relation in which one record in a table is related to many records in another table.An example of this is a stock table which has many occurrences in a stock daily record table.

  5. WHAT IS A MANY TO MANY RELATIONSHIP? A many-to-many relationship is a data relationship in which the value of 1 data element can be combined with many values of another data element and vice versa. For example, in a library database, one record in the Titles table could relate to several records in the Borrower table, since several people might have signed out copies of the same book.

More Related