Hi, For the following two transactions and the initial table values as shown com

Question

Hi,

For the following two transactions and the initial table values as shown complete the missing blanks in the transaction log below:

Part_ID

Desrption

OnHand

OnOrder

57

Assembled Foo

5

0

987

Foo Fastener

12

7

989

Foo Half

7

0

BEGIN TRANSACTION;

UPDATE Part SET + 7, – 7 WHERE Part_ID = 987;

COMMIT;

BEGIN TRANSACTION;

UPDATE Part SET - 4 WHERE Part_ID = 987;

UPDATE Part SET - 2 WHERE Part_ID = 989;

UPDATE Part SET + 1 WHERE Part_ID = 57;

COMMIT

TRL_ID

TRX_ID

PREV_PTR

NEXT_PTR

OPERATION

TABLE

ROW ID

ATTRIBUTE

BEFORE VALUE

AFTER VALUE

1787

109

NULL

START

****

1788

109

1787

UPDATE

PART

987

OnHand

12

1789

109

UPDATE

PART

987

OnOrder

7

1790

109

NULL

COMMIT

****

1791

110

NULL

START

****

Part_ID

Desrption

OnHand

OnOrder

57

Assembled Foo

5

0

987

Foo Fastener

12

7

989

Foo Half

7

0

Explanation / Answer

TRL_ID TRX_ID PREV_PTR NEXT+PTR OPERATION TABLE ROW ID ATTRIBUTE BEFORE VALUE AFTER VALUE 1787 109 NULL 1788 START **** 1788 109 1787 1789 UPDATE PART 987 OnHand 12 19 (OnHand+7) 1789 109 1788 1790 UPDATE PART 987 OnOrder 7 0 (OnOrder-7) 1790 109 1789 NULL (End of Transaction) COMMIT **** 1791 110 NULL 1792 START **** 1792 110 1791 1793 UPDATE PART 987 OnHand 19 15(OnHand - 4) 1793 110 1792 1794 UPDATE PART 989 OnHand 7 5 (OnHand - 2) 1794 110 1793 1795 UPDATE PART 57 OnHand 5 6 (OnHand + 1) 1795 110 1794 NULL (End of Transaction) COMMIT ****

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.