The following transaction runs in a highly concurrent database application (for example, sales order processing). UPDATE customer

Fantastic news! We've Found the answer you've been seeking!

Question:

The following transaction runs in a highly concurrent database application (for example, sales order processing).

UPDATE customer

SET discount = discount+0.03 WHERE customerArea = 'Glasgow'

COMMIT;

i. Assume the UPDATE fails to COMMIT and is unable to fully complete its execution. Explain the effect this might have on database integrity, assuming there were no concurrency control mechanisms.

Related Book For answer-question

Concepts of Database Management

ISBN: 978-1285427102

8th edition

Authors: Philip J. Pratt, Mary Z. Last

See More Books

Posted Date: Oct 30, 2023 12:46 AM

See More Questions

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
Controls is a publicly owned company that engages in the manufacturing and marketing of residential and commercial thermostats. The thermostats are used to regulate temperature in furnaces and...
Once an LLC has engaged in a dissolution procedure, the business does not stop immediately. True/False
A Low-Pass Filter. Figure 31.27 shows a low-pass filter (see Problem 31.49); the output voltage is taken across the capacitor in an L-R-C series circuit. Derive an expression for voutlvs, the ratio...
Following is Crash Zone Corporations balance sheet at the end of 2013 and its cash flow statement for 2014. Crash zone manufactures safety equipment for race cars. Balance Sheet as of December 31,...
When the Concepcions went to AT&T to get a phone, they were confused as to why they were paying money for the phone when it was advertised as being free. They had to pay sales tax on the full normal...
The Great North Woods Clothing Company sells specialty outdoor clothing through its catalogue. A quality problem that generates customer complaints occurs when a warehouse employee fills an order...
A point P is equidistant from R(-2, 4) and S(6, -4) and its x-coordinate is twice its y-coordinate. (i) Find the coordinates of P. (ii) Hence, determine whether P, R and S are collinear, showing your...
Pursuit Company produces two products: Bric and Brac. The following table summarizes the products details and planned unit sales for the upcoming period: Pursuit Company has total fixed costs of $10...
Suppose that the number of atoms of a particular isotope at time t (in hours) is given by the exponential decay function f(t) = e1.31t. By what factor does the number of atoms of the isotope decrease...
An annual payment loan of $100,000 is taken out for a term of 10 years at 8% interest. The agreement stipulates interest payments only during the term of the loan, with repayment of the full $100,000...
Under what conditions are short-term contracts preferable to long-term contracts?
You notice that your bank balance is lower than your checkbook balance. What could be the reason for this difference?
You develop a contract that contains specific language about transportation requirements, and the supplier agrees to it but later claims that it is not acceptable under the UCC. Who in your opinion...
Discuss any four tests you would do in the field to ensure work is completed correctly that were covered in the first three units? Include the name, how performed and why the test is important.
Case Study B: Applying Accounting Practices for Assets Mustang Company reported the following financial information for its first year of operations. Below are the financial statements for the year...
What can scientists learn by comparing the fossilized skeletons of extinct primates with the bones of modern species?
You need to delete the Order Line table from the TAL Distributors database. Will the following command work? Why or why not?
What are two disadvantages of updating replicated data in a distributed database?
How do you create a computed field in an Access query?
V. Zarb, the marketing manager for Maltese Treasures Ltd, is preparing a sales budget for the year ended 30 June 2020. In reviewing the actual sales data for the previous year, the sales and...
The following expenses budget has been prepared for Abacus Services for the year ending 30 June 2020. Professional salaries, secretarial wages and training are paid in the quarter in which they are...
Bounce Athletics Ltd, which develops and runs athletics training programs for primary schools, has budgeted revenue for the first 6 months of 2020 as follows. All revenue is provided on account and...

The following transaction runs in a highly concurrent database application (for example, sales order processing). UPDATE customer

Question:

Expert Answer:

If the UPDATE operation in a highly concurrent database application fails to COMMIT and is unable to complete its execution it can have adverse effect... View the full answer

Concepts of Database Management

Students also viewed these operating system questions