View the step-by-step solution to:

The Beach Dude (BD) employs a legion of current and former surfers as salespeople who push its surfing-oriented products to various customers...

1. 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 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.).
a. Draw a UML class diagram that describes the Beach Dudes sales and collection process.
b. Using Microsoft Access, implement a relational database from your UML class diagram.
Identify at least three fields per table.
c. Describe how you would use the relational database to determine the Beach Dude’s
accounts receivable.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question