Lab 10 DB.doc - IST350 Database Management Ch 10 Labs 1...

This preview shows page 1 - 3 out of 6 pages.

IST350 Database Management Ch. 10 Labs 1. 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 PROD_CODE PROD_QOH PART_CODE PART_QOH ABC 1,205 A 567 B 98 C 549 Given that information, answer Questions a through e. a. How many database requests can you identify for an inventory update for both PRODUCT and PART? Inventory update requires 4 or 2 database requests.
b. Using SQL, write each database request you identified in step a.
c. Write the complete transaction(s).

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture