PL/SQL

A procedure is needed to update the following columns in the BB_BASKET table when an order is completed: ORDERPLACED, SUBTOTAL, SHIPPING, TAX and TOTAL.

• Construct three functions to perform the following tasks: calculating the subtotal by using the BB_BASKETITEM table based on basket ID as input, calculating shipping costs based on basket ID as input, and calculating the tax based on basket ID and subtotal as input. Use these functions in a procedure.
• A value of 1 entered in the ORDERPLACED column indicates that the shopper has completed the order. The subtotal is determined by totaling the item lines of the BB_BASKETITEM table for the applicable basket number. The shipping cost is based on the number of items in the basket: 1 to 4 = $5, 5 to 9 = $8, and more than 10 = $11.
• The tax is based on the rate applied by referencing the SHIPSTATE column of the BB_BASKET table with the STATE column of the BB_TAX table. This rate should be multiplied by the basket subtotal, which should be an INPUT parameter to the tax calculation because the subtotal is being calculated in this same procedure. The total tallies all these amounts.
• The only INPUT parameter for the procedure is a basket ID. The procedure needs to update the correct row in the BB_BASKET table with all these amounts. To test, first set all column values to NULL for basket 3 with the following UPDATE statement. Then call the procedure for basket 3 and check the INSERT results.

UPDATE bb_basket

SET orderplaced - NULL,

Subtotal = NULL,

Tax = NULL,

Shipping = NULL,

Total = NULL,

WHERE idBasket = 3;

Commit;

APlusGrades

Not Rated (0)

Status NEW Posted 16 Jul 2017 07:07 AM My Price 11.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- Â-----------  -----------Tha-----------nk -----------you----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------.Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m Â----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I

Not Rated(0)

• Buy Answer