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,
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started