FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 7: Real Modeling

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

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

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

Correct Answer

verified

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

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

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

Correct Answer

verified

D

Question 3

Multiple Choice

Review LaterAdd Note

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

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 table(s) will have a compound primary key: (i) customer table, (ii) prepare drink/ingredients table?

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

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

Cardinalities:

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

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

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

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

-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}$

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

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

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?

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

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.

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

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?