How many database requests can you identify

Assignment Help Computer Engineering

Reference no: EM132142037

Assignment

Suppose you are a manufacturer of product ABC, which is composed of components A, B, and C. Component A is further composed of parts X and Y.

Each time a new product ABC is created, it must be recorded in the product inventory, PROD_QOH in a table named PRODUCT.

Likewise, each time the product ABC is created, the corresponding components inventory, COMP_QOH in a table named COMPONENT, must be reduced by one each of components A, B, and C, and the parts inventory PART_DOH in a table named PART, must be reduced by one each of parts X and Y.

The sample database content is shown below.

PRODUCT

PROD_CODE	PROD_DOH
ABC	1,375

COMPONENT

COMP_CODE	COMP_DOH
A	495
B	517
C	387

PART

PART_CODE	PART_DOH
X	1,209
Y	50

Given that information, answer questions a through c.

a. How many database requests can you identify when a new component A is created for tables COMPONENT and PART?

b. Using SQL, write each database request you identified in question a.

c. How many database requests can you identify when a new product ABC is created for tables PRODUCT, COMPONENT, and PART?.

d. Using SQL, write each database request you identified in question a.

Reference no: EM132142037

Questions Cloud

Plot the yield curve and describe the general shape of curve : 25721 Investment Management Assignment, UTS Business School, Australia. plot the yield curve and describe the general shape of curve

Determine how many times a occurs in the dna string : Determine how many times A occurs in the DNA string. Create a dot string which blanks out everything but all the A characters.

Draw a graph of the us automobile market : Draw a graph of the U.S automobile market in which the domestic equilibrium price without trade is Pd and the and the equilibrium quantity is Qd.

Explain the difference between the two diagrams : Draw the supply and demand diagram for reserves with the curves intersecting on the downward sloping part of the demand curve - diagram A.

How many database requests can you identify : Suppose you are a manufacturer of product ABC, which is composed of components A, B, and C. Component A is further composed of parts X and Y.

Differences of blue ocean and red ocean strategies : Explain the characteristics and fundamental differences of ‘Blue Ocean and Red Ocean’ strategies (Kim & Mauborgne, 2005).

Draw two supply and demand graphs : Draw two Supply and Demand graphs (one for each problem) and show what happens to price and quantity a. in the market for chocolate ice cream.

Calculate the payback for investment a and b : Assume a $80,000 investment and the following cash flows for two alternatives.

Make swot analysis chart for lululemon athletica : Make (draw) a SWOT analysis chart for lululemon athletica. Discuss implications of your analysis on the recommended future strategy of that organization.

User Account

All Pages