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

Explain the meaning of the term intersection table

Convert the following ER diagrams into relational schemas

Define symbol table.

Chapter 5 Solutions

Database Concepts (7th 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