Relationship & its Types

Relationship:

Logically connection of tables in database is called relationship.

Types of Relationship

i) One to one relationship

This type of relationship is used when “for each record in first table, there is only one record in the second table and for each record in the second table, there is only one record in the first table.

ii) One to many relationship

This type of relationship is used when “for each record in first table, there are one or more records in the second table and for each record in the second table, there is only one record in the first table.

iii) Many to many relationship

This type of relationship is used when “for each record in first table, there are one or more records in the second table and for each record in the second table, there are one or more records in the first table.