Refer to Figure 6.12. To implement a many-to-many (M:N) relationship between two relations, the figure demonstrates creating

Question:

Refer to Figure 6.12. 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.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Accounting Information Systems

ISBN: 978-1133935940

10th edition

Authors: Ulric J. Gelinas, Richard B. Dull

Question Posted: