Question 1

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

Question 2

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 D

Question 3

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

Accepted Answer

In traditional AISs,journals provide a chronological listing of transactions.In a relational database designed according to the REA data model,event entities store information about transactions.Thus,the information normally found in a journal is contained in the tables used to record data about events.For example,each row in the Sales event table contains information about a particular sales transaction.Thus,a sales journal can be produced by writing a query that displays the appropriate entries in the sales table for a given period.In a similar manner,queries of the Order Inventory event and Cash Disbursements event tables can be used to generate purchases and cash disbursements journals.

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

Question 5

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) None of the above.An integrated REA diagram merges multiple copies of all entities. 
A) resource; event; agent 
B) event; agent; resource 
C) resource; agent; event 
D) None of the above.An integrated REA diagram merges multiple copies of all entities.

Question 6

Rebus Fashions provides haircuts to men and women.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 started 
C) Name of customer 
D) All of the above are appropriate attributes for the Customer table. 
A) Date of sale 
B) Time hair cut was started 
C) Name of customer 
D) All of the above are appropriate attributes for the Customer table.

Question 7

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

Accepted Answer

A) height (in inches) 
B) date of first purchase 
C) zip code 
D) customer telephone number 
A) height (in inches) 
B) date of first purchase 
C) zip code 
D) customer telephone number

Question 8

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 be an attribute in the table for Display Space Rental?

Accepted Answer

A) Convention name 
B) Deposit paid 
C) Balance paid 
D) Convention address 
A) Convention name 
B) Deposit paid 
C) Balance paid 
D) Convention address

Question 9

Which of the statements below is false with regards to creating database tables from an REA diagram?

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

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

Accepted Answer

A) Invoice number 
B) Credit limit 
C) Product code 
D) Backorder 
A) Invoice number 
B) Credit limit 
C) Product code 
D) Backorder

Question 11

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

Accepted Answer

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

Question 12

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 13

Which of the following is not one of the three steps 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) Link every event to at least one resource. 
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) Link every event to at least one resource. 
D) Use foreign keys to implement one-to-one and one-to-many relationships.

Question 14

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

Accepted Answer

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

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

Question 16

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 
A) Resource entities 
B) Agent entities 
C) Event entities 
D) All of the above

Question 17

Which of the below statements is false with respect to REA diagrams for individual transaction cycles?

Accepted Answer

A) They depict basic give-to-get economic duality relationships. 
B) They usually provide only a partial view of resources. 
C) They need to be combined in order to provide a comprehensive enterprise-wide data model. 
D) They show both how resources are acquired and how they are used. 
A) They depict basic give-to-get economic duality relationships. 
B) They usually provide only a partial view of resources. 
C) They need to be combined in order to provide a comprehensive enterprise-wide data model. 
D) They show both how resources are acquired and how they are used.

Question 18

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 19

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.

Question 20

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 
A) Event entities 
B) Agent entities 
C) Both A and B 
D) None of the above

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

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?

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

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?

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

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

Which of the statements below is false with regards to creating database tables from an REA diagram?

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

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

The type of relationship between two entities is determined by

Which of the following is not one of the three steps to implementing an REA diagram in a relational database?

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

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

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

Which of the below statements is false with respect to REA diagrams for individual transaction cycles?

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

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

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

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

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

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?

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

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?

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

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

Which of the statements below is false with regards to creating database tables from an REA diagram?

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

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

The type of relationship between two entities is determined by

Which of the following is not one of the three steps to implementing an REA diagram in a relational database?

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

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

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

Which of the below statements is false with respect to REA diagrams for individual transaction cycles?

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

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

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

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

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