Question 1

Which of the following financial statement line items require queries that encompass duality relationships?

Accepted Answer

A)  Net Sales on an Income Statement 
B)  Accounts Receivable on a Balance Sheet 
C)  Cost of Goods Sold on an Income Statement 
D)  Inventory on a Balance Sheet 
E)  Wages Expense on an Income Statement 
A)  Net Sales on an Income Statement 
B)  Accounts Receivable on a Balance Sheet 
C)  Cost of Goods Sold on an Income Statement 
D)  Inventory on a Balance Sheet 
E)  Wages Expense on an Income Statement

Question 2

Homonyms are two or more different words used to describe the same thing.

Accepted Answer

A) True 
 B)False

Question 3

Relationship structure conflicts exist when the same relationship is assigned different cardinalities in different views.

Accepted Answer

A) True 
 B)False

Question 4

Mega Manufacturer pays cash to many different external partners including suppliers, employees, independent contractors, shipping partners, banks, and stockholders. Mega Manufacturer wants to use a single database table in which to store information about all its external business partners. Describe the implementation compromise(s) Mega Manufacturer must make to accomplish this.

Accepted Answer

At the conceptual level, Mega Manufactur

Question 5

Reduction of query complexity is one reason for compromising logical level models for relationships for which posting foreign keys result in a relatively low percentage of null values.

Accepted Answer

A) True 
 B)False

Question 6

A theoretically pure relational database should never allow a null value in a table.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following attributes would NOT need to be included in a query (or set of queries) to determine Cost of Goods Sold (COGS) for an income statement according to the weighted average inventory costing method?

Accepted Answer

A)  Beginning date for income statement period for which COGS is needed 
B)  Actual unit costs of each inventory item on each purchase 
C)  Quantities sold of each inventory item on each sale 
D)  Actual unit selling prices of each inventory item on each sale 
E)  Quantities purchased of each inventory item on each purchase 
A)  Beginning date for income statement period for which COGS is needed 
B)  Actual unit costs of each inventory item on each purchase 
C)  Quantities sold of each inventory item on each sale 
D)  Actual unit selling prices of each inventory item on each sale 
E)  Quantities purchased of each inventory item on each purchase

Question 8

Which of the following statements regarding view integration of transaction cycle (business process) level REA models is true?

Accepted Answer

A)  They are always integrated based on a common inventory entity 
B)  They are only integrated based on an agent entity 
C)  All transaction cycles include cash, thus the cash entity serves as the only focal point for view integration 
D)  They may be integrated based on any common entity, regardless of the type of the entity 
E)  Whenever they share a common resource entity they also always share a common relationship involving that resource entity; both the entity and the relationship serve as integration points 
A)  They are always integrated based on a common inventory entity 
B)  They are only integrated based on an agent entity 
C)  All transaction cycles include cash, thus the cash entity serves as the only focal point for view integration 
D)  They may be integrated based on any common entity, regardless of the type of the entity 
E)  Whenever they share a common resource entity they also always share a common relationship involving that resource entity; both the entity and the relationship serve as integration points

Question 9

Which of the following is NOT one of the steps in integrating business process level REA "view models"?

Accepted Answer

A)  Re-name relationships as necessary to ensure uniqueness of relationship names 
B)  Perform set intersections of entity attributes (i.e., in the integrated view, include only those attributes that the entity has in each of the separate views) 
C)  Either merge the models based on a common entity, or remove the attributes from one copy of the entity and put a slash through the corner to show it is a copy of an existing entity 
D)  Determining which entity or entities are shared by the view models 
E)  All of the above are part of view integration 
A)  Re-name relationships as necessary to ensure uniqueness of relationship names 
B)  Perform set intersections of entity attributes (i.e., in the integrated view, include only those attributes that the entity has in each of the separate views) 
C)  Either merge the models based on a common entity, or remove the attributes from one copy of the entity and put a slash through the corner to show it is a copy of an existing entity 
D)  Determining which entity or entities are shared by the view models 
E)  All of the above are part of view integration

Question 10

Which of the following implementation compromises is made only after the database design is complete and data has been entered?

Accepted Answer

