Database Concepts (7th Edition)
Database Concepts (7th Edition)
7th Edition
ISBN: 9780133544626
Author: David M. Kroenke, David J. Auer
Publisher: PEARSON
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
Need clear explanation
Define symbol table.
Develop a BasicMOST analysis of the sequence of activities for the table
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.
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
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr