Question 1

In an integrated REA diagram,every event must be linked to

Accepted Answer

A)  at least two resources.
B)  at least two agents.
C)  at least one other event.
D)  at least two other events.E) A) and B)
F) A) and C)

Question 2

In an integrated REA diagram,every agent must be linked to

Accepted Answer

A)  at least one resource.
B)  at least two resources.
C)  at least one event.
D)  at least two events.E) A) and B)
F) All of the above

Question 3

When using an REA diagram to develop a database,a many-to-many relationship must be

Accepted Answer

A)  broken into two, one-to-one relationships.
B)  combined into a single one-to-one relationship.
C)  combined into a one-to-many relationship.
D)  broken into two, one-to-many relationships.E) B) and C)
F) None of the above

Question 4

Which entity is most likely to be part of both the payroll cycle and the expenditure cycle?

Accepted Answer

A)  Receive Goods.
B)  Customer.
C)  Disburse Cash.
D)  Inventory.E) All of the above
F) None of the above

Question 5

In which of the following cases is the relationship between entities not implemented by foreign keys?

Accepted Answer

A)  
B)  
C)  
D)  E) C) and D)
F) None of the above

Question 6

In an REA diagram,resource entities

Accepted Answer

A)  can be linked to event entities in Business Cycle A and to event entities in Business Cycle B.
B)  cannot be linked to event entities in Business Cycle A and to event entities in Business Cycle B.
C)  cannot be linked to agent entities.
D)  none of the aboveE) None of the above
F) A) and D)

Question 7

Which of the statements below is false with regards to the tables for M:N relationships?

Accepted Answer

A)  Non-key attributes may be included.
B)  Multiple attribute primary keys are used.
C)  Single attribute primary keys may be used.
D)  Concatenated keys are used.E) B) and C)
F) A) and D)

Question 8

In an integrated REA diagram,every resource must be linked to

Accepted Answer

A)  at least two events.
B)  at least two agents.
C)  at least one other resource.
D)  at least two other resources.E) C) and D)
F) A) and B) A

Question 9

When comparing REA diagrams used to design an AIS with a traditionally designed AIS,

Accepted Answer

A)  traditional AIS information, such as journals and ledgers no longer exist.
B)  similar information is present as in a traditional AIS, but stored in a different format.
C)  queries are used to input data into the AIS.
D)  an REA designed AIS cannot recreate a traditional journal.E) B) and D)
F) A) and B)

Question 10

Combining REA diagrams for individual transaction cycles into a single,enterprise-wide model adds three more rules to the three basic principles for drawing REA diagrams.Which of the following is not one of those two new rules?

Accepted Answer

A)  Every resource must be linked to at least one event that increments that resource and to at least one event that decrements that resource.
B)  If a specific event can be linked to more than one other type of event, but cannot be linked simultaneously to all of those other events, then the minimum cardinality between that event and every other event with which it may be associated must be 0.
C)  If a specific event can be linked to more than one other type of event, but cannot be linked simultaneously to all of those other events, then the maximum cardinality between that event and every other event with which it may be associated must be 0.
D)  All of the above are new rules for drawing integrated REA diagrams.E) C) and D)
F) All of the above C

Question 11

When assigning attributes to each table,

Accepted Answer

A)  the database designer must interview users to identify which facts should be included in the database.
B)  the database designer must interview management to identify which facts should be included in the database.
C)  the database designer must use the REA diagram to help determine in which tables those facts belong.
D)  the database designer must do all of the above.E) A) and D)
F) B) and C)

Question 12

Constructing a well-structured,well-developed REA diagram eliminates which anomaly problem(s) ?

Accepted Answer

A)  Update.
B)  Insert.
C)  Delete.
D)  All of the above.E) B) and D)
F) A) and D)

Question 13

From the choices below,identify the attribute below that would make the best primary key.

Accepted Answer

A)  On campus mailbox number.
B)  GPA.
C)  Credit hours.
D)  Student ID number.E) B) and D)
F) B) and C)

Question 14

The primary key for 1:1 relationship tables

Accepted Answer

A)  is a single attribute.
B)  always consists of two attributes.
C)  is the primary key of the most important entity linked to that relationship.
D)  does not exist. Many-to-many relationship tables only use foreign keys.E) All of the above
F) C) and D)

