Reference no: EM132373779

Assignment Question -

1. Suppose the Smith customer record as shown below as of 6/6/14. Assume customer Smith was sent a promotion for a new gardening book on 6/7/14. In addition, assume customer Smith was sent a promotion for a new cookbook on 8/7/14, Smith ordered the cookbook and the order was received at ACME Direct on 8/15/14, and partial payment of $10.00 towards the cookbook was received at ACME Direct on 9/5/14.

2. Also Jones was promoted for a cookbook. Jones did buy the cookbook and paid $23 on 8/7/14.

Assuming no other promotions were sent, orders received or payments received on Smith's and Jones's account between 6/7/14 and 9/10/14, how would the data elements shown below change as of 9/10/14?

Customer	Address	Last Order Date	Last Promotion Date	Total $ Credited	# of Paid Purchases	# of Promotions	# of Paid Cookbook Purchases
Jones	Main St.	5/5/14	5/25/14	$334.56	10	62	4
Smith	Oak St.	2/12/13	1/25/14	$74.98	3	25	0

Customer database file dump for two customer records, Jones and smith, as of 6/6/14 for selected data fields 2.b.

2. B ---try this - make up your own question - starting with 9/11/14, for the next 3 months assume 4 things happened to Jones, 1-a promotion, an order, partial payment for a non-cookbook, full payment for a cookbook order.

Then give the answer to your questions showing the new database status as of 12/11/14.