Question 1

A balance sheet can be produced from: (i) a view-driven accounting information system, (ii) an event-driven accounting information system.

Accepted Answer

A)  i only. 
B)  ii only. 
C)  Both i and ii. 
D)  Neither i nor ii. 
A)  i only. 
B)  ii only. 
C)  Both i and ii. 
D)  Neither i nor ii. C

Question 2

Which of the following internal controls is unique to view-driven accounting information systems?

Accepted Answer

A)  Equality of debits and credits. 
B)  Separation of duties. 
C)  Pre-numbered documents. 
D)  Virus protection software. 
A)  Equality of debits and credits. 
B)  Separation of duties. 
C)  Pre-numbered documents. 
D)  Virus protection software. A

Question 3

Which table(s) should include a field for total amount due: (i) receive payment, (ii) prepare drink/receive payment?

Accepted Answer

A)  i only. 
B)  ii only. 
C)  Both i and ii. 
D)  Neither i nor ii. 
A)  i only. 
B)  ii only. 
C)  Both i and ii. 
D)  Neither i nor ii. D

Question 4

View-driven systems best support which of the following tasks?

Accepted Answer

A)  Preparing general purpose financial statements. 
B)  Querying a database. 
C)  Producing diverse reports for decision making. 
D)  Deciding which events to record in the system. 
A)  Preparing general purpose financial statements. 
B)  Querying a database. 
C)  Producing diverse reports for decision making. 
D)  Deciding which events to record in the system.

Question 5

-Foreign keys in the "prepare drink" table will come from: (i) take customer order, (ii) customer.

Accepted Answer

A)  i only. 
B)  ii only. 
C)  Both i and ii. 
D)  Neither i nor ii. 
A)  i only. 
B)  ii only. 
C)  Both i and ii. 
D)  Neither i nor ii.

Question 6

-Which of the following fields is least likely to be necessary in the "take customer order" table?

Accepted Answer

A)  Drinks ordered. 
B)  Customer name. 
C)  Employee name. 
D)  Transaction number. 
A)  Drinks ordered. 
B)  Customer name. 
C)  Employee name. 
D)  Transaction number.

Question 7

-REAL model analysis.
Indicate whether each of the following statements is true or false based on the REAL model above. Do not make any changes to the REAL model. $\begin{array}{|c|c|l|}
\hline \text { True } & \text { False } & \
\hline & & \text { a. A single check can pay for multiple invoices. } \
\hline &&\text { b. Anvone in the companv can write a check to a vendor. }\
\hline&& \text {c. Every employee in the company is authorized to prepare purchase }\
&&\text {orders.}\
\hline &&\text {d. Many requisitions can be consolidated in a single purchase order.}\ 
\hline&& \text { e. Multiple invoices can be paid with a single check. } \
\hline&& \text { f. One purchase order can generate more than one receiving report. } \
\hline&& \text { g. Purchasing department emplovees are assigned specific vendors. } \
\hline&& \text { h. Several purchase orders can come from the same requisition. } \
\hline &&\text { i. The company accepts partial shipments. } \
\hline&& \text { j. The company has only one employee. }\
\hline  
\end{array}$

Accepted Answer

The answer of  
-REAL model analysis.
Indicate whether each of...

Question 8

Cardinalities:

Accepted Answer

A)  Summarize the relationships between elements of a REAL model. 
B)  Do not exist between events in a REAL model. 
C)  Assist designers in understanding an organization's environment. 
D)  Promote strong internal control. 
A)  Summarize the relationships between elements of a REAL model. 
B)  Do not exist between events in a REAL model. 
C)  Assist designers in understanding an organization's environment. 
D)  Promote strong internal control.

Question 9

-Based on the REAL model above, which of the following statements is most true?

Accepted Answer

A)  Supervisors inspect every room that has been cleaned. 
B)  Maids use the same cart every day. 
C)  The system exhibits weak internal control over inventory. 
D)  Supervisors choose which rooms to inspect. 
A)  Supervisors inspect every room that has been cleaned. 
B)  Maids use the same cart every day. 
C)  The system exhibits weak internal control over inventory. 
D)  Supervisors choose which rooms to inspect.

Question 10

Steps in REAL modeling. Fill in the blanks below according to the steps discussed in the text for developing a REAL model. Then, number the steps in the correct order.

Accepted Answer

The answer of Steps in REAL modeling. Fill in the...

Question 11

Which fields in the "prepare drink" table are foreign keys: (i) order number, (ii) customer ID, (iii) employee ID?

Accepted Answer

