Question: 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 COMMIT
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
