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.
Relevant QuestionsAlthough today’s enterprise systems incorporate many of the REA concepts, many organizations continue to use legacy systems. Why do you believe this is true? (Although the obvious answer is in the chapter, you may want to ...Using the vendor and purchase order tables from Short Problem and SQL commands, create a query to find out the date of each purchase order and the vendor by name each purchase order was sent to. Provide five examples of potential conflict between the control goals of ensuring effectiveness of operations and of ensuring efficient employment of resources.Following is a list of eight generic control goals from the chapter, followed by eight descriptions of either process failures (i. e., control goals not met) or instances of successful control plans (i. e., plans that helped ...“No matter how sophisticated a system of internal control is, its success ultimately requires that you place your trust in certain key personnel.” Do you agree? Discuss fully.
Post your question