DATABASE CONCEPTS CUSTOM
DATABASE CONCEPTS CUSTOM
8th Edition
ISBN: 9780134639864
Author: KROENKE
Publisher: PEARSON C
bartleby

Concept explainers

Expert Solution & Answer
Book Icon
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:

Blurred answer
Students have asked these similar questions
show all the work
answer question 3
Show the work
Knowledge Booster
Background pattern image
Computer Science
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.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
Text book image
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Text book image
CMPTR
Computer Science
ISBN:9781337681872
Author:PINARD
Publisher:Cengage
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning