Question 1

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)  InventoryE) B) and C)
F) B) and D)

Question 2

The primary key for M:N 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)  Is impossible to determineE) A) and C)
F) A) and B)

Question 3

In an integrated REA diagram,every resource must be 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) A) and B)
F) C) and D)

Question 4

In an integrated REA diagram,every event must be 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 D)

Question 5

Because information about temporal imbalances between two _________,such as accounts receivable and accounts payable,is needed so frequently,such calculated values are sometimes stored as _________ in the appropriate tables.

Accepted Answer

A)  Events,agents.
B)  Events,attributes.
C)  Resources,agents.
D)  Resources,attributes.E) B) and C)
F) A) and D)

Question 6

Explain a completeness check.

Accepted Answer

The list of attributes that users and ma...

Question 7

Other attributes besides the primary key are

Accepted Answer

A)  Included to satisfy transaction processing requirements.
B)  Included to meet management's information needs.
C)  Both A and B
D)  None of the aboveE) A) and C)
F) All of the above

Question 8

Cardinalities reflect __________ about the organization being modeled and its business practices.

Accepted Answer

A)  assumptions
B)  opinions
C)  facts
D)  theoriesE) A) and B)
F) A) and C)

Question 9

The majors 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) C) and D)
F) B) and C)

Question 10

Where is information traditionally found in journals stored in an REA database?

Accepted Answer

A)  Agent
B)  Event
C)  Relationship
D)  ResourceE) B) and C)
F) None of the above

Question 11

What are the advantages of the REA data model over the traditional AIS model?

Accepted Answer

A major advantage of the REA data model ...

Question 12

In an integrated REA diagram,a focal event is one that

Accepted Answer

A)  is linked to at least two other events and has a minimum cardinality of zero with the linked events.
B)  is linked to at one other event and has a minimum cardinality of zero with the linked events.
C)  is linked to at least two other events and has a minimum cardinality of one with the linked events.
D)  is linked to at least one other event and has a minimum cardinality of one with the linked events.E) A) and B)
F) A) and C)

Question 13

In an integrated REA diagram,every agent must be 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) B) and C)
F) A) and D)

Question 14

Which entity is likely to be part of the payroll cycle,expenditure cycle,and the revenue cycle?

Accepted Answer

A)  Customer
B)  Cash
C)  Supplier
D)  InventoryE) All of the above
F) B) and C)

Question 15

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 numberE) None of the above
F) A) and D)

Question 16

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

Accepted Answer

A)  Invoice number
B)  Credit limit
C)  Product code
D)  BackorderE) None of the above
F) A) and B)

Question 17

Integrating separate REA diagrams into a single comprehensive enterprise-wide model of the organization,requires understanding what the __________ in each separate diagram reveal about the organization's business policies and activities.

Accepted Answer

A)  cardinalities
B)  data
C)  events
D)  transactionsE) A) and B)
F) A) and C)

Question 18

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)  All of the above.E) B) and C)
F) All of the above

Question 19

A query that extracts,for a given time period,all purchases for which there is no corresponding disburse cash event will yield

Accepted Answer

A)  a cash account ledger.
B)  a credit sales journal.
C)  an accounts receivable ledger.
D)  an accounts payable journal.E) A) and B)
F) A) and C)

Question 20

Integrating separate REA diagrams developed for individual transaction cycles into a single,comprehensive enterprise-wide data model

Accepted Answer

A)  is possible.
B)  requires understanding what the cardinalities in each separate diagram reveal about the organization's business policies and activities.
C)  provides a single comprehensive enterprise-wide model of the organization.
D)  all of the above are true.E) B) and C)
F) B) and D)

Exam 16: Implementing an Rea Model in a Relational Database

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

Correct AnswerverifiedShow Answer

Integrating separate REA diagrams developed for individual transaction cycles into a single,comprehensive enterprise-wide data model

Correct AnswerverifiedShow Answer

What are the advantages of the REA data model over the traditional AIS model?

Correct AnswerverifiedA major advantage of the REA data model ...View AnswerShow Answer

In a relational database,which of the following attributes would typically be included in the table that stores data about the Customer 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

Which entity is likely to be part of the payroll cycle,expenditure cycle,and the revenue cycle?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

When assigning attributes to each table,

Correct AnswerverifiedShow Answer

In an integrated REA diagram,a focal event is one that

Correct AnswerverifiedShow Answer

Because information about temporal imbalances between two _________,such as accounts receivable and accounts payable,is needed so frequently,such calculated values are sometimes stored as _________ in the appropriate tables.

Correct AnswerverifiedShow Answer

Integrating separate REA diagrams into a single comprehensive enterprise-wide model of the organization,requires understanding what the __________ in each separate diagram reveal about the organization's business policies and activities.

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

Cardinalities reflect __________ about the organization being modeled and its business practices.

Correct AnswerverifiedShow Answer

A query that extracts,for a given time period,all purchases for which there is no corresponding disburse cash event will yield

Correct AnswerverifiedShow Answer

Explain a completeness check.

Correct AnswerverifiedThe list of attributes that users and ma...View AnswerShow Answer

The primary key for M:N relationship tables

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Other attributes besides the primary key are

Correct AnswerverifiedShow Answer

Where is information traditionally found in journals stored in an REA database?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A major advantage of the REA data model ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Because information about temporal imbalances between two _,such as accounts receivable and accounts payable,is needed so frequently,such calculated values are sometimes stored as _ in the appropriate tables.

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The list of attributes that users and ma...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified