Question 1

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 2

Concatenated keys are

Accepted Answer

A) used when combining two or more REA diagrams. 
B) foreign keys used to implement 1:N or 1:1 relationships. 
C) multiple attribute keys used to implement 1:M relationships. 
D) used to implement M:N relationships. 
A) used when combining two or more REA diagrams. 
B) foreign keys used to implement 1:N or 1:1 relationships. 
C) multiple attribute keys used to implement 1:M relationships. 
D) used to implement M:N relationships.

Question 3

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 4

Nonfinancial information should be collected because

Accepted Answer

A) it may indicate events that may affect resources. 
B) it can be used to plan other activities. 
C) it can be used in transaction processing. 
D) both A and B 
A) it may indicate events that may affect resources. 
B) it can be used to plan other activities. 
C) it can be used in transaction processing. 
D) both A and B

Question 5

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

Accepted Answer

A) A properly designed relational database has a table for each distinct entity in an REA diagram. 
B) A properly designed relational database has a table for each many-to-many relationship in an REA diagram. 
C) To reduce confusion, table names should not duplicate REA diagram entities' names. 
D) Many-to-many relationships will be shown in tables with hyphenated concatenations of the entities' names. 
A) A properly designed relational database has a table for each distinct entity in an REA diagram. 
B) A properly designed relational database has a table for each many-to-many relationship in an REA diagram. 
C) To reduce confusion, table names should not duplicate REA diagram entities' names. 
D) Many-to-many relationships will be shown in tables with hyphenated concatenations of the entities' names.

Question 6

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 7

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 8

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 9

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 10

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 11

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

Accepted Answer

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

Question 12

Which table is most likely to have a concatenated key?

Accepted Answer

A) Inventory. 
B) Sales. 
C) Sales-inventory. 
D) Accounts receivable. 
A) Inventory. 
B) Sales. 
C) Sales-inventory. 
D) Accounts receivable.

Question 13

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 14

Explain a completeness check.

Accepted Answer

The list of attributes that users and ma

Question 15

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.

Question 16

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 17

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. 
A) Postal code. 
B) Social security number. 
C) A unique number automatically generated by the system. 
D) Cell phone number.

Question 18

Which of the following statements is not true with regards to a correctly drawn enterprise-wide REA diagram?

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 other events. 
C) Events can only be merged if they share the same resources and events. 
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 other events. 
C) Events can only be merged if they share the same resources and events. 
D) Creating a set of tables from an REA diagram automatically results in a well-structured relational database.

The type of relationship between two entities is determined by

Concatenated keys are

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

Nonfinancial information should be collected because

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

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.

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

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

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

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

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

Which table is most likely to have a concatenated key?

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

Explain a completeness check.

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

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

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

Which of the following statements is not true with regards to a correctly drawn enterprise-wide REA diagram?

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

The type of relationship between two entities is determined by

Concatenated keys are

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

Nonfinancial information should be collected because

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

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.

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

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

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

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

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

Which table is most likely to have a concatenated key?

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

Explain a completeness check.

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

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

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

Which of the following statements is not true with regards to a correctly drawn enterprise-wide REA diagram?

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