Question

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 PROD_CODE PROD_QOH ABC 1,205 TABLE NAME: PART PART_CODE PART_QOH A 567 B 98 C 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).

          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
PROD_CODE PROD_QOH
ABC 1,205

TABLE NAME: PART
PART_CODE PART_QOH
A 567
B 98
C 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).

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 prodqoh in 33774

Added by Remedios A.

Question

Please give Ace some feedback