Question 1

An integrated REA diagram contains multiple copies of

Accepted Answer

A)  Accounts
B)  Agents
C)  Events
D)  Resource

Question 2

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

Accepted Answer

A)   
B)   
C)   
D)

Question 3

Concerning tables for M:N relationships,which of the following statements is false?

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.

Question 4

How many tables are needed to implement an REA data model that has five distinct entities,two M:N relationships and three 1:N relationships in a relational database?

Accepted Answer

A)  5
B)  7
C)  8
D)  10

Question 5

When combining two REA diagrams by merging common entities,changes in the cardinality of the merged entity is needed when it is a

Accepted Answer

A)  Agent
B)  Event
C)  Relationship
D)  Resource

Question 6

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

Accepted Answer

A)  Cash
B)  Customer
C)  Receive Goods
D)  Inventory

Question 7

In an integrated REA diagram,the disburse cash entity is typically linked to

Accepted Answer

A)  Customer
B)  Vendor
C)  Employee Time
D)  Inventory

Question 8

Concerning the creation of tables from an REA diagram,which of the following is false?

Accepted Answer

A)  M:N relationships must be implemented as separate tables.
B)  1:N relationships are implemented with the primary key of the 1 side becoming a foreign key on the N side.
C)  1:1 relationships are implemented with the primary key of either entity included as a foreign key in the table representing the other entity.
D)  All of the above are true

Question 9

Concerning the use of REA diagrams to retrieve information from a database:

Accepted Answer

A)  Although neither journals nor ledgers appear explicitly in an REA diagram,each can be created through appropriate queries.
B)  The information normally found in a journal is contained in the tables used to record data about events.
C)  Much of the information about an organization's assets that is traditionally recorded in ledgers is stored in resource tables in an REA-based relational database.
D)  All of the above

Question 10

Concerning enterprise-wide REA diagrams,which of the following is false?

Accepted Answer

A)  Merging two or more REA diagrams that contain the same resource entity does not require any changes to the cardinality pairs in the individual diagrams.
B)  Merging two or more diagrams that contain a common event entity,however,often requires changing the minimum cardinalities associated with the other events to 0,to reflect the fact that the merged event may be connected to any one of several different events,but not to all of them simultaneously.
C)  The minimum cardinalities associated with agents may also have to be changed to 0.
D)  All of the above are true

Question 11

_______ databases are commonly used to support transaction processing.

Accepted Answer

A)  Access
B)  E-R
C)  REA
D)  Relational

Question 12

Concerning the creation of tables from an REA diagram,which of the following is false?

Accepted Answer

A)  A properly designed relational database has a table for each distinct entity in an REA diagram.
B)  A properly designed relational database has a table for each many-to-many relationship in an REA diagram.
C)  To reduce confusion,table names should not duplicate REA diagram entities' names.
D)  Many-to-many relationships will be shown in tables with hyphenated concatenations of the entities' names.

Question 13

An REA diagram contains five instances of the Customer entity.How many tables does this require in a relational database?

Accepted Answer

A)  one
B)  two
C)  three
D)  four

Question 14

Much of the information about an organization's assets that is traditionally recorded in ledgers is stored in ______ tables in an REA-based relational database.

Accepted Answer

A)  Account
B)  Agent
C)  Event
D)  Resource

Question 15

A query that extracts,for a given time period,the total amount of all sales events for which there is no corresponding receive 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.

Question 16

M:N relationships must be implemented

Accepted Answer

A)  As separate tables
B)  With concatenated primary keys
C)  Both A and B
D)  Neither A nor B

Question 17

A query that extracts,for a given time period,all sales events for which there is no corresponding receive cash event on the date of the sales 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.

Question 18

Concerning the generation of financial statements from an REA-based relational database,which of the following is false?

Accepted Answer

A)  It is possible to use a completed REA diagram to guide the writing of queries to produce the information that would be included in financial statements.
B)  Many financial statement items can be displayed by querying a single table.
C)  It is unnecessary to understand the REA data model to know which tables need to be included in each query to generate the correct answers to financial statement questions.
D)  A major advantage of the REA data model is that it integrates non-financial and financial data.

Question 19

Which table is most likely to have a concatenated key?

Accepted Answer

A)  customer
B)  sales
C)  customer-sales
D)  none of the above

Question 20

Which of the following is a redundant entity that would be merged when two cycles are combined?

Accepted Answer

A)  Customer
B)  Employee Time
C)  Take Order
D)  Inventory

Exam 16: Implementing an Rea Model in a Relational Database

Concerning the generation of financial statements from an REA-based relational database,which of the following is false?

Correct AnswerverifiedShow Answer

Much of the information about an organization's assets that is traditionally recorded in ledgers is stored in ______ tables in an REA-based relational database.

Correct AnswerverifiedShow Answer

Concerning enterprise-wide REA diagrams,which of the following is false?

Correct AnswerverifiedShow Answer

When combining two REA diagrams by merging common entities,changes in the cardinality of the merged entity is needed when it is a

Correct AnswerverifiedShow Answer

Which of the following is a redundant entity that would be merged when two cycles are combined?

Correct AnswerverifiedShow Answer

Concerning tables for M:N relationships,which of the following statements is false?

Correct AnswerverifiedShow Answer

An integrated REA diagram contains multiple copies of

Correct AnswerverifiedShow Answer

A query that extracts,for a given time period,all sales events for which there is no corresponding receive cash event on the date of the sales event will yield

Correct AnswerverifiedShow Answer

M:N relationships must be implemented

Correct AnswerverifiedShow Answer

A query that extracts,for a given time period,the total amount of all sales events for which there is no corresponding receive cash event will yield

Correct AnswerverifiedShow Answer

Which table is most likely to have a concatenated key?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

How many tables are needed to implement an REA data model that has five distinct entities,two M:N relationships and three 1:N relationships in a relational database?

Correct AnswerverifiedShow Answer

_______ databases are commonly used to support transaction processing.

Correct AnswerverifiedShow Answer

Concerning the creation of tables from an REA diagram,which of the following is false?

Correct AnswerverifiedShow Answer

Concerning the use of REA diagrams to retrieve information from a database:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

In an integrated REA diagram,the disburse cash entity is typically linked to

Correct AnswerverifiedShow Answer

An REA diagram contains five instances of the Customer entity.How many tables does this require in a relational database?

Correct AnswerverifiedShow Answer

Concerning the creation of tables from an REA diagram,which of the following is false?

Correct AnswerverifiedShow Answer

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

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