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.1) Boxes are commonly used to represent entities.2) Diamonds are normally used to represent relationships.3) Ovals are used to represents attributes.

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.

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.

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.