Question 1

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

Accepted Answer

A) Resource,event,agent 
B) Relationship,economic,accounting 
C) Resource,economic,agent 
D) Relationship,event,accounting 
A) Resource,event,agent 
B) Relationship,economic,accounting 
C) Resource,economic,agent 
D) Relationship,event,accounting

Question 2

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

Accepted Answer

In traditional AISs,journals provide a c

Question 3

What kinds of databases can the REA data model be used to design?

Accepted Answer

The REA data model c

Question 4

When merging redundant resource entities into a new REA diagram,

Accepted Answer

A) Common resources are placed between the events that affect them. 
B) Each resource is connected to two agents that either increase or decrease it. 
C) Resources are duplicated to show the give and get of economic duality relationships. 
D) None of the above. 
A) Common resources are placed between the events that affect them. 
B) Each resource is connected to two agents that either increase or decrease it. 
C) Resources are duplicated to show the give and get of economic duality relationships. 
D) None of the above.

Question 5

Which entity is 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 
A) Receive Goods 
B) Customer 
C) Disburse Cash 
D) Inventory

Question 6

What is the first step to implementing an REA diagram in a relational database?

Accepted Answer

A) Assign attributes to appropriate tables. 
B) Create a table for each distinct entity in the diagram and for each many-to-many relationship. 
C) Identify cardinalities. 
D) Use foreign keys to implement one-to-one and one-to-many relationships. 
A) Assign attributes to appropriate tables. 
B) Create a table for each distinct entity in the diagram and for each many-to-many relationship. 
C) Identify cardinalities. 
D) Use foreign keys to implement one-to-one and one-to-many relationships.

Question 7

Concerning a correctly drawn enterprise-wide REA diagram,which of the following statements is not true?

Accepted Answer

A) Every event must be linked to at least one resource. 
B) Merging two transaction cycles on a common event may affect the minimum cardinalities between the merged event and the agents participating in that event. 
C) Every event must be linked to one agent who participates in that event. 
D) Creating a set of tables from an REA diagram automatically results in a well-structured relational database. 
A) Every event must be linked to at least one resource. 
B) Merging two transaction cycles on a common event may affect the minimum cardinalities between the merged event and the agents participating in that event. 
C) Every event must be linked to one agent who participates in that event. 
D) Creating a set of tables from an REA diagram automatically results in a well-structured relational database.

Question 8

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 Receive Inventory entity?

Accepted Answer

A) Purchase order number 
B) Payment terms 
C) Product code 
D) Date 
A) Purchase order number 
B) Payment terms 
C) Product code 
D) Date

Question 9

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)    
A)    
B)    
C)    
D)

Question 10

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

Accepted Answer

A) 6 
B) 9 
C) 11 
D) 13 
A) 6 
B) 9 
C) 11 
D) 13

Question 11

Which type of relationship cardinality requires the implementation of a separate table?

Accepted Answer

A) 1:0 
B) 1:1 
C) 1:N 
D) M:N 
A) 1:0 
B) 1:1 
C) 1:N 
D) M:N

Question 12

What is a concatenated key?

Accepted Answer

A concatenated key i

Question 13

REA data modeling

Accepted Answer

A) Can be used only to model financial data. 
B) Can provide accountants with a method for more easily adapting the AIS to respond to change. 
C) Is an example of a traditional accounting concept. 
D) Is just a fancy way of doing E-R diagramming. 
A) Can be used only to model financial data. 
B) Can provide accountants with a method for more easily adapting the AIS to respond to change. 
C) Is an example of a traditional accounting concept. 
D) Is just a fancy way of doing E-R diagramming.

Question 14

When implementing 1:1 and 1:N relationships

Accepted Answer

A) Foreign keys are used. 
B) Separate tables could be used. 
C) The primary key of one entity becomes a foreign key in the other entity's table. 
D) Concatenated primary keys are used. 
A) Foreign keys are used. 
B) Separate tables could be used. 
C) The primary key of one entity becomes a foreign key in the other entity's table. 
D) Concatenated primary keys are used.

