BuyFindarrow_forward

Accounting Information Systems

11th Edition
Ulric J. Gelinas + 3 others
ISBN: 9781337552127

Solutions

Chapter
Section
BuyFindarrow_forward

Accounting Information Systems

11th Edition
Ulric J. Gelinas + 3 others
ISBN: 9781337552127
Textbook Problem

Refer to Figure 6.12 (pg. 212). 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.

Summary Introduction

To explain: The alternate problems that might occur with the alternative strategy.

Introduction:

Relational database:

It is a collection of multiple data sets constituted by rows, columns, and tables. It aids in developing a well-established relationship between different database tables. Information is shared between these tables for efficient use.

Explanation

The alternate problems that might occur with the alternative strategy:

The problem arises when there is a true M:N environment. An instance of reporting problem would be like this. If multiple records of employee records are existing for each client, the client information which is duplicate would be stored as the correct information...

Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Additional Business Solutions

Find more solutions based on key concepts

Show solutions add

Should an economic model describe reality exactly?

Brief Principles of Macroeconomics (MindTap Course List)

Which fluctuate morelong-term or short-term interest rates? Why?

Fundamentals Of Financial Management, Concise Edition (mindtap Course List)

Once again we can use the CAPM to estimate MMMs cost of equity. From the Internet, you can find a number of dif...

Fundamentals of Financial Management, Concise Edition (with Thomson ONE - Business School Edition, 1 term (6 months) Printed Access Card) (MindTap Course List)