Write program to give functionality to process movie rentals

Assignment Help Programming Languages

Reference no: EM1371398

Your first procedure is to be named MOVIE_RENTAL_SP and is going to provide functionality to process movie rentals. Based on data that will represent the movie id, member id and payment method your procedure will need to generate a rental id and then insert a new row of data into the mm_rental table. The process will also need to update the quantity column in the mm_movie table to reflect that there is one less copy of the rented movie in stock. Along with the processing you will also need to define some user-defined exception handlers that will be used in validating the input data. Since you may need to recreate your procedure several times during the debugging process it is suggested that you use the CREATE OR REPLACE syntax at the beginning of the CREATE statement.

Reference no: EM1371398

Questions Cloud

Trade liberalization and environmental standards : Trade liberalization leads to a "race to the bottom" in environmental standards. Make the argument and counter-argument, present the following data;

Advantages and disadvantages of ethnography : describe the advantages and disadvantages associated with ethnography, lead user method, focus groups, and survey research.

Calculate the magnitude of the dipole moment : A small conducting spherical shell with inner radius a and outer radius b is concentric with a larger conducting spherical shell with inner radius c and outer radius d. The inner shell has the total charge of -1q and outer shell has a total charge..

Define what do you think are the moral or ethical dimensions : Explain What do you think are the moral/ethical dimensions of this issue? Is this an unwarranted incursion of government into free enterprise

Write program to give functionality to process movie rentals : Your first procedure is to be named MOVIE_RENTAL_SP and is going to give functionality to process movie rentals. Based on data which will represent movie id, member id and payment method.

Determine point price elasticity of demand : Determine point price elasticity of demand at P= $3.00. Illustrate what would be new point price elasticity if price were raised to P= $4.50.

Examine behavior of increasing cost industry : Assume you own the remodeling company. You're currently earning short-run profits. The home remodeling industry is an increasing cost industry. In the long run, what do you expect will happen to:

Shwo the price skimming and price pentration : Explain the difference between price skimming and penetration pricing. Provide examples of when you may want to use each strategy.

How high was the bridge : On a hot summer day in the state of Washington while kayaking, I saw several swimmers jump from a railroad bridge into the Snohomish River below. The swimmers stepped off the bridge, and I estimated that they hit the water 1 s later.

User Account

All Pages