18.11 Answer the following multiple-choice problems. 1. Which of the following types of relationships in an REA diagram must be implemented as a separate table in a relational database? ionships a. 1:1 b. 1:N C. N:1 d. M:N 2. When implementing a revenue cycle REA diagram in a relational database, the relation- ship between customers and sales would be implemented by a. placing the customer number attribute as a foreign key in the sales table b. placing the sales invoice number as a foreign key in the customer table c. either approach is equally acceptable 3. When merging REA diagrams from two different cycles, it is not necessary to change the minimum cardinality for that appear in both of the separate REA diagrams. a. resources b. agents c. events 4. ABC Company sells original manuscripts of Broadway plays. ABC pays for all its pur- chases in full with one check. It allows customers to make installment payments on sales that exceed $33,000. However, a customer cannot make another purchase until all prior purchases have been paid for. The REA diagram for ABC company depicts seven Employee entities, each labeled for the role played by that type of employee (e.g., cashier. salesperson, shipping clerk, accountant, etc.). The REA diagram also contains two re- source entities (Inventory and Cash) and the following events: Purchases, Disburse Cash, Sales, and Receive Cash. The REA diagram also contains two instances of the Customer entity and three instances of the Supplier entity. Implementing the integrated REA dia- gram for the revenue and expenditure cycles of the ABC company in a relational database requires how many tables? a. 5 b. 7 c. 9 d. 15 e. 18 5. The XYZ Company sells sports equipment. The actual sales price of a given item varies throughout the year due to sales events. The actual sales price should be stored as an at tribute in the table. a. Sales b. Inventory c. Sales-Inventory 6. In an integrated REA diagram for both the revenue and expenditure cycles, the quantity on hand during the middle of the year for an inventory item would be stored as an attri bute in the table. a. Inventory. b. Sales-Inventory c. Purchases-Inventory d. None of the three tables