A)  i and ii only. 
B)  ii and iii only. 
C)  i and iii only. 
D)  i, ii and iii. 
A)  i and ii only. 
B)  ii and iii only. 
C)  i and iii only. 
D)  i, ii and iii.

Question 12

End-of-month batch processing is most commonly associated with:

Accepted Answer

A)  Event-driven systems. 
B)  View-driven systems. 
C)  Query-based systems. 
D)  Paper-based systems. 
A)  Event-driven systems. 
B)  View-driven systems. 
C)  Query-based systems. 
D)  Paper-based systems.

Question 13

Marsha is considering two accounting information systems for implementation in her organization. $\begin{array}{|l|l|l|}
\hline& \text { System A } & \text { System B } \
\hline \begin{array}{l}
\text { Source document } \
\text { formats }
\end{array} & \begin{array}{l}
\text { Paper } \
\text { only }
\end{array} & \begin{array}{l}
\text { Paper and } \
\text { electronic }
\end{array} \
\hline \begin{array}{l}
\text { Contains a table } \
\text { titled "journal } \
\text { entries" }
\end{array} & \text { No } & \text { Yes } \
\hline \begin{array}{l}
\text { Based on a REAL } \
\text { model }
\end{array} & \text { No } & \text { No } \
\hline \begin{array}{l}
\text { Generates financial } \
\text { statements and other } \
\text { pre-defined reports }
\end{array} & \text { Yes } & \text { Yes } \
\hline \begin{array}{l}
\text { Outputs can be } \
\text { accessed by }
\end{array} & \begin{array}{l}
\text { Anyone in the } \
\text { organization }
\end{array} & \begin{array}{l}
\text { Accounting } \
\text { personnel only }
\end{array} \
\hline
\end{array}$

-Which system(s) can incorporate some form of information technology?

Accepted Answer

A)  System A. 
B)  System B. 
C)  Both System A and System B. 
D)  Neither System A nor System B. 
A)  System A. 
B)  System B. 
C)  Both System A and System B. 
D)  Neither System A nor System B.

Question 14

Within the context of REAL modeling, which of the following would best be described as decision/management events: (i) preparing a cost-benefit analysis of an event-driven accounting information system, (ii) delivering merchandise to customers.

Accepted Answer

A)  i only. 
B)  ii only. 
C)  Both i and ii. 
D)  Neither i nor ii. 
A)  i only. 
B)  ii only. 
C)  Both i and ii. 
D)  Neither i nor ii.

Question 15

Which of the following causes a database to update a junction table when its component tables are updated?

Accepted Answer

A)  Normalization. 
B)  Referential integrity. 
C)  Compound primary keys. 
D)  Cascading. 
A)  Normalization. 
B)  Referential integrity. 
C)  Compound primary keys. 
D)  Cascading.

Question 16

"Apply for financial aid" is an example of a(n) __ event.

Accepted Answer

A)  Operating. 
B)  Information. 
C)  Decision. 
D)  Strategic. 
A)  Operating. 
B)  Information. 
C)  Decision. 
D)  Strategic.

Question 17

Which table(s) will have a compound primary key: (i) customer table, (ii) prepare drink/ingredients table?

Accepted Answer

A)  i only. 
B)  ii only. 
C)  Both i and ii. 
D)  Neither i nor ii. 
A)  i only. 
B)  ii only. 
C)  Both i and ii. 
D)  Neither i nor ii.

Question 18

A REAL model contains four resources, three events and two agents. The database will therefore contain how many tables?

Accepted Answer

A)  Four. 
B)  Three. 
C)  Two. 
D)  Some other number. 
A)  Four. 
B)  Three. 
C)  Two. 
D)  Some other number.

Question 19

-Which of the following fields would be excluded from the "supplies" table because of the rules of data normalization?

Accepted Answer

A)  Supply ID. 
B)  Beginning quantity. 
C)  "As of" date. 
D)  Total quantity issued. 
A)  Supply ID. 
B)  Beginning quantity. 
C)  "As of" date. 
D)  Total quantity issued.

Question 20

Marsha is considering two accounting information systems for implementation in her organization. $\begin{array}{|l|l|l|}
\hline& \text { System A } & \text { System B } \
\hline \begin{array}{l}
\text { Source document } \
\text { formats }
\end{array} & \begin{array}{l}
\text { Paper } \
\text { only }
\end{array} & \begin{array}{l}
\text { Paper and } \
\text { electronic }
\end{array} \
\hline \begin{array}{l}
\text { Contains a table } \
\text { titled "journal } \
\text { entries" }
\end{array} & \text { No } & \text { Yes } \
\hline \begin{array}{l}
\text { Based on a REAL } \
\text { model }
\end{array} & \text { No } & \text { No } \
\hline \begin{array}{l}
\text { Generates financial } \
\text { statements and other } \
\text { pre-defined reports }
\end{array} & \text { Yes } & \text { Yes } \
\hline \begin{array}{l}
\text { Outputs can be } \
\text { accessed by }
\end{array} & \begin{array}{l}
\text { Anyone in the } \
\text { organization }
\end{array} & \begin{array}{l}
\text { Accounting } \
\text { personnel only }
\end{array} \
\hline
\end{array}$

