Ch. 10 Labs
Suppose you are a manufacturer of product ABC, which is composed of parts A, B, and C. Each time
a new product is created, it must be added to the product inventory, using the PROD_QOH in a table
named PRODUCT. And each time the product ABC 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 The Database for Problem 1
Table name: PRODUCT
Table name: PART
Given that information, answer Questions a through e.
How many database requests can you identify for an inventory update for both PRODUCT and
PART? Inventory update requires 4 or 2 database requests.
Using SQL, write each database request you identified in step a.
Write the complete transaction(s).