While users were updating the Premiere Products database, one of the transactions was interrupted. You need to
Question:
While users were updating the Premiere Products database, one of the transactions was interrupted. You need to explain to management what steps the DBMS will take to correct the database. Using the sample log in Figure 7-11, list and describe the updates that the DBMS will roll back if transaction 2 is interrupted at 8:10.
Figure 7-11
Transcribed Image Text:
Transaction ID Time Action Record Updated Bafore image After image 8:00 Start 8.01 Start 8:02 Insert Orders (21700) 8:03 Start 8:04 Update Part (DW11) 8:05 Insert Orderline (21700, DW11) 8:06 Commit 8:07 Start 8.08 Insert Customer (510) 8:09 Insert Orderline (21700, KIL62) 8:10 Commit 8:11 Update Part (DW11) 8:12 Update Part (KL62) 8:13 Delete Part (AT94) 8:14 Update Customer (282) 8:15 Commit 8:16 Update Rep (35) 8:17 Commit (new values) values) new values) (new values) (new values) (new values) (new values) (old values) (old values) (old values) (old values) (new values) (old values) (new values)
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 88% (9 reviews)
In transaction 2 the DBMS started it at 801 ad...View the full answer
Answered By
Benard Ndini Mwendwa
I am a graduate from Kenya. I managed to score one of the highest levels in my BS. I have experience in academic writing since I have been working as a freelancer in most of my time. I am willing to help other students attain better grades in their academic portfolio. Thank you.
4.90+
107+ Reviews
240+ Question Solved
Related Book For
Concepts of Database Management
ISBN: 978-111182591
7th edition
Authors: Philip J. Pratt, Joseph J. Adamski
Question Posted:
Students also viewed these Computer Sciences questions
-
Using data from the Premiere Products database, define a view named TopLevelCust. It consists of the number, name, address, balance, and credit limit of all customers with credit limits that are...
-
Create the TopLevelCust view described in Review Question 2. Display the data in the view. Review Question 2 Using data from the Premiere Products database, define a view named TopLevelCust. It...
-
1. Indicate the changes you need to make to the design of the Premiere Products database to support the following situation. A customer is not necessarily represented by a single sales rep but can be...
-
Suppose the given numbers for a mental calculation (see Problem 59) are 10x + y and 10x + z. Notice that these two numbers have the same tens digit. Also assume that y + z = 10, which says that the...
-
The birth weights (in grams) are given for babies born to 22 mothers who smoked during their pregnancy and to 35 mothers who did not smoke. Seven pounds is about 3200 grams. (Source: Smoking Mothers,...
-
A 50 HP motor is to operated 4500 h/year at 80% load. A premium-efficiency motor has an energy efficiency of 93.4 %, compared to 91.2 % for the standard-efficiency motor. Calculate the annual energy...
-
Describe the four steps in the closing process. LO15
-
The financial statements for Nike, Inc., are presented in Appendix B at the end of the text. The following additional information (in thousands) is available: Accounts receivable at May 31, 2008........
-
The function f(x,y) = 8x2 + y2 has an absolute maximum value and absolute minimum value subject to the constraint x2 + 7y + y2 = 44. Use Lagrange multipliers to nd these values
-
New video games are rated, by editors, at various Web sites (e.g., www.gamespot.com). You are equally interested in five games that received editors' ratings of on a ten point scale. Suppose you...
-
What is deadlock? How does it occur?
-
Occasionally, users at Premiere Products obtain incorrect results when they run queries that include built-in (aggregate, summary, or statistical) functions. The DBA told management that unrepeatable...
-
Cite one similarity and two differences between precipitation hardening and dispersion strengthening.
-
What is the stance of Reid et al. (2012) regarding the imposition of negative sanctions for staff performance ? Explain
-
Discuss the following for your product or service: Marketing Mix Product strategy - in addition to career clothing, what other products should the Consignment Store carry and what is your strategy...
-
1. Allocate the 400 points according to time invested, and then allocate the points according to pages produced. Decide how you would allocate the points to group members if you were Ron, using...
-
Assume Zo's utility function is U(C, L) = CL where C is consumption measured by her total income and L is leisure. Total income is labour income and non-labour income. She has y = $400 non-labour...
-
The average and standard deviation for ACT scores are 20 and 3 respectively. The average and standard deviation for SAT scores are 1050 and 150 respectively. Student A that scored a 28 on their ACT...
-
A company plans to borrow 500,000 in three months time for a period of three months but expects the future interest rate to be higher than the current interest rate of 10 per cent. To hedge its...
-
The column shown in the figure is fixed at the base and free at the upper end. A compressive load P acts at the top of the column with an eccentricity e from the axis of the column. Beginning with...
-
A few years ago, Hotel Klingerhoffer, a large hotel chain, announced that because occupancy rates had declined during the previous quarter, it was raising room rates to cover the cost of its increase...
-
What sorts of big data might be important for Sports Physical Therapy? Research physical therapy clinics online to find out more information about what they might find vital to be competitive.
-
What are typical qualifications for a data scientist?
-
Pitt Fitness realizes that the company needs to be on top of all trends in fitness centers to keep up with the competition. To ensure they stay on the cutting edge, the company would like to employ a...
-
The Nike Corporation produces athletic shoes. Last month, it produced 8,000 pairs of shoes at a total cost of $50,000. When production increased to 10,000 pairs, the total cost rose to $60,000. i)...
-
Question 7 of 2 0 - 1 On January 1 , 2 0 2 4 , Crane Co . issued eight - year bonds with a face value of $ 6 0 3 0 0 0 0 and a stated interest rate of 1 0 % , payable semiannually on June 3 0 and...
-
Uno Company sold office equipment with a cost of $ 3 8 , 0 7 0 and accumulated depreciation of $ 3 4 , 3 7 9 for $ 5 , 3 5 0 . Required What is the book value of the asset at the time of sale? What...
Study smarter with the SolutionInn App