Completing transaction using sql

Assignment Help Database Management System

Reference no: EM1344765

Q1) Assume that you manufacture a 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. And each time the product is created, the parts inventory, using PART_QOH of table PART, must be reduced by one each of parts A, B and C. The sample database parts are shown below.

PRODUCT PART
PROD_CODE PROD_QOH PART_CODE PART_QOH
ABC 1205 A 567
B 98
C 548

2. Given the above,

(a) Write down the complete transaction using SQL.

(b) Write the full transaction log.

Reference no: EM1344765

Questions Cloud

How far from base of the table did it strike the floor : A projectile is fired at an upward angle of 45° from the top of a 308m cliff with a speed of 198 m/s. What will be its speed while it strikes the ground below? (Use conservation of energy.)

How many put option contracts should be purchased : If the portfolio has a beta of 1, how many put option contracts should be purchased and If the portfolio has a beta of 0.5, how many put options should be purchased?

Discuss elements of financial statements : Suppose you are deciding whether or not to invest in a particular firm. Discuss which basics of which financial statements you would want to carefully examine.

What is an index of refraction of the glass : A little cat, Bella, walks in a straight line, which we shall call the x axis, with positive direction to the right. As an observant scientist, you make measurements of her motion and construct a graph of the little feline's velocity as a function..

Completing transaction using sql : Write down the complete transaction using SQL.

Explain what long position in the stock : Explain what long position in the stock is necessary to hedge a short call option when the strike price is $32 and provide the number of shares purchased as a percentage of the number of options that have been sold

What is the radial distance a projectile reaches : If an astronaut can throw a certain wrench 14 {rm m} vertically upward on earth, how high could he throw it on our moon if he gives it the similar starting speed in both places.

What are the monopolists profit-maximizing price : Suppose that one company acquires all the suppliers in the industry and thereby creates a monopoly. Illustrate what are the monopolist's profit-maximizing price and total output.

Analyzing revenue recognition methods : Describe different revenue recognition methods under GAAP and IFRS. Define ADR firms.

User Account

All Pages