1) Assume that you manufacture the product ABC that is composed of the parts A, B and C. Every time a new product ABC is generated, it should be added to the product inventory, utilizing the PROD_QOH within the table named PRODUCT. And every time the product is generated, the parts inventory, using PART_QOH of table PART, should be decreased by one each of parts A, B and C. PRODUCT     PART

PROD_CODE    PROD_QOH     PART_CODE    PART_QOH
ABC                  1205                 A                567
B                       98
C                      548

2) Explain the below questions:

a) Write down the complete transaction utilizing the SQL.

b) Write down the full transaction log.