BBB shipments BBB makes one shipment for each retailer order and records revenue when the products are shipped. Warehouse employees prepare the shipments. All shipments are made under BBB's contract with a shipping company. BBB charges customers for the cost of the shipment, so the amount due from the retailers depends on the wholesale price of each item, the quantity shipped, and the shipping cost for the shipment. Payments to the shipping company are outside the scope of this case. BBB cash receipts Retailer Customers send payment by check according to the payment terms (BBB standard payment terms are 2% 10 days net 30). The payment from the retailer customer always applies to only one order, but sometimes the retailers send multiple checks for that order. A BBB Employee (accounts receivable) logs cash receipts from retailers. At the end of the day, the cash receipts are deposited intact into one bank account (BBB's main account). Each cash receipt is tracked by unique sequential cash receipt #. Required: 1. Based on the information provided above and the attribute listing, prepare a UML class model and corresponding table listing describing BBB's sales to retailers. List the tables in following order: resources, events, agents, type images, and linking tables. Identify the primary keys and foreign keys in each table, 2. Import the supplied Excel file into R 3. Prepare queries to answer the following questions: a. What was BBB's total revenue, total shipping, and total receipts? b. Which BBB products generated the largest sales volume (top 5)? (Make the code list the top 5 products in descending order of sales dollars)