Business
Engineering
Math
Science
Social Science
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.
Accounting Information Systems
Solutions
Accounting Information Systems
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.
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...
Chapter 10 Solutions
Additional Business Textbook Solutions
Financial Accounting
College Accounting, Chapters 1-27
Corporate Financial Accounting
Financial & Managerial Accounting
Financial And Managerial Accounting
Foundations of Business (MindTap Course List)
Accounting Information Systems
Principles of Economics (MindTap Course List)
Management, Loose-Leaf Version
Essentials of Business Communication (MindTap Course List)
Principles of Microeconomics (MindTap Course List)
STATISTICS F/BUSINESS+ECONOMICS-TEXT
Principles of Macroeconomics (MindTap Course List)
Essentials of Economics (MindTap Course List)
ECON: MICRO4 (New, Engaging Titles from 4LTR Press)
Fundamentals of Financial Management, Concise Edition (MindTap Course List)
Fundamentals of Financial Management (MindTap Course List)
Brief Principles of Macroeconomics (MindTap Course List)
Contemporary Marketing
MKTG 12:STUDENT ED.-TEXT
Financial Accounting
College Accounting (Book Only): A Career Approach
Managerial Accounting: The Cornerstone of Business Decision-Making
Accounting (Text Only)
Intermediate Accounting: Reporting And Analysis
Financial & Managerial Accounting
Fundamentals of Financial Management, Concise Edition (with Thomson ONE - Business School Edition, 1 term (6 months) Printed Access Card) (MindTap Course List)
Exploring Economics
Statistics for Business & Economics, Revised (MindTap Course List)
College Accounting (Book Only): A Career Approach
College Accounting, Chapters 1-27 (New in Accounting from Heintz and Parry)
Pkg Acc Infor Systems MS VISIO CD
Principles of Macroeconomics (MindTap Course List)
Fundamentals of Financial Management (MindTap Course List)
Corporate Financial Accounting
Survey of Accounting (Accounting I)
PAYROLL ACCT.,2019 ED.(LL)-TEXT
Economics (MindTap Course List)
Purchasing and Supply Chain Management
Macroeconomics
Cornerstones of Cost Management (Cornerstones Series)
Economics For Today
Practical Management Science
Microeconomics
Cornerstones of Financial Accounting
Managerial Accounting
Understanding Management (MindTap Course List)
MACROECONOMICS FOR TODAY
Economics: Private and Public Choice (MindTap Course List)
Microeconomics: Private and Public Choice (MindTap Course List)
Micro Economics For Today
Macroeconomics: Private and Public Choice (MindTap Course List)
Principles of Microeconomics
