Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
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
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 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 AFTER VALUE VALUE 1787 109 1788 109 1789 109 1790 109 1791 110 1792110UPDATE PART 987 1793 110 1794110 1795 110 START UPDATE UPDATE COMMIT START NULL 1787 PART 987 OnHand 12 PART 987 OnOrder7 NULL kakk NULL OrOrder UPDATE UPDATE OnOrder 7 UPDATE V OnOrderI5 NULL COMMITStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started