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'

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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

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 full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Operating System 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...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

I need to write a 2 page paper on the attached FASB Exposure draft for revenue from customer contracts. The instructions are: Develop a logical, well-articulated response to the exposure draft (for...

DON'T SUMMARIZE JUST PARAGRAPH OF WHAT YOU THOUGHT/LEARNED CHAPTER 13 - The phrase "garbage in, garbage out" highlights the importance of input controls. If the data entered into a system are...

Hi Sara Hope you are doing well. I need to prepare Ratio Analysis for eBay company and Amazon. I uploaded the most recent 10-K report for the most recent years, 2014 to 2016. Please let me know if...

Suppose that the current exchange rate between the dollar and the euro is $1.42 = 1 (i.e., e0-$1.42) and the price per gallon of gas in the Euro zone is 1. Assume that the inflation rate is expected...

plz answer all questions I will rate fore sure. ty Question 2. (18 points) Escherichia coli is a mesophilic facultative anaerobic bacterium that is normally found in the human gut. E. coli can also...

Phosphorus pentachloride, PCl5, decomposes when heated. If the initial concentration of PCl5 is 1.00 mol/L, what is the equilibrium composition of the gaseous mixture at 160oC? The equilibrium...

Directions Record Financial Data: Use generally accepted accounting princlples to accurately capture buniness transactions for the mondh in the Comoany Accounting Workbook Trmplate, which is linked...

A firm operated at 80% of capacity for the past year, during which fixed costs were $210,000, variable costs were 65% of sales, and sales were $1,000,000. Operating profit was:

The following section is taken from Ohlman Corp.'s balance sheet at December 31, 2018. Current liabilities Interest payable....................................$ 112,000 Long-term liabilities Bonds...

Calculate the net present value (NPV) for the following 20-year projects. Comment on the acceptability of each. Assume that the firm has an opportunity cost of 14%. a. Initial investment is $10,000;...

Selected transactions of the Shadrach Computer Corporation during November and December of 2007 are as follows: Nov. 1 Borrowed money from the bank by issuing a non-interest-bearing, $40,000, 90-day...

The duller Edge Inc. assembles and sells MP3 players. The company began operations on May 1, 2012, and operated at 100 % of capacity during the first month. The following data summarize the results...

Only prepare the journal entries. Please specify the fund for each transaction.

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?

Socially responsible investing first became fashionable in the 1980s. Such investing involves consideration of the kinds of businesses that a firm engages in and selection of investments that are as...

Many decisions are simple, preprogrammed, or already made. For example, retailers do not have to think long to decide how to deal with anew customer. Some operations research models provide...

Bay of Plenty' Electricity (BOPE) is an electrical utility company in the Bay of Plenty, New Zealand. BOPE has 21 company cars that the head-office employees share for company business. However, BOPE...