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”...