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:

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Chapter 5, Problem 5.20RQ

Chapter 5, Problem 5.22RQ

Students have asked these similar questions

Please explain in a step by step and detailed manner that could clearly understand how the state table works.

Describe an example in which you would want to use a derived table.

In what ways dimension table are often not normalized.

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 describes an intersection table that describes a N:M relationship between two tables. This relationship contains two 1:N relationships from either direction.

Concept explainers

Explanation of Solution

Want to see the full answer?

Chapter 5 Solutions