Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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. 

Sales Order Payment

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.

Sales Order Payment

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.

Sales Order Payment

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

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... 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

Fundamentals of Investments Valuation and Management

Authors: Bradford D. Jordan, Thomas W. Miller

5th edition

978-007728329, 9780073382357, 0077283295, 73382353, 978-0077283292

More Books

Students also viewed these Accounting questions

Question

please help me . how to solve on excel

Answered: 1 week ago