Q1) Assume that you manufacture a product ABC, which is composed of parts A, B and C. Each time a new product ABC is created, it must be added to the product inventory, using the PROD_QOH in a table named PRODUCT. And each time the product is created, the parts inventory, using PART_QOH of table PART, must be reduced by one each of parts A, B and C. The sample database parts are shown below.

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

2. Given the above,

(a) Write down the complete transaction using SQL.

(b) Write the full transaction log.