14-25. Quick Jolt Electronics (Understanding Relational Databases) Ouick Jolt Electronics manufactures and sells specialized electronic components to customers across the country. The tables in Figure 14-19 illustrate some of the records in its accounting databases. Thus, for example, the "Sales by Inventory Number" records show detailed sales data for each of the company's inventory items, and the "Customer Payments" records indicate customer cash payments, listed by invoice number. Use the information in these tables to answer the following questions. CHAPTER 14 / Database Design 459 Price Sales by Inventory Number Invoice Number Number Quantity V-1 V-3 Each V-6 Sales by Invoice Number Invoice Customer Number Amount Number V-1 7.200 C-1 V-2 10,000 V-3 16.000 C-5 V-4 10,000 16,600 C-5 35,000 C-3 V-7 23,000 C-4 C-2 2,000 2,000 1,575 3,000 3,500 1.000 600 V-5 Salesperson Date Number July 1 S-12 July 12 S-10 July 22 S-10 July 26 S-10 July 31 S-10 August 1 S-10 August 2S-11 10 V-5 300 V-3 4,000 3,000 5,000 5,000 5,000 NUN Commission Rate V-5 Sales by Salesperson Salesperson Quarterly Number Sales S-10 S-11 S-12 S-78 V-7 7,000 0.10 0.10 0.12 0.08 Customer Data Customer Number Accounts Receivable Amount Customer Payments Invoice Remittance Number Advice Number Amount V-1 R-3 7,200 R-1 1,666 V-2 R-5 1,666 V-3 R-4 16,000 V-4 R-2 10,000 V-5 R-4 16,600 V-2 Customer Name Dunn, Inc. J.P. Carpenter Mabadera Corp. Ghymn and Sons D. Lund, Inc. Sales- person S-12 S-10 S-10 S-99 8-10 FIGURE 14-19 Sample of some of the records in the Quick Jolt accounting database Sequirements In the sales by Invoice Number," what is the total amount of sales on invoice V-2? What was the name of the customer that made this purchase? What specific inventory items did this customer purchase? How much did this customer pay for each item? Customers can choose among one of three payment options: (1) 5% discount if immediate cash payment, (2) 2% discount off list amount if total invoice paid by the 15th day of the month following purchase, or (3) deferred payment plan, using 6 monthly payments. Which option does J. P. Carpenter appear to be using for invoice V-2? - Using just the information provided, what are the quarterly sales amounts for salespeople 8-10, S-11, and S-12? Assume that customers C-1 through C-5 began this quarter with net accounts receivable balances of zero. What are their balances now? D