Using Immediate Updates recovery scheme answer the following questions.Which transactions will be undone, redone and What will be the values of Salary and Tax after recovering the system?The blue is my answer and im not sure if i got right or not, please help 1 [Start, TI]2 [Start, T2]3 [T1, Bounce, 500, 1000]4 [T2, Salary, 4000,4400]5 [Checkpoint, Active={T1, T2}]6 [T2, Bounce, 1000, 1500]7 [Commit, T₂]8 [Start, T3]9 [T1, Salary, 4400, 7000]10[Checkpoint, Active={T1, T3}]11[T3, Tax,300,500]12[T3,EmpN,10,14]13 [Commit, T1]14[Commit, T3]15[Start, T8]16[T8,Bounce, 1500,1550]17[Start, T5]16[Checkpoint, Active={T5, T8}]17 [Start, T7]18 [T7, abc,6,8]19 [T5, MangN, I,2]20 [Commit, T5]21 [Start, T9]22 [T9, MangN,2,3]23 [Commit, T9]24 [System Failure]I. Using Immediate Updates recovery schemeanswer the following questions.Undone:T7, T8Redone:T1, T2, T3, T5, T9What will be the values of the following variablesafter recovering the system?Tax500EmpN14abcEnd --MangN3

- We need to know about the transactions which will be undone, redone and What will be the values of…

Answered: 1 [Start, T1] 2 [Start, T2] 3 [T1,…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Using Immediate Updates recovery scheme answer the following questions.

Which transactions will be undone, redone and What will be the values of Salary and Tax after recovering the system?

The blue is my answer and im not sure if i got right or not, please help

1 [Start, TI]
2 [Start, T2]
3 [T1, Bounce, 500, 1000]
4 [T2, Salary, 4000,4400]
5 [Checkpoint, Active={T1, T2}]
6 [T2, Bounce, 1000, 1500]
7 [Commit, T₂]
8 [Start, T3]
9 [T1, Salary, 4400, 7000]
10[Checkpoint, Active={T1, T3}]
11[T3, Tax,300,500]
12[T3,EmpN,10,14]
13 [Commit, T1]
14[Commit, T3]
15[Start, T8]
16[T8,Bounce, 1500,1550]
17[Start, T5]
16[Checkpoint, Active={T5, T8}]
17 [Start, T7]
18 [T7, abc,6,8]
19 [T5, MangN, I,2]
20 [Commit, T5]
21 [Start, T9]
22 [T9, MangN,2,3]
23 [Commit, T9]
24 [System Failure]
I. Using Immediate Updates recovery scheme
answer the following questions.
Undone:
T7, T8
Redone:
T1, T2, T3, T5, T9
What will be the values of the following variables
after recovering the system?
Tax
500
EmpN
14
abc
End --
MangN
3

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions