Project #19995 - DBST 651 - Relational Database Systems Question

Question 3:     (20 Points)

Please provide answers to problems 1a- 1d in Chapter 10 0f Coronel book. (Page 464)

 

 

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 part inventory, using PART _QOH in a table named PART, must be reduced by one each parts A, B, and C. The sample database contents are shown in the following tables.

 

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 d.

 

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.

 

 

Subject Computer
Due By (Pacific Time) 12/15/2013 10:30 pm
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy