how to create the table Table name: PRODUCT Table name: PART and divide 4 of it? write SQL codes to create the table and then the following changes on question 1 b.

I need to make a table and insert these items and then start the 1.b answer and rest please provide codes.

MINDTAP

Chapter Review 10-8d Problems 1. Suppose that you are a manufacturer of 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. Also, each time the product is created, the parts inventory, using PART_QOH in a table named PART, must be reduced by one each of parts A, B, and C. The sample database contents are shown in Table P10.1. Table P10.1 TABLE NAME: PRODUCT TABLE NAME: PART PROD_CODE PROD_QOH PART_CODE PART_QOH ABC 1,205 A 567 B 98 549 Given the preceding information, answer Questions a through e. a. How many database requests can you identify for an inventory update for both PRODUCT and PART? b. Using SQL, write each database request you identified in Step a. c. Write the complete transaction(s). d. Write the transaction log, using Table 10.1 as your template. e. Using the transaction log you created in Step d, trace its use in database recovery