1, Assume that 'ABC, has a PROD QOH = 950 at the start of the transaction and the transaction represents the adding of 1 new product. Assume that PART components "A", "B"and "C" have a PROD QOH equal to 395, 390, and 405 respectively TRLTRX PREV NEXT ROW ID BEFORE AFTER ID NUMPTR ATTRIBUTE VALUE Click here to enter textClick here to PTR OPERATION TABLE VALUE Click here to enter Click here to enter ted Click here to enter Click here to enter text Click here to enter Click here to enter tedt Click here to enter ted here to enter ted text Click here to enter Click here to enter Click here to nter tout. Click here to Click here to nter teoct Click here to enter Click here to enter textClick here to Click here to enter here to enter tooct nter teoct Click here to enter Click here to enter texdt Click here to enter text Click here to enter text Click here to enter text Click here to enter text Click here to enter textClick here to Click here to enter text here to enter text Click hereClick here to enter texd Click here to enter toxct Click here to Click here to nter tooct Click here to enter Click here to enter textClick here to Click here to enter here to to enter enter teoct nter tooct Click here Click here to enter Click here to enter text Click here to enter Click here to enter text Click here to enter text Click here to enter textClick here to Click here to enter text here to to enter enter text Click hereClick here to enter texd Click here to enter toxct Click here to Click here to nter teoct Click here to enter Click here to enter text Click here to nter teoct Click here to enter here to to enter enter teoct 2. Now using the transaction log you created in Step 4, trace its use in database recovery. 3. Describe the three most common concurrent transaction execution problems. Explain how concurrency control can be used to avoid those problems 1, Assume that 'ABC, has a PROD QOH = 950 at the start of the transaction and the transaction represents the adding of 1 new product. Assume that PART components "A", "B"and "C" have a PROD QOH equal to 395, 390, and 405 respectively TRLTRX PREV NEXT ROW ID BEFORE AFTER ID NUMPTR ATTRIBUTE VALUE Click here to enter textClick here to PTR OPERATION TABLE VALUE Click here to enter Click here to enter ted Click here to enter Click here to enter text Click here to enter Click here to enter tedt Click here to enter ted here to enter ted text Click here to enter Click here to enter Click here to nter tout. Click here to Click here to nter teoct Click here to enter Click here to enter textClick here to Click here to enter here to enter tooct nter teoct Click here to enter Click here to enter texdt Click here to enter text Click here to enter text Click here to enter text Click here to enter text Click here to enter textClick here to Click here to enter text here to enter text Click hereClick here to enter texd Click here to enter toxct Click here to Click here to nter tooct Click here to enter Click here to enter textClick here to Click here to enter here to to enter enter teoct nter tooct Click here Click here to enter Click here to enter text Click here to enter Click here to enter text Click here to enter text Click here to enter textClick here to Click here to enter text here to to enter enter text Click hereClick here to enter texd Click here to enter toxct Click here to Click here to nter teoct Click here to enter Click here to enter text Click here to nter teoct Click here to enter here to to enter enter teoct 2. Now using the transaction log you created in Step 4, trace its use in database recovery. 3. Describe the three most common concurrent transaction execution problems. Explain how concurrency control can be used to avoid those problems