Accounting Information Systems Cybertext Questions

1. Consider the set of tables in the chapter (EMPLOYEES, CUSTOMERS, etc.). The sales manager would like to know the names of customers who have been shipped merchandise via UPS. Which tables MUST be accessed to answer this query?

a. SHIPPERS, SHIPMENTS, SALES-ORDERS, CUSTOMERS

b. SHIPPERS, SHIPMENTS, SALES-ORDERS, ITEMS-ORDERED, CUSTOMERS

c. SHIPPERS, SHIPMENTS, CUSTOMERS

d. CUSTOMERS, SHIPMENTS

e. SHIPPERS, SHIPMENTS, CUSTOMERS, EMPLOYEE

2. Consider the EER diagram of revenue business processes in Chapter 12 and the tables resulting from the application of the conversion rules. The "ITEMS-RETURNED" table must be created because

a. RETURNED-MERCHANDISE is related to both INVENTORY and RETURNS-AND-ALLOWANCES

b. the participation of RETURNED-MERCHANDISE in the "have" relationship is "optional many"

c. the participation of RETURNS-AND-ALLOWANCES in the "have" relationship is "mandatory many"

d. all of the above

e. b and c

3. Consider the set of tables in the chapter (EMPLOYEES, CUSTOMERS, etc.). Referential integrity CANNOT be defined between which of the following pairs of tables?

a. SALES-ORDERS and CONTACTS

b. INVENTORY and ITEMS-ORDERED

c. SALES-ORDERS and ITEMS-ORDERED

d. SALES-ORDERS and CUSTOMERS

e. CUSTOMERS and CONTACTS

4. Consider the following table CONTACTS (SALESPERSON-NO, CUSTOMER-NO) This table is a/an:

a. transitive dependency relation

b. entity relation

c. redundant relation

d. all key relation

e. none of the above

5. Assuming there are no repeating groups, the following table is at least in ITEMS-ORDERED (ORDER-NO, ITEM-NO, ITEM-DESCRIPTION, QUANTITY-ORDERED)

a. third normal form

b. second normal form

c. first normal form

d. fourth normal form

e. fifth normal form