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

When assigning foreign keys in a 1:1 association a. the primary key of each table should be embedded as a foreign key in the related table. b. the primary key on the 0,1 side of the relation should be embedded as the foreign key on the 1,1 side. c. the primary key on the 1,1 side of the relation should be embedded as the foreign key on the 0,1 side. d. a link table must be created to accept the foreign keys of both tables. e. none of the above is true.

BuyFindarrow_forward

Accounting Information Systems

10th Edition
Hall + 1 other
Publisher: Cengage Learning,
ISBN: 9781337619202

Solutions

Chapter
Section
BuyFindarrow_forward

Accounting Information Systems

10th Edition
Hall + 1 other
Publisher: Cengage Learning,
ISBN: 9781337619202
Chapter 10, Problem 7MCQ
Textbook Problem
6 views

When assigning foreign keys in a 1:1 association

  1. a. the primary key of each table should be embedded as a foreign key in the related table.
  2. b. the primary key on the 0,1 side of the relation should be embedded as the foreign key on the 1,1 side.
  3. c. the primary key on the 1,1 side of the relation should be embedded as the foreign key on the 0,1 side.
  4. d. a link table must be created to accept the foreign keys of both tables.
  5. e. none of the above is true.

To determine

Identify the point to be considered while assigning foreign keys in a 1:1 association.

Explanation of Solution

Foreign Key:

Those keys that help to establish the physical connection of tables, logically related for understanding associations described in data model, are known as foreign keys.

c.

Primary key of the table with (1, 1) cardinality is embedded as a foreign key for the table having (0, 1) cardinality, which helps to create a table structure containing several instances of foreign keys having null values. Therefore, this option is correct.

a.

Primary key of the table only with (1, 1) cardinality should be embedded as a foreign key for the table having (0, 1) cardinality, instead of each and every table...

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 10 Solutions

Accounting Information Systems
Show all chapter solutions
add
Ch. 10 - Why are journals and ledgers not modeled in an REA...Ch. 10 - Define association.Ch. 10 - Define cardinality.Ch. 10 - Name the four basic forms of cardinality.Ch. 10 - What is view integration?Ch. 10 - List the steps involved in view integration.Ch. 10 - What is the rule for assigning foreign keys in a...Ch. 10 - What is the rule for assigning foreign keys in a...Ch. 10 - What is the rule for assigning foreign keys in an...Ch. 10 - Define value chain.Ch. 10 - From the perspective of an organization, explain...Ch. 10 - Explain the relationship between cardinality and...Ch. 10 - Discuss the rules for assigning primary keys to...Ch. 10 - Discuss the rules for linking events to resources...Ch. 10 - How are external and internal agents modeled in...Ch. 10 - Explain how REA databases are able to support...Ch. 10 - Distinguish between economic events and support...Ch. 10 - Describe the minimum number and types of events...Ch. 10 - Why are traditional accounting events, such as...Ch. 10 - ER diagrams usually include the link tables in the...Ch. 10 - Employee time is a resource that is always used...Ch. 10 - When are data in 3NF?Ch. 10 - Each economic event in an REA diagram is always a....Ch. 10 - Which of the following is not a characteristic of...Ch. 10 - Which of the following events would be LEAST...Ch. 10 - Which of the following associations would most...Ch. 10 - Which of the following tables would most likely...Ch. 10 - Which of the following associations requires a...Ch. 10 - When assigning foreign keys in a 1:1 association...Ch. 10 - When assigning foreign keys in a I:M association,...Ch. 10 - The concept of duality means that an REA diagram...Ch. 10 - Which of the following is true? a. REA diagram...Ch. 10 - Describe the three differences between REA...Ch. 10 - Bentley Restorations Company restores and sells...Ch. 10 - Based on the data in Problem 2, which of the...Ch. 10 - Based on the data in Problem 2, which of the...Ch. 10 - Prepare an REA model depicting the issuance of raw...Ch. 10 - Cryogenics Inc., is a leading developer, designer,...Ch. 10 - Based on the general information about Cryogenics...Ch. 10 - Adirondacks Classic Furniture (ACF) manufactures a...Ch. 10 - Just Say No to Rugs is a manufacturer of...Ch. 10 - Lets Go Camping (LGC) is an outdoor equipment...

Additional Business Textbook Solutions

Find more solutions based on key concepts
Show solutions add
Provide an example of each.

Foundations of Business (MindTap Course List)

Why do economists make assumptions?

Essentials of Economics (MindTap Course List)

Suppose three honest individuals gave you their estimates of Stock Xs intrinsic value. One person is your curre...

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