DATABASE CONCEPTS CUSTOM
DATABASE CONCEPTS CUSTOM
8th Edition
ISBN: 9780134639864
Author: KROENKE
Publisher: PEARSON C
Expert Solution & Answer
Book Icon
Chapter 5, Problem 5.20RQ

Explanation of Solution

Many-to-many relationship (N:M):

Many-to-many relationship is one of the types of binary relationship that refers to the relationship that is laid between the two entities which means that many records in a table are associated with many records in another table.

Example:

In a library database, each book may have one or more author and each author may have written many books.

IE crow’s foot ER diagram:

Information Engineering is a method to represent the relationship between the entities. It uses crow’s foot to denote the many sides of a relationship. Hence, it is referred to as IE crow’s feet ER diagram.

  • Relational database system will not allow the user to implement a direct many-to-many relationship. Therefore, the many-to-many relationship will break into two one-to-many relationships the using third table and it is called “intersection table”...

Blurred answer
Students have asked these similar questions
show all the work
answer question 3
Show the work
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Operations Research : Applications and Algorithms
Computer Science
ISBN:9780534380588
Author:Wayne L. Winston
Publisher:Brooks Cole