menu
bartleby
search
close search
Hit Return to see all results
close solutoin list

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

BuyFindarrow_forward

Pkg Acc Infor Systems MS VISIO CD

10th Edition
Ulric J. Gelinas
Publisher: CENGAGE L
ISBN: 9781133935940

Solutions

Chapter
Section
BuyFindarrow_forward

Pkg Acc Infor Systems MS VISIO CD

10th Edition
Ulric J. Gelinas
Publisher: CENGAGE L
ISBN: 9781133935940
Chapter 6, Problem 6DQ
Textbook Problem
1 views

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

The reporting problems that might occur with the alternative strategy.

Relational database:

It is a collective set of multiple data sets that are structured by the tables, records and columns. Relational database develops a well-defined relationship between the different database tables.

Explanation of Solution

The reporting problems that might occur with the alternative strategy:

The problems actually arise when there is a true (M:N) environment. An example of the reporting problem is as follows:

If there multiple employee records for each of the client, the duplicate clien...

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

Chapter 6 Solutions

Pkg Acc Infor Systems MS VISIO CD
Show all chapter solutions
add

Additional Business Textbook Solutions

Find more solutions based on key concepts
Show solutions add
PRICE/EARNINGS RATIO A company has an EPS of 2.00, a book value per share of 20, and a market/book ratio of 1.2...

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

Why is productivity important?

Essentials of Economics (MindTap Course List)

Explain how absolute advantage and comparative advantage differ.

Principles of Microeconomics (MindTap Course List)

An increase in accounts receivable is deducted from net income to compute cash from operating activities.

College Accounting, Chapters 1-27 (New in Accounting from Heintz and Parry)

What is a job cost sheet?

Financial & Managerial Accounting

What is the cost of goods manufactured?

Managerial Accounting: The Cornerstone of Business Decision-Making

Does inflation transfer wealth from lenders to borrowers? Why or why not?

Economics: Private and Public Choice (MindTap Course List)