Question

The Beach Dude (BD) employs a legion of current and former surfers as salespeople who push its surfing-oriented products to various customers (usually retail outlets). This case describes BD’s sales and collection process.

Each BD salesperson works with a specific group of customers throughout the year. In fact, they often surf with their customers to try out the latest surf gear. The BD salespeople act laid-back, but they work hard for their sales. Each sale often involves hours of surfing with their customers while the customers sample all the latest surf wear. Because BD makes the best surfing products, the customers look forward to the visits from the BD salespeople. And they often buy a lot of gear. Each sale is identified by a unique invoice number and usually involves many different products. Customers pay for each sale in full within 30 days, but they can combine payments for multiple sales.

BD manages its clothing inventory by item (e.g., XL BD surfer logo T-shirts), identified by product number, but it also classifies the items by clothing line (the lines are differentiated by price points as well as the intended use of the clothing, e.g., surfing products, casual wear, etc.).

Draw a UML class diagram that describes the Beach Dude’s sales and collection process. Then, use your diagram to answer the following questions about this diagram.

А 1..1 F 1 5 8 Sales 11 12 6 2 B 3 7 0 14 13 0..* D Employees 10 4 15 С 16 E

a. Use the list of potential class names listed below. Identify the appropriate class name for each letter, A through F, in the diagram above. Enter the number of the class name next to the letter below.

Potential class names:

1. Accounts Receivable
2. Beach Dude Products
3. Cash
4. Cash Receipts
5. Clothing Lines
6. Customers
7. Customer Orders
8. Customer Returns
9. Sales
10. Not a class in this Beach Dude diagram

Enter the number of the class name next to the correct letter:

b. Use the list of potential multiplicities listed below to identify the multiplicities that should replace the numbers, 1 to 16, on the diagram.

Potential multiplicities:

1. 0..0
2. 0..1
3. 1..1
4. 0..*
5. 1..*
6. *..*
7. Not an association for the Beach Dude diagram so no multiplicity required

Enter the number of the correct multiplicity for each number on the diagram here.

Answer 1

Beach Dude

UML Class Diagram shown below:

Clothing Lines 0..1 1..1 Customers Sales 1..1 0. 0. BD Products 1. 0..1 0..1 C/R 11 Employees Cash

The minimum multiplicities between BD Products and Clothing Line are set to 0 by default, since it can be assumed that product items and clothing lines are defined before the links are defined. The minimum multiplicities between Employees and Customers are set to 0 since some employees may not work with customers, and some customers may not have an assigned salesperson, yet. The student may make alternate assumptions, but should document those assumptions.

The relational table needed to be framed to describe the UML diagram, where PK is Primary Key, can be made as follows:

One way to determine the accounts receivable balances for each customer:

1. Use the Customers and Sales tables. Sum the Invoice Total from Sales and Group By Customer #.

2. Use the Customers and Cash receipts tables. Sum the Cash receipt amount and Group By Customer #.

3. Use the two queries outlined above. Join them by Customer #. Compute the difference between the Sum of Sales Amount and the Sum of Cash receipt amount to determine each Customer’s accounts receivable.