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.



$1.99
Sales0
Views51
Comments0
  • CreatedDecember 15, 2014
  • Files Included
Post your question
5000