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.
|
Explain the inter-workings of fiscal policy tools
: Is a recessionary or inflationary gap bad for an economy? Have you ever wondered how the federal government and the Federal Reserve react to smooth out.
|
|
How an outbreak of hostilities impact the australian markets
: Explain, with the aid of diagrams, how an outbreak of hostilities in the Middle East might be expected to impact the Australian markets for petrol and passenger
|
|
Is either Wexis or Anne liable to pay these accounts
: BSL165 Foundations of Business Law Assignment, Murdoch University, Australia. Is either Wexis or Anne liable to pay these accounts
|
|
Determine a set of allocations of tasks to processors
: SIT323 - Practical Software Development - Cloud Application Development - Deakin University - determine a set of allocations of tasks to processors
|
|
How would the data elements change
: Assuming no other promotions were sent, orders received or payments received on Smith's and Jones's account, how would the data elements change
|
|
Finding a case where an illegal search was claimed
: Using the Web or other resources, find a case where an illegal search was claimed. Write a brief essay describing that case and how it relates to this week's.
|
|
Explain human behavior and mental processes
: There are several perspectives that can be used to explain human behavior and mental processes.
|
|
Why do you want to get a doctoral degree in cyber security
: Provide a brief essay (1-2 pages single spaced, 11 pt. Times New Roman, typed or computer-processed) of your interests, professional plans and career objectives
|
|
Why centralized iam systems are necessary
: Discuss in 500 words or more why, in this age of distributed computing, centralized IAM systems are necessary. Cite your sources. Do not copy. Write in essay.
|