Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the model in Figure 6 - 2 4 which describes purchases of a product by customers of a small mail order company selling toys.

Consider the model in Figure 6-24 which describes purchases of a product by customers of a small mail
order company selling toys. For simplicity, each purchase is for one or more of a single toy. Each transaction
must have a customer so that he or she can be invoiced and the product delivered. The data will be used
to prepare statistics about the different products sold, values of purchases, and the spending habits of
customers.
Figure 6-24. Customers purchase products.
The company changes the way it does business to allow customers to walk in off the street and pay cash.
No customer needs to be associated with a cash purchase. Discuss how effective the following changes to
the data would be.
Change the optionality at the customer end of the relationship to 0 so not all
purchases need a customer.
Leave the optionality as 1 but include a dummy customer object, with name
CashCustomer.
Create subclasses of Customer: Cash_Customer and Account_Customer.
Create subclasses of Purchase: Cash_Purchase and Account_Purchase.PlPP
image text in transcribed

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 Driven Web Sites

Authors: Mike Morrison, Joline Morrison

1st Edition

061901556X, 978-0619015565

More Books

Students also viewed these Databases questions