Question 1

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 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 onlyF) B) and E)
G) B) and D)

Question 4

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 aboveF) A) and E)
G) B) and E)

Question 5

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 purchaseF) B) and C)
G) B) and D)

Question 6

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 StatementF) C) and D)
G) A) and C)

Question 7

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 pointsF) B) and E)
G) C) and E)

Question 8

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 integrationF) C) and D)
G) A) and D)

Question 9

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 constraintsF) B) and E)
G) C) and D)

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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 12

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

Accepted Answer

If entity name conflict is not...

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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 generalizationF) All of the above
G) A) and B)

Question 15

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 16

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 DisbursementF) A) and B)
G) A) and C)

Question 17

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 18

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 entitiesF) D) and E)
G) A) and D)

Question 19

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 resolutionF) B) and E)
G) A) and D)

Question 20

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

Exam 10: View Integration and Implementation Compromises

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?

Correct Answer
verified

Which of the following relationships represent duality relationships?

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified
If entity name conflict is not...
View Answer

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)

Correct Answer
verified

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

Correct Answer
verified
Item 962020 with tot...
View Answer

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified
At the conceptual level, Mega Manufactur...
View Answer

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.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Exam 10: View Integration and Implementation Compromises

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?

Correct AnswerverifiedShow Answer

Which of the following relationships represent duality relationships?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedIf entity name conflict is not...View AnswerShow Answer

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)

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedItem 962020 with tot...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct AnswerverifiedAt the conceptual level, Mega Manufactur...View AnswerShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
If entity name conflict is not...
View Answer

Correct Answer
verified

Correct Answer
verified
Item 962020 with tot...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
At the conceptual level, Mega Manufactur...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified