co5ds13h.Ch10.02 or 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...


co5ds13h.Ch10.02



or 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 OnHand = OnHand + 7, OnOrder = OnOrder – 7 WHERE Part_ID = 987;


COMMIT;


BEGIN TRANSACTION;


UPDATE Part SET OnHand = OnHand - 4 WHERE Part_ID = 987;


UPDATE Part SET OnHand = OnHand - 2 WHERE Part_ID = 989;


UPDATE Part SET OnHand = OnHand + 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



****



1792



110







UPDATE



PART



987









1793



110















7



5



1794



110















5



6



1795



110





NULL



COMMIT



****





Jun 03, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here