Question 1

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

Accepted Answer

In traditional AISs,ledgers are master files that contain cumulative information about specific accounts.In a relational database designed according to the REA data model,resource and agent entities contain permanent information that is carried over from one fiscal year to the next.Thus,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.

Question 2

Which of the following is false with regards to REA models?

Accepted Answer

A)  Many financial statement accounts are represented as resources in the REA model. 
B)  Accounts such as Accounts Receivable show up as entities in the REA model. 
C)  Some accounts represent an imbalance between two related events in the REA model. 
D)  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. 
A)  Many financial statement accounts are represented as resources in the REA model. 
B)  Accounts such as Accounts Receivable show up as entities in the REA model. 
C)  Some accounts represent an imbalance between two related events in the REA model. 
D)  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. B

Question 3

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

Question 4

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

Accepted Answer

A) 
  
B) 
  
C) 
  
D) 
  
A) 
  
B) 
  
C) 
  
D)

Question 5

Which table is most likely to have a concatenated key?

Accepted Answer

A)  customer 
B)  sales 
C)  customer-sales 
D)  accounts receivable 
A)  customer 
B)  sales 
C)  customer-sales 
D)  accounts receivable

Question 6

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

Accepted Answer

A)  agent. 
B)  event. 
C)  relationship. 
D)  resource. 
A)  agent. 
B)  event. 
C)  relationship. 
D)  resource.

Question 7

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

Question 8

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. 
A)  a cash account ledger. 
B)  a credit sales journal. 
C)  an accounts receivable ledger. 
D)  an accounts payable journal.

Question 9

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

When integrating separate REA diagrams,

Accepted Answer

A)  common resources are placed between the events that affect them. 
B)  each resource is connected to two agents. 
C)  resources are duplicated to show the give and get of economic duality relationships. 
D)  resources are merged if both events in the stockflow relationship are modeled. 
A)  common resources are placed between the events that affect them. 
B)  each resource is connected to two agents. 
C)  resources are duplicated to show the give and get of economic duality relationships. 
D)  resources are merged if both events in the stockflow relationship are modeled.

Question 11

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. 
A)  a cash account ledger. 
B)  a credit sales journal. 
C)  an accounts receivable ledger. 
D)  an accounts payable journal.

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 
A)  update 
B)  insert 
C)  delete 
D)  all of the above

Question 13

Implementation of this REA diagram into a relational database would require how many tables?

Accepted Answer

A)  12 
B)  13 
C)  8 
D)  9 
A)  12 
B)  13 
C)  8 
D)  9

Question 14

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 
A)  accounts receivable 
B)  the general ledger 
C)  accounts payable 
D)  all of the above

Question 15

Rebus Fashions provides haircuts to men and women.Rebus charges $10 per haircut,no matter what type of haircut the customer selects.Rebus uses an REA database to record information that is important to the firm.Rebus has an M:N table named "Customer-Sale" where it keeps information about customer sales.Identify the attribute below that most likely does not belong in the Customer-Sale table.

Accepted Answer

A)  Date of sale 
B)  Time hair cut was finished 
C)  Price of haircut 
D)  All of the above are appropriate attributes for the Customer table. 
A)  Date of sale 
B)  Time hair cut was finished 
C)  Price of haircut 
D)  All of the above are appropriate attributes for the Customer table.

Question 16

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

The type of relationship between two entities is determined by

Accepted Answer

A)  maximum cardinalities only. 
B)  minimum cardinalities only. 
C)  minimum and maximum cardinalities. 
D)  median cardinalities. 
A)  maximum cardinalities only. 
B)  minimum cardinalities only. 
C)  minimum and maximum cardinalities. 
D)  median cardinalities.

Question 18