A)  Event activity roll-up 
B)  Combined entity key posting 
C)  Collapse of conceptually congruent entities 
D)  Omission of entity due to inadequate measurement tools 
E)  Materialization of tasks as entities 
A)  Event activity roll-up 
B)  Combined entity key posting 
C)  Collapse of conceptually congruent entities 
D)  Omission of entity due to inadequate measurement tools 
E)  Materialization of tasks as entities

Question 11

A compromised implementation in which tasks are materialized as events contains more tables than an uncompromised implementation for the same enterprise.

Accepted Answer

A) True 
 B)False

Question 12

Using the following tables extracted from Carlisle Company's database, calculate the ending cash balance for the checking account Carlisle has located at First Union. (Assume all beginning balances are zero)

Accepted Answer

A)  $2,368,000 
B)  $1,847,100 
C)  $1,292,900 
D)  $ 520,900 
E)  None of the above 
A)  $2,368,000 
B)  $1,847,100 
C)  $1,292,900 
D)  $ 520,900 
E)  None of the above

Question 13

Which of the following is a likely benefit of using ER grammar format instead of ER diagram format?

Accepted Answer

A)  No need for entity name conflict resolution 
B)  Easier identification of overlapping entity/relationship clusters 
C)  Copies of entities become unnecessary 
D)  No need for resolution of attribute conflicts 
E)  No need for relationship conflict resolution 
A)  No need for entity name conflict resolution 
B)  Easier identification of overlapping entity/relationship clusters 
C)  Copies of entities become unnecessary 
D)  No need for resolution of attribute conflicts 
E)  No need for relationship conflict resolution

Question 14

Using the following tables, which inventory stock number has generated the smallest total dollar amount of gross profit, using weighted average unit costing?

Accepted Answer

Item 962020 with tot

Question 15

The resource that is most likely to be found in multiple business processes in all types of organizations is

Accepted Answer

A)  Cash 
B)  Employee 
C)  Inventory 
D)  Sale 
E)  Cash Disbursement 
A)  Cash 
B)  Employee 
C)  Inventory 
D)  Sale 
E)  Cash Disbursement

Question 16

Exclusion of an entity or relationship because of inadequate measurement mechanisms is one example of a conceptual level modeling implementation compromise.

Accepted Answer

A) True 
 B)False

Question 17

Why is it necessary to resolve entity name conflicts when integrating multiple views?

Accepted Answer

If entity name conflict is not

Question 18

The conceptual level implementation compromise that eventually results in an increased number of tables in the resulting database is

Accepted Answer

A)  Exclusion of an entity or relationship because of inadequate measurement mechanisms or because no decision need exists for those data 
B)  Consolidation of conceptually congruent entities 
C)  Combined entity key posting 
D)  Materialization of tasks as event entities 
E)  Combination of entity sets without generalization 
A)  Exclusion of an entity or relationship because of inadequate measurement mechanisms or because no decision need exists for those data 
B)  Consolidation of conceptually congruent entities 
C)  Combined entity key posting 
D)  Materialization of tasks as event entities 
E)  Combination of entity sets without generalization

Question 19

The objects on which business process model views are typically most often integrated are

Accepted Answer

A)  Resources 
B)  Events 
C)  Agents 
D)  Duality relationships 
E)  Date constraints 
A)  Resources 
B)  Events 
C)  Agents 
D)  Duality relationships 
E)  Date constraints

Question 20

Which of the following relationships represent duality relationships?

Accepted Answer

A)  CR/CS, SA/CD, CR/Ca, P/FA, and RS/CR 
B)  CR/CS and RS/CR only 
C)  CR/CS, SA/CD, and RS/CR only 
D)  CR/Ca only 
E)  P/FA only 
A)  CR/CS, SA/CD, CR/Ca, P/FA, and RS/CR 
B)  CR/CS and RS/CR only 
C)  CR/CS, SA/CD, and RS/CR only 
D)  CR/Ca only 
E)  P/FA only

Which of the following financial statement line items require queries that encompass duality relationships?

Homonyms are two or more different words used to describe the same thing.

Relationship structure conflicts exist when the same relationship is assigned different cardinalities in different views.