Question 15

In which of the following cases is the number of tables required to represent the relationship equal to three?

Accepted Answer

A)  
B)  
C)  
D)  E) A) and C)
F) B) and C)

Question 16

REA diagrams for individual business cycles may include some events that also appear in the REA diagrams of another cycle.

Accepted Answer

A) True 
 B)False

Question 17

In a relational database,which of the following attributes would typically be represented by a foreign key in the table that stores data about a Disburse Cash entity?

Accepted Answer

A)  Amount.
B)  Date.
C)  Vendor number.
D)  Product number.E) C) and D)
F) B) and C)

Question 18

In a relational database,which of the following attributes would typically be included in the table that stores data about the Vendor entity?

Accepted Answer

A)  Invoice number.
B)  Outstanding balance.
C)  Product code.
D)  Inventory.E) All of the above
F) A) and C)

Question 19

The major benefits of using the REA model as the basis for designing an AIS include all of the following except

Accepted Answer

A)  the REA data model integrates non-financial and financial data in the AIS.
B)  the REA data model makes both non-financial and financial data easily accessible to management.
C)  the REA data model provides the basis for building the kind of flexible AIS that is responsive to management's changing information needs.
D)  the REA data model reduces the need for accountants to understand the underlying accounting journals and ledgers.E) None of the above
F) B) and C)

Question 20

When integrating multiple REA diagrams into an integrated REA diagram,merging redundant resources

Accepted Answer

A)  always affects minimum cardinalities associated with the merged event.
B)  sometimes affects minimum cardinalities associated with the merged event.
C)  never affects minimum cardinalities associated with the merged event.
D)  none of the aboveE) All of the above
F) A) and D) C

Exam 18: Implementing an Rea Model in a Relational Database

In an integrated REA diagram,every event must be linked to

Correct AnswerverifiedShow Answer

In an integrated REA diagram,every agent must be linked to

Correct AnswerverifiedShow Answer

When using an REA diagram to develop a database,a many-to-many relationship must be

Correct AnswerverifiedShow Answer

Which entity is most likely to be part of both the payroll cycle and the expenditure cycle?

Correct AnswerverifiedShow Answer

In which of the following cases is the relationship between entities not implemented by foreign keys?

Correct AnswerverifiedShow Answer

In an REA diagram,resource entities

Correct AnswerverifiedShow Answer

Which of the statements below is false with regards to the tables for M:N relationships?

Correct AnswerverifiedShow Answer

In an integrated REA diagram,every resource must be linked to

Correct AnswerverifiedA

When comparing REA diagrams used to design an AIS with a traditionally designed AIS,

Correct AnswerverifiedShow Answer

Combining REA diagrams for individual transaction cycles into a single,enterprise-wide model adds three more rules to the three basic principles for drawing REA diagrams.Which of the following is not one of those two new rules?

Correct AnswerverifiedC

When assigning attributes to each table,

Correct AnswerverifiedShow Answer

Constructing a well-structured,well-developed REA diagram eliminates which anomaly problem(s) ?

Correct AnswerverifiedShow Answer

From the choices below,identify the attribute below that would make the best primary key.

Correct AnswerverifiedShow Answer

The primary key for 1:1 relationship tables

Correct AnswerverifiedShow Answer

In which of the following cases is the number of tables required to represent the relationship equal to three?

Correct AnswerverifiedShow Answer

REA diagrams for individual business cycles may include some events that also appear in the REA diagrams of another cycle.

Correct AnswerverifiedShow Answer

In a relational database,which of the following attributes would typically be represented by a foreign key in the table that stores data about a Disburse Cash entity?

Correct AnswerverifiedShow Answer

In a relational database,which of the following attributes would typically be included in the table that stores data about the Vendor entity?

Correct AnswerverifiedShow Answer

The major benefits of using the REA model as the basis for designing an AIS include all of the following except

Correct AnswerverifiedShow Answer

When integrating multiple REA diagrams into an integrated REA diagram,merging redundant resources

Correct AnswerverifiedC

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A

Correct Answer
verified

Correct Answer
verified
C

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
C