Question: Refer to Figure 6 12 To implement a many to many M N relationship

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.

Sale on SolutionInn
  • CreatedDecember 15, 2014
  • Files Included
Post your question