Problem

Refer to Figure 6.12 (pg. 206). To implement a many-to-many (M:N) relationship between t...

Refer to Figure 6.12 (pg. 206). To implement a many-to-many (M:N) relationship between two relations, the figure demonstrates creating a new relation with a composite key made up of the primary keys (Client_ No and Employee_No) of the relations to be linked. As an alternative, you might be tempted to simply add the fields Employee_No to the Client relation, and Client_No to the Employee relation. Discuss the reporting problems that might occur with that alternative strategy.

Step-by-Step Solution

Request Professional Solution

Request Solution!

We need at least 10 more requests to produce the solution.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the solution will be notified once they are available.
Add your Solution
Textbook Solutions and Answers Search