Question 1

Attributes other than the primary key are

Accepted Answer

A) included to satisfy transaction processing requirements. 
B) included to meet management's information needs. 
C) both A and B 
D) none of the above 
A) included to satisfy transaction processing requirements. 
B) included to meet management's information needs. 
C) both A and B 
D) none of the above

Question 2

Why might the same REA diagram result in different relationship cardinalities?

Accepted Answer

A) Different organizations might have different business policies. 
B) Different designers might implement an REA diagram differently. 
C) Different consultants might draw an REA diagram differently. 
D) Errors occur in the REA diagram. 
A) Different organizations might have different business policies. 
B) Different designers might implement an REA diagram differently. 
C) Different consultants might draw an REA diagram differently. 
D) Errors occur in the REA diagram.

Question 3

Describe the three steps to the implementation of an REA diagram in a relational database.

Accepted Answer

Three steps to implementing an REA diagr

Question 4

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 5

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 6

Which of the following would be true when implementing this REA diagram into a relational database?

Accepted Answer

A) The primary key for Employee would be a foreign key for Cash Receipts. 
B) The primary key for Cash Receipts would be a foreign key for Cash. 
C) The primary key for Parts would be a foreign key for Service Request. 
D) The primary key for Sales would be a foreign key for Service Request. 
A) The primary key for Employee would be a foreign key for Cash Receipts. 
B) The primary key for Cash Receipts would be a foreign key for Cash. 
C) The primary key for Parts would be a foreign key for Service Request. 
D) The primary key for Sales would be a foreign key for Service Request.

Question 7

How many tables are needed to implement an REA data model that has three distinct entities,two M:N relationships and two 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 8

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 9

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.

Question 10

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 Purchases table?

Accepted Answer

A) Address where purchase was made. 
B) Person's name or company name from whom the purchase was made. 
C) Date of purchase. 
D) Total amount of purchase. 
A) Address where purchase was made. 
B) Person's name or company name from whom the purchase was made. 
C) Date of purchase. 
D) Total amount of purchase.

Question 11

How many tables are needed to implement an REA data model that has four distinct entities,three M:N relationships and one 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 12

Merging redundant resources will affect cardinalities.

Accepted Answer

A) True 
 B)False

Question 13

Integrating separate REA diagrams developed for individual transaction cycles into a single,comprehensive enterprise-wide data model

Accepted Answer

A) is possible. 
B) requires understanding what the cardinalities in each separate diagram reveal about the organization's business policies and activities. 
C) provides a single comprehensive enterprise-wide model of the organization. 
D) All of the above are true. 
A) is possible. 
B) requires understanding what the cardinalities in each separate diagram reveal about the organization's business policies and activities. 
C) provides a single comprehensive enterprise-wide model of the organization. 
D) All of the above are true.

Question 14

Integrating separate REA diagrams into a single comprehensive enterprise-wide model of the organization requires understanding what the ________ in each separate diagram reveal about the organization's business policies and activities.

Accepted Answer

A) cardinalities 
B) data 
C) events 
D) transactions 
A) cardinalities 
B) data 
C) events 
D) transactions

Question 15

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 16

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 
A) Account 
B) Agent 
C) Event 
D) Resource

Question 17

How many tables are needed to implement an REA data model that has three distinct entities,two M:N relationships and two 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 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 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 19

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 20

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.

Attributes other than the primary key are

Why might the same REA diagram result in different relationship cardinalities?

Describe the three steps to the implementation of an REA diagram in a relational database.

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

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

Which of the following would be true when implementing this REA diagram into a relational database?

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

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

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

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

Merging redundant resources will affect cardinalities.

Integrating separate REA diagrams developed for individual transaction cycles into a single,comprehensive enterprise-wide data model

Integrating separate REA diagrams into a single comprehensive enterprise-wide model of the organization requires understanding what the ________ in each separate diagram reveal about the organization's business policies and activities.

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?

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.

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

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

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

Conceptual Foundations of Accounting Information Systems

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

Attributes other than the primary key are

Why might the same REA diagram result in different relationship cardinalities?

Describe the three steps to the implementation of an REA diagram in a relational database.

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

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

Which of the following would be true when implementing this REA diagram into a relational database?

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

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

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

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

Merging redundant resources will affect cardinalities.

Integrating separate REA diagrams developed for individual transaction cycles into a single,comprehensive enterprise-wide data model

Integrating separate REA diagrams into a single comprehensive enterprise-wide model of the organization requires understanding what the ________ in each separate diagram reveal about the organization's business policies and activities.

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?

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.

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

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

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

Conceptual Foundations of Accounting Information Systems

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