Chapter 5, Problem 5.34RQ

Explanation of Solution

Intersection Table:

• Relational database system will not allow the user to implement a direct many-to-many relationship. So, the many-to-many relationship will break into two one-to-many relationships by using third table, it is called as “intersection table”.
• The intersection table contains primary key of the two tables as a foreign key.

Recursive many-to-many relationship (N:M):

• Recursive many-to-many relationship is one of the types of recursive binary relationship that refer to the relationship between two entities which means many fields or records in a table are associated with many fields or records in another table in recursive manner.
• Let us consider the example:
  • The “Agent” can buy or sell the property to any other agent in recursive manner.

Explanation:

• The “Agent_ID” is a primary key of the “Agent” table. The “Agent_for_Agent” is the intersection table which contains “Client_Agent_ID” and “Selling_Agent_ID” as the foreign keys.
• “Client_Agent_ID” contains the “Agent_ID” of the agent buying the property and “Selling_Agent_ID” contains the “Agent_ID” of the agent acting as the selling agent...