This question relates to transactions and concurrency. You may find it helpful to use transaction histories...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
This question relates to transactions and concurrency. You may find it helpful to use transaction histories to explain your answers. Customers of Kim's Coffee are automatically enrolled in a loyalty scheme. Customers receive a bonus point each time they make a purchase. These are stored in Kim's database and a query is provided so that customers can see the number of points they have (their balance) at any time. To increase business and attract new customers, Kim's Coffee has two special promotions. During "Add 5" weeks, customers receive 5 bonus points instead of 1 when they make a purchase. In "Double Dip" weeks the balance of customers who make a purchase is doubled. Kim's Coffee has a transaction for each of these. • 15 reads a customer's balance, adds 5 to it, writes it back to the database and commits. • T2 reads a customer's balance, doubles it, writes it back to the database and commits. This week Kim's Coffee is offering both promotions. A customer, Lee, calls to complain. He says "I have only made one purchase this week. My points balance was 4 and now it is 13 –I think it should be more." Another customer, Alex, also complains saying "I have only made one purchase this week. My points balance was 4 and now it is 8–I didn't get my extra 5 points." Kim checks the logs and is horrified to discover that customers who had 4 points at the beginning of the week, and made only one purchase, now have different balances – 13, 9, 8 or 18. 1. What is going on here? Clearly and concisely explain why customers whose initial balances were the same now have different balances. 2. Are any of the 4 values "incorrect"? Briefly explain. 3. What, if anything, could be done to prevent this situation from occurring? If you wish, you may attach PDF documents and/or image files as part of your answer to this question. Please ensure that your name or userid appears on any files you attach. This question relates to transactions and concurrency. You may find it helpful to use transaction histories to explain your answers. Customers of Kim's Coffee are automatically enrolled in a loyalty scheme. Customers receive a bonus point each time they make a purchase. These are stored in Kim's database and a query is provided so that customers can see the number of points they have (their balance) at any time. To increase business and attract new customers, Kim's Coffee has two special promotions. During "Add 5" weeks, customers receive 5 bonus points instead of 1 when they make a purchase. In "Double Dip" weeks the balance of customers who make a purchase is doubled. Kim's Coffee has a transaction for each of these. • 15 reads a customer's balance, adds 5 to it, writes it back to the database and commits. • T2 reads a customer's balance, doubles it, writes it back to the database and commits. This week Kim's Coffee is offering both promotions. A customer, Lee, calls to complain. He says "I have only made one purchase this week. My points balance was 4 and now it is 13 –I think it should be more." Another customer, Alex, also complains saying "I have only made one purchase this week. My points balance was 4 and now it is 8–I didn't get my extra 5 points." Kim checks the logs and is horrified to discover that customers who had 4 points at the beginning of the week, and made only one purchase, now have different balances – 13, 9, 8 or 18. 1. What is going on here? Clearly and concisely explain why customers whose initial balances were the same now have different balances. 2. Are any of the 4 values "incorrect"? Briefly explain. 3. What, if anything, could be done to prevent this situation from occurring? If you wish, you may attach PDF documents and/or image files as part of your answer to this question. Please ensure that your name or userid appears on any files you attach.
Expert Answer:
Answer rating: 100% (QA)
Answer All the four customers whose initial points balances were 4 and have made a single p... View the full answer
Related Book For
Microeconomics
ISBN: 978-0321866349
14th canadian Edition
Authors: Christopher T.S. Ragan ,Richard G Lipsey
Posted Date:
Students also viewed these accounting questions
-
This question relates to the section Linkages Between Markets found on the www.myEconLab (www.myeconlab. com). In 1994, the Quebec and Ontario governments significantly reduced their excise taxes on...
-
For the exercises in this lesson, you may find it helpful to use a window on your calculator that has friendly x-values. A background grid may also be helpful. 1. Identify each quadratic function as...
-
This question relates to the material in the Appendix. The following table shows several methods of producing 500 rubber tires per day. There are two factors, labour and capital, with prices per unit...
-
Cooper Movie Studio Corp. makes movies and is interested in lowering its operating costs for the following year, while maintaining the high quality and appeal of its movies. Cooper's management is...
-
Although both internal and external fit are important concerns with high-performance work systems, which do you consider more critical and why?
-
With the increasing number of organizations experiencing downsizings and layoffs, it has become critical that they have career programs in place to assist out placed employees. What suggestions would...
-
Create a scatter plot (Learning Objective 3)} Alice Jungemann, owner of Flower Power, operates a local chain of floral shops. Each shop has its own delivery van. Instead of charging a flat delivery...
-
Determine the operating cash flow (OCF) for Kleczka, Inc., based on the following data. (All values are in thousands of dollars.) During the year the firm had sales of $2,500, cost of goods sold...
-
Kevin purchased 24 bags of dog food for a total of $384. Each bag of dog food cost the same amount. At this price, what would the total cost in dollars of 6 bags of dog food
-
Background: In the initial contract negotiation stage, the contract price with SM was $10.1 million in cash. However, as part of the final contract negotiations, SM agreed to give EYE SPY its old...
-
Alibaba, Inc. versus Amazon, Inc. to choose the better for your stock investment using 1. Your investment model and 2. Three most recent years' relevant information, including accounting information...
-
Governor Andrew Cuomo of New York State issued regulations that would require the top wage earners of human service and health care agencies to apply for a waiver to justify their compensation if...
-
What is the difference between overall planned audit risk and the individual audit risks?
-
The Institute for Women s Policy Research (2012) found that the ratio of women s to mens median weekly full-time earnings rose by 1 percentage point since 2010 and reached a high of 82.2 percent....
-
The 2011 Deloitte Volunteers Impact Survey found that 56 percent of millennials (ages twenty-one to thirty-five) who participate in a companys sponsored volunteer activities are more likely to rate...
-
Identify several major internal audit activities.
-
project ?consists ?of ?eleven ?activities ? ( all ?times ?are ?given ?in ?days ) ?and ?has ?worker ?requirements ?as ?indicated ?in ?the ?table. Assume ?that
-
What is the difference between the straight-line method of depreciation and the written down value method? Which method is more appropriate for reporting earnings?
-
The following table shows the demand schedule for PlayStation video games. a. Compute total expenditure for each row in the table. b. Plot the demand curve and the total expenditure curve. c. Compute...
-
Industrial Footwear Inc. uses capital and labour to produce workboots. Suppose this firm is using capital and labour such that the MPK is equal to 80 and the MPL is equal to 20. For each set of...
-
Consider the following straight-line supply curves. In each case, p is the price (measured in dollars per unit) and QS is the quantity supplied of the product (measured in thousands of units per...
-
Effects of Darden Restaurants Changes in Current Assets and Liabilities on Its Statement of Cash Flows The following items, listed in alphabetical order, are included in the Current Liabilities...
-
Using data from the stockholders equity section of Soong Corporations balance sheet shown below, compute the book value per share for both the preferred and the common stock. Contributed capital...
-
On August 10, the board of directors of Perlman International declared a 3-for-1 stock split of its $9 par value common stock, of which 400,000 shares were authorized and 125,000 were issued and...
Study smarter with the SolutionInn App