Question
For each of the following scenarios, a different payment agreement is described. Using what you know about multiplicities, determine them in each relationship (the minimum
For each of the following scenarios, a different payment agreement is described. Using what you know about multiplicities, determine them in each relationship (the minimum next to Sales Order can be skipped, however – it is dependent on whether or not processes other than sales are recorded in the database).
Scenario 1:
Company A sells bookcases designed to specification. Company A allows its customers to pay in monthly installments, as occasionally the bookcases can be quite expensive. Company A generally requires its customers to pay an initial $50 upon agreement of sale, but will allow its customers who have been particularly loyal to skip the initial payment. Company A also allows their loyal customers to pay for multiple bookcase orders in the same payment, although this is certainly not required.
Scenario 2:
Company B is a travel agency. Company B requires payment upon the first consultation, and then accepts one more payment when the travel agent books the travel for the customer (usually 2-3 weeks later). Each customer payment is for only one sale.
Scenario 3:
Company C sells used (but not rare) books. Customers always pay up-front, and for one sale at a time. Installments are not accepted.
Scenario 4:
Company D sells electronics. While a down payment is allowed, it is not required. Customers can pay in a maximum of 4 weekly installments. Customers do not pay for more than one sale at a time.
Sales Order Payment
Step by Step Solution
3.51 Rating (168 Votes )
There are 3 Steps involved in it
Step: 1
Scenario 1 Multiplicity for each relationship in Scenario 1 Sales Order to Payment 1 to 0 Sales Orde...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started