Discuss the types of relationships in Relational Database Design.


Share with your friends
Call

1. In a One-to-One relationship, one record in a table is associated with one and only one record in another table. 

2. One-to-Many relationships can also be viewed as Many-to-One relationships, depending on which way you look at them.

3. A Many-to-Many relationship occurs when multiple records in a table are associated with multiple records in another table.