Discuss the types of relationships in Relational Database Design.

1.	Discuss the types of relationships in Relational Database Design.
Answer» 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.

Answer»

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.

Discussion