Reduction of query complexity is one reason for compromising logical level models for relationships for which posting foreign keys result in a relatively low percentage of null values.

A theoretically pure relational database should never allow a null value in a table.

Which of the following attributes would NOT need to be included in a query (or set of queries) to determine Cost of Goods Sold (COGS) for an income statement according to the weighted average inventory costing method?

Which of the following statements regarding view integration of transaction cycle (business process) level REA models is true?

Which of the following is NOT one of the steps in integrating business process level REA "view models"?

Which of the following implementation compromises is made only after the database design is complete and data has been entered?

A compromised implementation in which tasks are materialized as events contains more tables than an uncompromised implementation for the same enterprise.

Using the following tables extracted from Carlisle Company's database, calculate the ending cash balance for the checking account Carlisle has located at First Union. (Assume all beginning balances are zero)

Which of the following is a likely benefit of using ER grammar format instead of ER diagram format?

Using the following tables, which inventory stock number has generated the smallest total dollar amount of gross profit, using weighted average unit costing?

The resource that is most likely to be found in multiple business processes in all types of organizations is

Exclusion of an entity or relationship because of inadequate measurement mechanisms is one example of a conceptual level modeling implementation compromise.

Why is it necessary to resolve entity name conflicts when integrating multiple views?

The conceptual level implementation compromise that eventually results in an increased number of tables in the resulting database is

The objects on which business process model views are typically most often integrated are

Which of the following relationships represent duality relationships?

An Introduction to Integrated Enterprise Information Systems

Representation and Patterns

The REA Enterprise Ontology

The REA Enterprise Ontology: Business Process Modeling

Task Level Modeling

Relational Database Design

Information Retrieval From Relational Databases

The Sales/Collection Business Process

The Acquisitio/Payment Business Process

The Conversion Business Process

The Human Resource Business Process

The Financing Business Process

Enterprise System Risks and Controls

ERP Systems and E-Commerce

Filters

Exam 10: View Integration and Implementation Compromises

Which of the following financial statement line items require queries that encompass duality relationships?

Homonyms are two or more different words used to describe the same thing.

Relationship structure conflicts exist when the same relationship is assigned different cardinalities in different views.

Reduction of query complexity is one reason for compromising logical level models for relationships for which posting foreign keys result in a relatively low percentage of null values.

A theoretically pure relational database should never allow a null value in a table.

Which of the following attributes would NOT need to be included in a query (or set of queries) to determine Cost of Goods Sold (COGS) for an income statement according to the weighted average inventory costing method?

Which of the following statements regarding view integration of transaction cycle (business process) level REA models is true?

Which of the following is NOT one of the steps in integrating business process level REA "view models"?

Which of the following implementation compromises is made only after the database design is complete and data has been entered?

A compromised implementation in which tasks are materialized as events contains more tables than an uncompromised implementation for the same enterprise.

Using the following tables extracted from Carlisle Company's database, calculate the ending cash balance for the checking account Carlisle has located at First Union. (Assume all beginning balances are zero)

Which of the following is a likely benefit of using ER grammar format instead of ER diagram format?

Using the following tables, which inventory stock number has generated the smallest total dollar amount of gross profit, using weighted average unit costing?

The resource that is most likely to be found in multiple business processes in all types of organizations is

Exclusion of an entity or relationship because of inadequate measurement mechanisms is one example of a conceptual level modeling implementation compromise.

Why is it necessary to resolve entity name conflicts when integrating multiple views?

The conceptual level implementation compromise that eventually results in an increased number of tables in the resulting database is

The objects on which business process model views are typically most often integrated are

Which of the following relationships represent duality relationships?

An Introduction to Integrated Enterprise Information Systems

Representation and Patterns

The REA Enterprise Ontology

The REA Enterprise Ontology: Business Process Modeling

Task Level Modeling

Relational Database Design

Information Retrieval From Relational Databases

The Sales/Collection Business Process

The Acquisitio/Payment Business Process

The Conversion Business Process

The Human Resource Business Process

The Financing Business Process

Enterprise System Risks and Controls

ERP Systems and E-Commerce

Filters