Helge Autoparts sells new and refurbished auto parts exclusively to auto dealers.Helge purchases inventory from distributors at trade conventions.Each time Helge makes a purchase,the company records the suppliers name,address,date,specific items purchased,price paid for each,and the total amount spent.Helge later researches the inventory items to set the customer price.The company assigns an inventory number to each item purchased and records the customer price for each item.Helge buys price tags and display supplies from Alwin Incorporated,a company that sells them at all trade conventions.All inventory and supplies purchases are immediately paid for with cash or with checks from a bank account in Helge's name.All cash received from sales are also deposited to the same bank account.Several times a year Helge rents display space at dealer conventions.A deposit is always required,and the entire fee is due the day the convention starts.Helge records the deposit and final payment,along with the convention's name and address,in the same worksheet on which purchases of inventory and supplies are recorded. Which of the following would not be an attribute in the Inventory table?

Accepted Answer

A)  Total amount of purchase 
B)  Price paid for inventory 
C)  Asking price 
D)  Inventory number 
A)  Total amount of purchase 
B)  Price paid for inventory 
C)  Asking price 
D)  Inventory number

Question 19

Which of the statements below is false with respect to enterprise-wide REA diagrams?

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

The primary key for a Purchase-Inventory table that consists of the Purchase Order Number and the Inventory Item Number,is known as a

Accepted Answer

A)  concatenated key. 
B)  foreign key 
C)  primary key. 
D)  dual key. 
A)  concatenated key. 
B)  foreign key 
C)  primary key. 
D)  dual key.

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

Which of the following is false with regards to REA models?

The primary key for M:N relationship tables

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

Which table is most likely to have a concatenated key?

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

When assigning attributes to each table,

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

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

When integrating separate REA diagrams,

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

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

Implementation of this REA diagram into a relational database would require how many tables?

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?

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

The type of relationship between two entities is determined by

Which of the statements below is false with respect to enterprise-wide REA diagrams?

The primary key for a Purchase-Inventory table that consists of the Purchase Order Number and the Inventory Item Number,is known as a

Accounting Information Systems: an Overview

Overview of Transaction Processing and Enterprise Resource Planning Systems

Systems Documentation Techniques

Relational Databases

Computer Fraud

Computer Fraud and Abuse Techniques

Control and Accounting Information Systems

Controls for Information Security

Confidentiality and Privacy Controls

Processing Integrity and Availability Controls

Auditing Computer-Based Information Systems

The Revenue Cycle: Sales to Cash Collections

The Expenditure Cycle: Purchasing to Cash Disbursements

The Production Cycle

The Human Resources Management and Payroll Cycle

General Ledger and Reporting System

Database Design Using the Rea Data Model

Special Topics in Rea Modeling

Introduction to Systems Development and Systems Analysis

Ais Development Strategies

Systems Design, implementation, and Operation

Filters

Exam 18: Implementing an Rea Model in a Relational Database

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

Which of the following is false with regards to REA models?

The primary key for M:N relationship tables

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

Which table is most likely to have a concatenated key?

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

When assigning attributes to each table,

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

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

When integrating separate REA diagrams,

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

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

Implementation of this REA diagram into a relational database would require how many tables?

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?

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

The type of relationship between two entities is determined by

Which of the statements below is false with respect to enterprise-wide REA diagrams?

The primary key for a Purchase-Inventory table that consists of the Purchase Order Number and the Inventory Item Number,is known as a

Accounting Information Systems: an Overview

Overview of Transaction Processing and Enterprise Resource Planning Systems

Systems Documentation Techniques

Relational Databases

Computer Fraud

Computer Fraud and Abuse Techniques

Control and Accounting Information Systems

Controls for Information Security

Confidentiality and Privacy Controls

Processing Integrity and Availability Controls

Auditing Computer-Based Information Systems

The Revenue Cycle: Sales to Cash Collections

The Expenditure Cycle: Purchasing to Cash Disbursements

The Production Cycle

The Human Resources Management and Payroll Cycle

General Ledger and Reporting System

Database Design Using the Rea Data Model

Special Topics in Rea Modeling

Introduction to Systems Development and Systems Analysis

Ais Development Strategies

Systems Design, implementation, and Operation

Filters