Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

JJ Flyers makes and sells fly fishing rods, custom - designed and manufactured specifically for each customer. Many customers are repeat purchasers. The rods are

JJ Flyers makes and sells fly fishing rods, custom-designed and manufactured specifically for each customer. Many customers are repeat purchasers.
The rods are expensive, each one is unique, and a down payment is required when an order is placed. The balance of the payment must be made in full when the customer takes delivery.
JJ has a number of commissioned sales representatives. When a sales rep receives an order, a customer record is created. It is used for repeat orders and to track repairs. The rep processes the customer payment (check or credit card) and deposits the receipt in the companys bank account, updating the customer record to reflect receipt.
Prepare a UML Class diagram using the REA framework (Chapter 5, Appendix A) to model the sales process. Use the following tables:
Resources: Rod inventory, Customer Record
Events: Sale, Payment Receipt
Agents: Sales Representative, Customer
For each table, suggest appropriate attributes, and indicate Primary and Foreign Keys.
Multiplicities:
A: JJ will only sell one rod to a customer at a time.
B: Each rod is unique and can only be sold once.
C: A sales rep may not have any sales transactions (yet) but the good ones have many sales transactions.
D: Only one sales rep deals with each customer.
E: JJ has repeat customers. Customer records are set up for the first purchase.
F: each sale involves only one customer.
G: Each payment receipt updates only one customer record.
H: Each customer record must indicate at least one (down payment) receipt or could show many receipts.
I: Each customer must pay a deposit and pay in full for the prior order before they can place another order which must also be accompanied by a deposit.
J: Each sales rep only processes receipts from their own customers. They may have processed zero receipts (no sales yet) or many.
K: Each receipt is processed by only one sales rep.
L: Each payment receipt is for one and only one sales transaction.
M: Each sale must have at least one receipt (the deposit) and at most two receipts for each sale.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Modeling And Design

Authors: Toby J. Teorey, Sam S. Lightstone, Tom Nadeau, H.V. Jagadish

5th Edition

0123820200, 978-0123820204

Students also viewed these Databases questions

Question

What is the purpose of the Salary Structure Table?

Answered: 1 week ago

Question

What is the scope and use of a Job Family Table?

Answered: 1 week ago