80.2K

Verified Solution

Link Copied!

Comment: Before you resubmit, also review your UML class diagram for a couple missing associations. Review also that every association has a foreign key identified (revisit your multiplicity assignment between the sales rep & retailer customer). You are almost there!

Hello, I couldn't figure out what I did or didn't do. I'm just so confused. If anyone could help, that would be very appreciated! Need help with Q1. Thank you!

ca. California. United States. It aer founded BBB ear and related eviduals over of Design and Merchan the Fashion Inces. Her business has grown ant to be able to mix and more than 1,000 COMPREHENSIVE EXERCISE: BAER BELLY BIKINIS' SALES TO RETAILERS Baer Belly Bikinis Inc. (BBB) is a small business located in Santa Monica sells swimwear and related products to specialty stores throughout the United also sells its products to individuals over a company website. Paige Baer fou almost 10 years ago after she graduated from the Fashion Institute of Design a dising. She recognized the need for swimsuits sold as separates. Her business has rapidly, and now BBB has a large following of customers who want to be able to match to find their ideal swimsuit. Currently, BBB products are carried in more than specialty swimwear boutiques and online retailers. During an initial interview with Paige Baer, she outlined BBB's business p She acknowledged that she doesn't know much about accounting and information tech ogy. As the business grew, her accounting suffered and information systems were adde piecemeal. So, she is looking forward to an assessment of her requirements and recom mendations that would position BBB for substantial further growth. This case examines BBB sales to independent boutique retailers. BBB uses a groun of independent sales representatives to sell its products to boutique retailers around the country. These sales representatives are not BBB employees. They are paid commis- sions based on the dollar volume of sales. After working with the sales representatives, B's business processes individual retailers call BBB to place their order for the upcoming season. BBB will then ship the products when they become available. The retailers are expected to pay for shipments within 30 days. BBB offers a prompt payment discount for payment within 10 days. The following material summarizes BBB's activities to prepare for and conduct the sales process: Summer BBB finalizes designs for next year's products and prepares catalog materials wie information on its future products. Fall to Spring BBB sales representatives (independent agents working on commissions) VISA retailers to develop sales. BBB's payment of commissions to sales representa is outside the scope of this case, although you should include the Sales Reps model and database. ons to sales representawtives Sales Reps in your umer (May/June). BBB records information on its ir manufacturer in April and May, BBB ships 1513's retailer customers place orders for one of two del spring (April) and (2) early summer (May/June). BBB recon les place orders for one of two deliveries in season: (1) early retailers before they place any orders. Upon receipt of finished goods from their manufacturer in April and products to retailers. Retailers' payments are due 30 days after shipment and incl due 30 days after shipment and include shipping costs. Some retailers pay late. Some take advantage of the prompt payment BBB Finished Goods Inventory BBB tracks its inventory by catalog number (catalog). Each prod y by catalog number (catalog). Each product is identified by color code, use (e.g., tops or bottoms), and type (c.g., the specific design of the picce codes reflect the color and fabric design options, and they can change cachy beginning of the season, the quantity on hand of each item is zero. The quantity on hand increases when BBB gets deliveries from its manufacturer (outside the scope one and decreases as it ships the products to the retailers to fill orders. BBB Shipments ype (c.8- the specific design of the piece). The color OD makes one shipment for each retailer onder and records revenue when the products are shipped. Warehouse employees prepare the shipments. All shipments are made unde BBB's contract with a shipping company. BBB charges customers for the cost of the ship ment, 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 number, Exercise Requirements 1. Based on the preceding information and the following attributes list, 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. (optionall Based on the preceding information, prepare a BPMN activity model that describes BBB's Sales to Retailers process. The model should begin with retailers placing orders and end when BBB collects payments for the sales to the retailers. 3. Your instructor will provide an Excel spreadsheet with the BBB information. Create a new Access 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 model. 5. Prepare queries to answer the following questions a. What was BBB's total revenue? What is BBB's account receivable balance for each retailer customer as of the end of June? Which BBB product generated the largest sales volume? (List all products in descending order of sales dollars). Resources Events Agents 1..1 PK FK Fabric Colors Color Code Color Name Fabric Cost per yard 1. 1 PK FK Retailer Orders/Sales Order_# Employee_# Catalog Number Quantity Ordered Cash Receipt# | Employee PK Employee_# First Name Last Name Address Phone Finished Iny PK | Catalog Number Type Code Use Description Size Color Code 1..1 | 1.* Inventory Types PK Type Code Use Description Yards Fabric Required PK 1..1 1..1 Retailer Customer Customer # Name Address Sales Rep # Phone 1..1 FK PK FK Retailer C/R Cash Receipt # Customer # Receipt Date Receipt Amount Account # Cash Account # Bank Account Description Balance PK 0.* FK Sales Rep Sale Rep. # PK Email Address Phone Area ca. California. United States. It aer founded BBB ear and related eviduals over of Design and Merchan the Fashion Inces. Her business has grown ant to be able to mix and more than 1,000 COMPREHENSIVE EXERCISE: BAER BELLY BIKINIS' SALES TO RETAILERS Baer Belly Bikinis Inc. (BBB) is a small business located in Santa Monica sells swimwear and related products to specialty stores throughout the United also sells its products to individuals over a company website. Paige Baer fou almost 10 years ago after she graduated from the Fashion Institute of Design a dising. She recognized the need for swimsuits sold as separates. Her business has rapidly, and now BBB has a large following of customers who want to be able to match to find their ideal swimsuit. Currently, BBB products are carried in more than specialty swimwear boutiques and online retailers. During an initial interview with Paige Baer, she outlined BBB's business p She acknowledged that she doesn't know much about accounting and information tech ogy. As the business grew, her accounting suffered and information systems were adde piecemeal. So, she is looking forward to an assessment of her requirements and recom mendations that would position BBB for substantial further growth. This case examines BBB sales to independent boutique retailers. BBB uses a groun of independent sales representatives to sell its products to boutique retailers around the country. These sales representatives are not BBB employees. They are paid commis- sions based on the dollar volume of sales. After working with the sales representatives, B's business processes individual retailers call BBB to place their order for the upcoming season. BBB will then ship the products when they become available. The retailers are expected to pay for shipments within 30 days. BBB offers a prompt payment discount for payment within 10 days. The following material summarizes BBB's activities to prepare for and conduct the sales process: Summer BBB finalizes designs for next year's products and prepares catalog materials wie information on its future products. Fall to Spring BBB sales representatives (independent agents working on commissions) VISA retailers to develop sales. BBB's payment of commissions to sales representa is outside the scope of this case, although you should include the Sales Reps model and database. ons to sales representawtives Sales Reps in your umer (May/June). BBB records information on its ir manufacturer in April and May, BBB ships 1513's retailer customers place orders for one of two del spring (April) and (2) early summer (May/June). BBB recon les place orders for one of two deliveries in season: (1) early retailers before they place any orders. Upon receipt of finished goods from their manufacturer in April and products to retailers. Retailers' payments are due 30 days after shipment and incl due 30 days after shipment and include shipping costs. Some retailers pay late. Some take advantage of the prompt payment BBB Finished Goods Inventory BBB tracks its inventory by catalog number (catalog). Each prod y by catalog number (catalog). Each product is identified by color code, use (e.g., tops or bottoms), and type (c.g., the specific design of the picce codes reflect the color and fabric design options, and they can change cachy beginning of the season, the quantity on hand of each item is zero. The quantity on hand increases when BBB gets deliveries from its manufacturer (outside the scope one and decreases as it ships the products to the retailers to fill orders. BBB Shipments ype (c.8- the specific design of the piece). The color OD makes one shipment for each retailer onder and records revenue when the products are shipped. Warehouse employees prepare the shipments. All shipments are made unde BBB's contract with a shipping company. BBB charges customers for the cost of the ship ment, 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 number, Exercise Requirements 1. Based on the preceding information and the following attributes list, 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. (optionall Based on the preceding information, prepare a BPMN activity model that describes BBB's Sales to Retailers process. The model should begin with retailers placing orders and end when BBB collects payments for the sales to the retailers. 3. Your instructor will provide an Excel spreadsheet with the BBB information. Create a new Access 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 model. 5. Prepare queries to answer the following questions a. What was BBB's total revenue? What is BBB's account receivable balance for each retailer customer as of the end of June? Which BBB product generated the largest sales volume? (List all products in descending order of sales dollars). Resources Events Agents 1..1 PK FK Fabric Colors Color Code Color Name Fabric Cost per yard 1. 1 PK FK Retailer Orders/Sales Order_# Employee_# Catalog Number Quantity Ordered Cash Receipt# | Employee PK Employee_# First Name Last Name Address Phone Finished Iny PK | Catalog Number Type Code Use Description Size Color Code 1..1 | 1.* Inventory Types PK Type Code Use Description Yards Fabric Required PK 1..1 1..1 Retailer Customer Customer # Name Address Sales Rep # Phone 1..1 FK PK FK Retailer C/R Cash Receipt # Customer # Receipt Date Receipt Amount Account # Cash Account # Bank Account Description Balance PK 0.* FK Sales Rep Sale Rep. # PK Email Address Phone Area

Answer & Explanation Solved by verified expert

See Answer