Required information The following information applles to the questions displayed below] Background: Bater Bethy BHints Inc. (BBB) is a small business located in Santa Monica, California. It sells swimwear and related products to specialy stores throughout the United States, It also sells its products to individuals over a company website. Paige Baer founded BBB almost 10 years ago after she graduated from the Feshion Institute of Design and Merchandising. She recognized the need for swimsults sold as separates. Her business has grown rapidly, and now 888 has a large following of customers who want to be able to mix and match to find their ideal swimsuit. Currently, B88 products are carried in more than 1,000 specialty swimwear boutiques and online retallers. During an inltal interview with Paige Baen, the cutined Baa's business processes. She acknowledged that she doesn't know much about accounting and information technology. As the business grew, her occounting suffered and information systems were added piecemeal. So, she is looking forward to an assessment of her requirements and recommendations thet would position gag for substantial further arowth. First, Page described 8 B sales to independent boutique retalers, Be uses a group of independent sales representatives to sell its products to boutique tetaliers around the country. These sales representatives are not 8B8 employees. They are paid commissions based on the dollar volume of sales. After working with the sales representatives: individual retailers call BBB to olace their order for the upcoming season. BB8 will then ship the products when they become avallable. The retaliers are expected to pay for shipments within 30 days. BBB offers a prompt payment discount for payment within 10 days. The following material summarizes 88B s activities to prepare for and conduct the sales process: - Summer AQ PQ fir alizes designs for next year's products and prepares catalog materials with information on its future products. - Fall to Spring - BBB sales representatives (independent agents working on commissions) visit retailers to develop sales. feab: payment of commissions to sales representatives is outside the scope of this case, although you should include the Sales Reps in your model and database) - BBB's retaller customers place-orders for one of two delveries in season: (1) early spring (Apri) and (2) early summer (May/June), 888 records information on its retallers before they place any orders. - Upon receipt of finished goods from their manufacturer in April and May, B88 ships products to reta iers. - Retallers' porments are due 30 days after shinment and include shipoing costs. Some retailers pav I ite Some take advantoge of the prompt payment discounts. B8B Finished Goods Inventory B8B tracks its inventory by catalog number (catalogy). Each product is identified by color code, use (eg, tops or bottoms). and tipe (e., the eneeifie desion of the plece). The color codes reflect the color and fabric design options, and they can change each year, At the beginning of the season, the quantity on hand of each item is zero. The quantity on hand increases when 888 gets dellverles from its manufacturer (outside the scope of this case) and decreases as it ships the products to the retailers to fill orders. ARA Shioments BBB makes one shipment for each retaller order and records revenue when the products are shipped. Warehouse employees prepare the shipments, Al shipments are made under BB's contract with a shipping company 8 a 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 thie cose Evercise Requirements 1. Basted on the preceding information and the following attributes list, prepare a UML class model and corresponding table listing describing B8B's sales to retallers. List the tables in the following order; nesources, events; agents, type images, and linking tables. Identify the primary keys and foreign keys in each table. Click hereto access the Attribute Listing for 888 to be used for this exercise. 2. Based on the preceding information, prepare a BPMN activity model that describes B9:'s Sales to Retalers process. The model should begin with retallers placing orders and end when 8B8 coliects payments for the sales to the retallers. database, and import each worksheet in the spreadsheet into the database. Set appropriate primary keys. 4. After importing all the data, create relationships among tables to implement your data modet. a. What was 8 B's total revenue? b. What is BBB's account receivabie balance for each retailer customer as of the and of Junter c. Which Be product generated the largest sales volume? (List all products in descending order of sales dollars). Connect Requirements Complete the Chapter 5 . Comprohensive Exercise uning the instructions and resources listed above For your Connect atignment Eectiones and 2 should be attempted ofter you hove completed Exurcise Requirement 2 listed above Section 3 should be attumpted after you have completed Exercise Requirement 3 1. In the above diagram, the correct name of the class designated with the letter A is which of the following? None of these 4. Retailer Customers - Fabric Colors - Finished Inventory - Iriventory Types 2. In the above diagram, the correct name of the class designated with the letter B is which of the following? Retailer Customers Inventory Types None of these Fabric Colors Finished Inventory 3.In the above diagram, the correct name of the class designated with the letter C is which of the following? None of these netantir customers Cash Receipts Inventory cash 4. In the above diagram, the correct name of the class designated with the letter D is which of the following? - Inventory - Cash Recelpts - Retailer Customers - Cash None of these 5. In the above diagram, the correct name of the class designated with the letter E is which of the following? - None of these - Cash - Employees Cash Rocelpts Retaiter Customers 6. In the above digram, the correct name of the class designated with the letter F is which of the following? - Cash Receipts None of these Retailer Customers Cash Employees 7. In the above diagram, the correct multiplicities designated with the number 1 is which of the following? if 1.1 1 0.1 8. In the above diagram, the correct multiplicities designated with the number 2 is which of the following? 0.1 11 * 0.7 9. In the above diagram, the correct multiplicities designated with the number 3 is which of the following? 0.1 11 +1 . 10. In the above diagram, the correct multiplicities designated with the number 4 is which of the following? =0.1 +11 - O." a 1 . 11 In the above diagram, the correct multiplicities designated with the number 5 is which of the following? 0.1 - 1.1 12. In the above diagram, the correct multiplicities designated with the number 6 is which of the following? - 01 1.1. 10. 4. 1 * 13. In the above diagram, the correct multiplicities designated with the number 7 is which of the following? 0.1 1.1 o. 1.* 14. In the above diagram, the correct muitiplicities designated with the number 8 is which of the following? 0.1 1.1. o.* 4. 15. In the above diagram, the correct multiplicities designated with the number 9 is which of the following? - 6