Question 15

An integrated REA diagram merges multiple copies of some entities in order to

Accepted Answer

A) Minimize the repetition of agent entities. 
B) Maximize the legibility of the comprehensive REA diagram by avoiding the need to have relationship lines cross one another. 
C) Both A and B are true. 
D) Both A and B are false. 
A) Minimize the repetition of agent entities. 
B) Maximize the legibility of the comprehensive REA diagram by avoiding the need to have relationship lines cross one another. 
C) Both A and B are true. 
D) Both A and B are false.

Question 16

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

Question 17

Which of the following is not part of a "final accuracy check" when creating relational tables from an REA diagram?

Accepted Answer

A) Every attribute in every table is single-valued (i.e.,each table is a flat file). 
B) Every event must be linked to at least one resource. 
C) Every table must have a primary key. 
D) Other non-key attributes in each table must be either a fact about the thing designated by the primary key or foreign keys used to link that table to another table. 
A) Every attribute in every table is single-valued (i.e.,each table is a flat file). 
B) Every event must be linked to at least one resource. 
C) Every table must have a primary key. 
D) Other non-key attributes in each table must be either a fact about the thing designated by the primary key or foreign keys used to link that table to another table.

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

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

What kinds of databases can the REA data model be used to design?

When merging redundant resource entities into a new REA diagram,

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

What is the first step to implementing an REA diagram in a relational database?

Concerning a correctly drawn enterprise-wide REA diagram,which of the following statements is not true?

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 Receive Inventory entity?

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

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

Which type of relationship cardinality requires the implementation of a separate table?

What is a concatenated key?

REA data modeling

When implementing 1:1 and 1:N relationships

An integrated REA diagram merges multiple copies of some entities in order to

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

Which of the following is not part of a "final accuracy check" when creating relational tables from an REA diagram?

Accounting Information Systems

Overview of Business Processes

Systems Development and Documentation Techniques

Relational Databases

Computer Fraud and Security

Control and Accounting Information Systems

Infromation System Controls for Systems Reliability

Auditing Computer-Based Information Systems

Auditing Computer-Based Informtion Systems

The Revenue Cycle: Sales an Cash Collections

The Expenditure Cycle: Purchasing and Cash Disbursements

The Production Cycle

The Human Resources Managementpayroll Cycle

General Ledger and Reporting System

Data Modeling and Database Design

Special Topics in Rea Modeling

Introduction to Systems Development and Systems Analysis

Ais Development Strategies

Systems Design, Implementation and Operation

Filters

Exam 16: Implementing an Rea Model in a Relational Database

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

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

What kinds of databases can the REA data model be used to design?

When merging redundant resource entities into a new REA diagram,

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

What is the first step to implementing an REA diagram in a relational database?

Concerning a correctly drawn enterprise-wide REA diagram,which of the following statements is not true?

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 Receive Inventory entity?

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

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

Which type of relationship cardinality requires the implementation of a separate table?

What is a concatenated key?

REA data modeling

When implementing 1:1 and 1:N relationships

An integrated REA diagram merges multiple copies of some entities in order to

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

Which of the following is not part of a "final accuracy check" when creating relational tables from an REA diagram?

Accounting Information Systems

Overview of Business Processes

Systems Development and Documentation Techniques

Relational Databases

Computer Fraud and Security

Control and Accounting Information Systems

Infromation System Controls for Systems Reliability

Auditing Computer-Based Information Systems

Auditing Computer-Based Informtion Systems

The Revenue Cycle: Sales an Cash Collections

The Expenditure Cycle: Purchasing and Cash Disbursements

The Production Cycle

The Human Resources Managementpayroll Cycle

General Ledger and Reporting System

Data Modeling and Database Design

Special Topics in Rea Modeling

Introduction to Systems Development and Systems Analysis

Ais Development Strategies

Systems Design, Implementation and Operation

Filters

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