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.Also Jones was promoted for a cookbook. Jones did buy the cookbook and paid $23 on 8/7/14.

2.(a) 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 database file dump for two customer records, Jones and smith, as of 6/6/14 for selected data fields

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