Question 1

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

Accepted Answer

The answer of 
-Based on the REAL model above, which...

Question 2

-A supervisor wanted to list the names of maids whose inspections were unsatisfactory. How many database tables would the supervisor incorporate in the query?

Accepted Answer

The answer of 
-A supervisor wanted to list the names...

Question 3

Limitations of view-driven systems: Fill in the blanks below according to the limitations identified by Walker and Denna. Each blank may include a single word or an entire phrase.
A) Data in a view-driven system are highly ______ and are stored in ______.
B) In view-driven systems, the ______ process is often ______ and ______.
C) The system captures a very ______ set of data.
D) They focus on business events that are ______ in the accounting information system with ______ and ______.
E) They often process data in ______, frequently at the ______.

Accepted Answer

The answer of Limitations of view-driven systems: Fill in the...

Question 4

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 5

Basic database table creation.
Specify the structure of all database tables indicated by the REAL model below. Indicate primary keys by underlining and foreign keys with brackets.

Accepted Answer

The answer of Basic database table creation.
Specify the structure of...

Question 6

How many events would be included in the REAL model that underlies the tables?

Accepted Answer

The answer of How many events would be included in...

Question 7

-Who is in the best position to steal supplies?

Accepted Answer

Supervisors have access to all areas of the hotel and are not as closely supervised as other employees.

Question 8

Database creation concepts
Indicate whether each of the following statements is true based on the REAL model provided.

Accepted Answer

The answer of Database creation concepts
Indicate whether each of the...

Question 9

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

Question 10

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

Accepted Answer

Total quantity issued would be excluded because it can be derived from other fields, violating normalization rules which aim to eliminate redundant data.

Question 11

In the tables listed above, which field is most likely to be automatically numbered?

Accepted Answer

Transaction numbers are typically automatically assigned and incremented by a database system, whereas fields like Customer ID and Employee ID are often assigned or entered manually. Quantity prepared is a measurement or count rather than an identifier, so it is less likely to be automatically numbered.

Question 12

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

Accepted Answer

The given model does not provide any information about the use of carts or the control over inventory. However, it suggests that supervisors are the ones who choose which rooms to inspect.

Question 13

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

Accepted Answer

The answer of Which table(s) should include a field for...

Question 14

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

Accepted Answer

The prepare drink/ingredients table is more likely to have a compound primary key as it represents a many-to-many relationship between drinks and ingredients. The primary key could include both the drink ID and the ingredient ID, creating a compound primary key. The customer table may have a single primary key, such as a customer ID. Therefore, the correct answer is B, ii only.

Question 15

Basic REAL model construction.
Draw the REAL model components, including cardinalities, indicated by each of the following independent situations.
a. One or more flight attendants supervise the boarding process for many passengers on an airplane.
b. One photographer uses a digital camera to take pictures of several students in a single elementary school class.
c. A group of friends order various menu items at a local restaurant; the group is assigned one table server.

Accepted Answer

The answer of Basic REAL model construction.
Draw the REAL model...

Question 16

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

Accepted Answer

All three fields, order number, customer ID, and employee ID, can be foreign keys if they reference primary keys in other tables such as orders, customers, and employees, respectively.

Question 17

Match between columns
                        Premises: Associated most closely with general ledger software.
Inherently relies on debits and credits.
Source documents are paper-based.
Separation of duties not required.
Facilitates decision making by non-accountants.
Closely associated with the steps in the accounting cycle.
Capable of producing general purpose financial statements.
Never relies on information technology.
Connected most closely with enterprise resource planning systems.
Provides information for making decisions.

Accepted Answer

The Answer of Event-driven systems only. and Both event- and is...

Question 18

Match between columns
                        Premises:  Associated most closely with general ledger software.
 Capable of producing general purpose financial statements.
 Closely associated with the steps in the accounting cycle.
 Connected most closely with enterprise resource planning systems.
 Facilitates decision making by non-accountants.
 Inherently relies on debits and credits.
 Never relies on information technology.
 Provides information for making decisions.
 Separation of duties not required.
 Source documents are paper-based.

Accepted Answer

The Answer of Event-driven systems only. and View-driven systems only. is...

Quiz 7: Real Modeling