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)