Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started