Question 1

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. D

Question 2

When integrating multiple REA diagrams into an integrated REA diagram,to merge an event that appears in both business cycle REA diagrams,

Accepted Answer

A)  the event that appears in both business cycle REA diagrams may be linked to either an event that is part of one business cycle or to an event that is part of another business cycle.
B)  the event that appears in both business cycle REA diagrams may be linked to an event that is part of one business cycle and to an event that is part of another business cycle.
C)  One cannot merge an event that appears in both business cycles.
D)  none of the above

Question 3

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

Accepted Answer

A major advantage of the REA data model is that it integrates non-financial and financial data in the AIS and makes both types of data easily accessible to management.In contrast to the REA data model,the general ledger in traditionally designed AISs uses the chart of accounts to store and organize data based on the structure of financial statements.Consequently,traditional AISs contain only data about the financial aspects of transactions.Other information that may be of use to management,such as the time of day a sale occurred or the reason why a customer was purchasing a specific item,would have to be stored in a separate database or information system.The existence of separate systems makes it more difficult for management to easily and quickly access the information it needs.It also provides opportunities for data entry errors to create inconsistencies between systems,thereby reducing the utility of any reports that are generated.Thus,a major benefit of using the REA model as the basis for designing an AIS is the ability to easily integrate information that traditionally appears in financial statements with other,non-financial information necessary to effectively manage operations and evaluate performance.It is vitally important that an organization's AIS be capable of storing both traditional financial measures and other operational performance measures.

Question 4

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.

Question 5

Which of the following elements found in a traditional AIS system are not represented as entities in an REA relational database,but rather must be retrieved through the use of queries?

Accepted Answer

A)  accounts receivable
B)  the general ledger
C)  accounts payable
D)  all of the above

Question 6

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. C

Question 7

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 above

Question 8

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

Accepted Answer

A)  Last name.
B)  Date of entry.
C)  Airport code.
D)  Passport control number.

Question 9

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)  does not exist.Many-to-many relationship tables only use foreign keys.

Question 10

Explain where in the REA model you can find the information normally found in a ledger.

Accepted Answer

In traditional AISs,ledgers are master f...

Question 11

In a relational database designed according to the REA model,where is information about an organization's liabilities generally stored?

Accepted Answer

A)  Resource entities.
B)  Agent entities.
C)  Event entities.
D)  All of the above.

Question 12

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.

Question 13

Which of the following is/are true with regards to using 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 14

Describe the steps that should be taken as a final accuracy check for designing a well-structured relational database.

Accepted Answer

Steps that should be taken as a final ac...

Question 15

Identify the attribute below that would not make a good primary key.

Accepted Answer

A)  Postal code.
B)  Social security number.
C)  A unique number automatically generated by the system.
D)  Cell phone number.

Question 16

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

Question 17

In a relational database designed according to the REA model,where is information about transactions stored?

Accepted Answer

A)  Resource entities.
B)  Agent entities.
C)  Event entities.
D)  All of the above.

Question 18

In a relational database designed according to the REA model,where is information about accounts receivable stored?

Accepted Answer

A)  Event entities.
B)  Agent entities.
C)  Both A and B.
D)  None of the above.

Question 19

An integrated REA diagram merges multiple copies of ________ and ________ entities but retains multiple copies of ________ entities.

Accepted Answer

A)  resource;event;agent
B)  event;agent;resource
C)  resource;agent;event
D)  event;resource;agent

Question 20

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

Accepted Answer

A)  
B)  
C)  
D)

Exam 18: Implementing an Rea Model in a Relational Database

When assigning attributes to each table,

Correct Answer
verified
D

When integrating multiple REA diagrams into an integrated REA diagram,to merge an event that appears in both business cycle REA diagrams,

Correct Answer
verified

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

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

Correct Answer
verified

Which of the following elements found in a traditional AIS system are not represented as entities in an REA relational database,but rather must be retrieved through the use of queries?

Correct Answer
verified

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 Answer
verified
C

In an REA diagram,resource entities

Correct Answer
verified

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

Correct Answer
verified

The primary key for M:N relationship tables

Correct Answer
verified

Explain where in the REA model you can find the information normally found in a ledger.

Correct Answer
verified
In traditional AISs,ledgers are master f...
View Answer

In a relational database designed according to the REA model,where is information about an organization's liabilities generally stored?

Correct Answer
verified

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

Correct Answer
verified

Which of the following is/are true with regards to using REA diagrams to retrieve information from a database?

Correct Answer
verified

Describe the steps that should be taken as a final accuracy check for designing a well-structured relational database.

Correct Answer
verified
Steps that should be taken as a final ac...
View Answer

Identify the attribute below that would not make a good primary key.

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

In a relational database designed according to the REA model,where is information about transactions stored?

Correct Answer
verified

In a relational database designed according to the REA model,where is information about accounts receivable stored?

Correct Answer
verified

An integrated REA diagram merges multiple copies of and entities but retains multiple copies of entities.

Correct Answer
verified

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

Correct Answer
verified

Exam 18: Implementing an Rea Model in a Relational Database

When assigning attributes to each table,

Correct AnswerverifiedD

When integrating multiple REA diagrams into an integrated REA diagram,to merge an event that appears in both business cycle REA diagrams,

Correct AnswerverifiedShow Answer

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

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

Correct AnswerverifiedShow Answer

Which of the following elements found in a traditional AIS system are not represented as entities in an REA relational database,but rather must be retrieved through the use of queries?

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 AnswerverifiedC

In an REA diagram,resource entities

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 M:N relationship tables

Correct AnswerverifiedShow Answer

Explain where in the REA model you can find the information normally found in a ledger.

Correct AnswerverifiedIn traditional AISs,ledgers are master f...View AnswerShow Answer

In a relational database designed according to the REA model,where is information about an organization's liabilities generally stored?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following is/are true with regards to using REA diagrams to retrieve information from a database?

Correct AnswerverifiedShow Answer

Describe the steps that should be taken as a final accuracy check for designing a well-structured relational database.

Correct AnswerverifiedSteps that should be taken as a final ac...View AnswerShow Answer

Identify the attribute below that would not make a good primary key.

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

In a relational database designed according to the REA model,where is information about transactions stored?

Correct AnswerverifiedShow Answer

In a relational database designed according to the REA model,where is information about accounts receivable stored?

Correct AnswerverifiedShow Answer

An integrated REA diagram merges multiple copies of ________ and ________ entities but retains multiple copies of ________ entities.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified
D

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
C

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
In traditional AISs,ledgers are master f...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Steps that should be taken as a final ac...
View Answer

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

An integrated REA diagram merges multiple copies of and entities but retains multiple copies of entities.

Correct Answer
verified

Correct Answer
verified