Chapter 5, Problem 5.21RQ

Explanation of Solution

Intersection table:

Intersection table is a table that describes a N:M relationship which gives an intersection between two tables.

• Each row of the table represents one line in an instance showing the relations between the related entities.
• The direct N:M relationship is not allowed to implement in relational database. So, this relationship contains two 1:N relationship from either direction.

Example:

Consider an example of intersection table is as follows: