While users were updating the BITS 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 shown in Figure 7-11, list and describe the updates that the DBMS will roll back if transaction 2 is interrupted at 8:10. Transaction ID Time ActionRecord UpdatedBefore Image After Image18:00Start28:01Start8:02InsertClient (521)(new values)8:03UpdateTasks (WC19, $125.00)(old values)(new values)8:04InsertWorkOrders (69163)(new values)8:05Commit38:06Start28:07InsertOrderl ine (69163, VR39)(new values)28:08InsertOrderline (69163, UP38)(new values)8:09Start8:10UpdateClient (521, $275.00)(old values)(new values)8:11UpdateConsultant (19, $25.00)(old values)(new values)8:12Commit38:13UpdateConsultant (51, 40)(old values)(new values)8:14Commit8:15DeleteTasks (AC65)(old values)8:16Commit

Answered: You need to explain to management what…

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

100%

While users were updating the BITS 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 shown in Figure 7-11, list and describe the updates that the DBMS will roll back if transaction 2 is interrupted at 8:10.

Transaction ID Time Action
Record Updated
Before Image After Image
1
8:00
Start
2
8:01
Start
8:02
Insert
Client (521)
(new values)
8:03
Update
Tasks (WC19, $125.00)
(old values)
(new values)
8:04
Insert
WorkOrders (69163)
(new values)
8:05
Commit
3
8:06
Start
2
8:07
Insert
Orderl ine (69163, VR39)
(new values)
2
8:08
Insert
Orderline (69163, UP38)
(new values)
8:09
Start
8:10
Update
Client (521, $275.00)
(old values)
(new values)
8:11
Update
Consultant (19, $25.00)
(old values)
(new values)
8:12
Commit
3
8:13
Update
Consultant (51, 40)
(old values)
(new values)
8:14
Commit
8:15
Delete
Tasks (AC65)
(old values)
8:16
Commit

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