-Which system(s) provide data for making decisions?

Accepted Answer

A)  System A. 
B)  System B. 
C)  Both System A and System B. 
D)  Neither System A nor System B. 
A)  System A. 
B)  System B. 
C)  Both System A and System B. 
D)  Neither System A nor System B.

A balance sheet can be produced from: (i) a view-driven accounting information system, (ii) an event-driven accounting information system.

Which of the following internal controls is unique to view-driven accounting information systems?

Which table(s) should include a field for total amount due: (i) receive payment, (ii) prepare drink/receive payment?

View-driven systems best support which of the following tasks?

-Foreign keys in the "prepare drink" table will come from: (i) take customer order, (ii) customer.

-Which of the following fields is least likely to be necessary in the "take customer order" table?

Cardinalities:

-Based on the REAL model above, which of the following statements is most true?

Steps in REAL modeling. Fill in the blanks below according to the steps discussed in the text for developing a REAL model. Then, number the steps in the correct order.

Which fields in the "prepare drink" table are foreign keys: (i) order number, (ii) customer ID, (iii) employee ID?

End-of-month batch processing is most commonly associated with:

Within the context of REAL modeling, which of the following would best be described as decision/management events: (i) preparing a cost-benefit analysis of an event-driven accounting information system, (ii) delivering merchandise to customers.

Which of the following causes a database to update a junction table when its component tables are updated?

"Apply for financial aid" is an example of a(n) __ event.

Which table(s) will have a compound primary key: (i) customer table, (ii) prepare drink/ingredients table?

A REAL model contains four resources, three events and two agents. The database will therefore contain how many tables?

-Which of the following fields would be excluded from the "supplies" table because of the rules of data normalization?

Rolse and Purpose of Accountig Information Systems

Transaction Processing in the AIS

Professionalisam and Ethics

Internal Controls

Flow Charting

Data Flow Diagramming

XBRL

Business and Enterprise Resource Planning Systems

Salles - Collection Process

Acquestion Payment Process

Other Business Process

Bussiness Process Mamagement

Computer Crime and Information Technology Security

Dicision Making Models and Knowledge Management

Professional Certifications and Career Planning

Auditing and Evaluating the AIS

Filters

Exam 7: Real Modeling

A balance sheet can be produced from: (i) a view-driven accounting information system, (ii) an event-driven accounting information system.

Which of the following internal controls is unique to view-driven accounting information systems?

Which table(s) should include a field for total amount due: (i) receive payment, (ii) prepare drink/receive payment?

View-driven systems best support which of the following tasks?

-Foreign keys in the "prepare drink" table will come from: (i) take customer order, (ii) customer.

-Which of the following fields is least likely to be necessary in the "take customer order" table?

Cardinalities:

-Based on the REAL model above, which of the following statements is most true?

Steps in REAL modeling. Fill in the blanks below according to the steps discussed in the text for developing a REAL model. Then, number the steps in the correct order.

Which fields in the "prepare drink" table are foreign keys: (i) order number, (ii) customer ID, (iii) employee ID?

End-of-month batch processing is most commonly associated with:

Within the context of REAL modeling, which of the following would best be described as decision/management events: (i) preparing a cost-benefit analysis of an event-driven accounting information system, (ii) delivering merchandise to customers.

Which of the following causes a database to update a junction table when its component tables are updated?

"Apply for financial aid" is an example of a(n) __ event.

Which table(s) will have a compound primary key: (i) customer table, (ii) prepare drink/ingredients table?

A REAL model contains four resources, three events and two agents. The database will therefore contain how many tables?

-Which of the following fields would be excluded from the "supplies" table because of the rules of data normalization?

Rolse and Purpose of Accountig Information Systems

Transaction Processing in the AIS

Professionalisam and Ethics

Internal Controls

Flow Charting

Data Flow Diagramming

XBRL

Business and Enterprise Resource Planning Systems

Salles - Collection Process

Acquestion Payment Process

Other Business Process

Bussiness Process Mamagement

Computer Crime and Information Technology Security

Dicision Making Models and Knowledge Management

Professional Certifications and Career Planning

Auditing and Evaluating the AIS

Filters