Problem #$2$

Suppose you are a manufacturer of a Gear Box, which is composed of parts X$,$ Y$,$ Z$.$ Each time a new Gear Box is created, it must be added to the product inventory, using the PROD$\_$QOH in a table named PRODUCT. And each time a Gear Box is created, the parts inventory, using PART$\_$QOH in a table named PART, must be reduced Correspondingly. The sample database contents are shown below. $--15$ points

a$.$ Write the complete transaction$($s$).$

b$.$ Write the transaction log$,$ using this transaction log table as your template.

TRL

ID TRX

NUM PREV

PTR NEXT

PTR

OPERATION

TABLE ROW

ID

ATTRIBUTE BEFORE

VALUE AFTER

VALUE

$1$

$2$

$3$

$4$

$5$

$6$