Write the complete transaction of a product


Assignment:

Suppose that 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

Table The Database

Table name: PRODUCT                            Table name: PART

PROD_CODE

PROD_QOH

 

PART_CODE

PART_QOH

ABC

1,205

 

A

567

 

 

 

B

498

 

 

 

C

549

Given this information:

How many database requests can you identify for an inventory update for both PRODUCT and PART?

Using SQL, write each database request you have identified in Step a.

Write the complete transaction(s).

Write the transaction log, using Table as your template.

Using the transaction log you created in Step d, trace its use in database recovery.

Solution Preview :

Prepared by a verified Expert
Database Management System: Write the complete transaction of a product
Reference No:- TGS01939032

Now Priced at $25 (50% Discount)

Recommended (90%)

Rated (4.3/5)