Question: Draw a Class Model corresponding to the description below: A customer may place any number of orders. Each order is received on a specific date,

Draw a Class Model corresponding to the description below:

A customer may place any number of orders. Each order is received on a specific date, may be prepaid when order is received. Each order is identified by a number, and the price/value of order. Each order may include any number of items. For each item, the number / quantity ordered as well as its price is provided. A given product may comprise one or more items. Each customer is identified by name and address, and based on those values, we should be able to retrieve the CreditRating of customer. Customer may be a personal customer, who is allowed to pay by CreditCard by providing the CreditCardNumber. Customer may be a corporate customer, who will be assigned a SalesRep, an employee of company. For each corporate customer, their contact details are saved in company database along with their CreditRating and CreditLimit allowed.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!