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...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Chapter 5, Problem 5.33RQ

Chapter 5, Problem 5.35RQ

Students have asked these similar questions

Give some instances of relationships that may have more than one candidate key to consider.

What is aproximiation, and how can it be performed using fuzzy relation?

Convert the following relation to 2NF, and then to 3NF. Show both conversions. (h, n, c, a, f, k, p, r, g, i, m, b, o, d, j, l, s, e) Functional Dependencies: p → j m, b → l h → g n → p n → o c → i n → j p → o h → d s → e a → r

Chapter 5 Solutions

Database Concepts (8th Edition)

Ch. 5 - Explain how entities are transformed into tables.Ch. 5 - Prob. 5.2RQ Ch. 5 - Prob. 5.3RQ Ch. 5 - What is denormalization?Ch. 5 - Prob. 5.5RQ Ch. 5 - Explain the problems that denormalized tables may...Ch. 5 - Explain how the representation of weak entities...Ch. 5 - Explain how supertype and subtype entities are...Ch. 5 - Prob. 5.9RQ Ch. 5 - Prob. 5.10RQ

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Solution Summary: The author explains the recursive many-to-many relationship, which is a relationship between two entities.

Concept explainers

Explanation of Solution

Want to see the full answer?

Chapter 5 Solutions