Update columns orderplaced subtotal shipping tax and totel

Assignment Help Basic Computer Science

Reference no: EM13230934

After a shopper completes an order, a procedure is called to update the following columns in the Basket table:orderplaced, subtotal, shipping, tax and total. The value 1 entered in the ordereplaced column indicates that the shopper has completed an order. Inputs to the procedure are the basket id and amounts for the subtotal, shipping,, tax, and total. 1. in sql , create a procedure named basket_confirm_sp that accepts the input values specified in the preceding description. Keep in mind that you're modifying an existing row of the bb_basket table in this procedure. 4.Call the procedure with the following parameter values: 17, 64.80, 8.00, 1.94, 74.74. As mentioned, these values represent the basket ID and the amounts for the subtotal, shipping, tax and total.

Reference no: EM13230934

Questions Cloud

Compute the ph of a solution prepared by mixing : Calculate the pH of a solution prepared by mixing 50mL of a 0.10 M CH3NH2 solution with 25mL of a .20M HCl solution. (Kb CH3NH2 = 4.4 x 10^-4)

Calculate the project completion time : Indicate the critical path activities and what is the probability of completing this project between 38 and 40 days?

Determine whether operation results in overflow or underflow : Overflow occurs when a result is too large to be represented accurately given a word size. Underflow occurs when a result is too small to be represented correctly (for example, a negative result while doing unsigned arithmetic.).

Explain what ration of naoac or hoac should use : If you want to prepare a buffer with a pH of 4.30 with HOAc (acetic acid) and NaOac, what ration of NaOAc/HoAc should you use? (pKa of HOAc is 4.74)

Update columns orderplaced subtotal shipping tax and totel : After a shopper completes an order, a procedure is called to update the following columns in the Basket table: orderplaced, subtotal, shipping, tax and total.

What are the rated full -load speeds of a motor : What are the rated full -load speeds of a 400HZ motor that may be connected for either two or four pole operation, assuming a full load slip of 4% for both cases

Find the volts-div scale that is being used : If the output of the function generator for a sinusoidal waveform is 6 voltage divisions peak to peak and the voltmeter reads 2.12V, find the volts/div scale that is being used. If the frequency is 1 KHz and the peaks are 5 horizontal divisions ap..

Introducing a project management philosophy : What do you see as being the primary challenges to introducing a project management philosophy in most organizations? That is, why is difficult to shift to a project-based approach in many companies?

Determine minimum amount of water in gallons it must hold : The plant contains six 288MW generators. Given the overall facility efficiency is 76%, and the plant is capable of full output for a duration of 5 hours, determine the potential energy of upper reservoir and the minimum amount of water in gallons ..

User Account

All Pages