Calculate the discount price of an item in the table

Assignment Help Computer Engineering

Reference no: EM132213327

Answer the following Questions :

1. Write a script that creates and calls a stored procedure named insert_category. First, code a statement that creates a procedure that adds a new row to the Categories table. To do that, this procedure should have one parameter for the category name. (Two Screenshots - Script and Results) ? Code at least two CALL statements that test this procedure. (Note that this table doesn't allow duplicate category names.)

2. Write a script that creates and calls a stored function named discount_price that calculates the discount price of an item in the Order_Items table (discount amount subtracted from item price). To do that, this function should accept one parameter for the item ID, and it should return the value of the discount price for that item. (Two Screenshots - Script and Results)

3. Write a script that creates and calls a stored function named item_total that calculates the total amount of an item in the Order_Items table (discount price multiplied by quantity). To do that, this function should accept one parameter for the item ID, it should use the discount_price function that you created in exercise 2, and it should return the value of the total for that item. (Two Screenshots - Script and Results)

4. Write a script that creates and calls a stored procedure named insert_products that inserts a row into the Products table. This stored procedure should accept five parameters, one for each of these columns: category_id, product_code, product_name, list_price, and discount_percent. (Two Screenshots - Script and Results) ? This stored procedure should set the description column to an empty string, and it should set the date_added column to the current date. ? If the value for the list_price column is a negative number, the stored procedure should raise an error that indicates that this column doesn't accept negative numbers. Similarly, the procedure should raise an error if the value for the discount_percent column is a negative number. ? Code at least two CALL statements that test this procedure.

5. Write a script that creates and calls a stored procedure named update_product_discount that updates the discount_percent column in the Products table. This procedure should have one parameter for the product ID and another for the discount percent. (Two Screenshots - Script and Results) ? If the value for the discount_percent column is a negative number, the stored procedure should raise an error that the value for this column must be a positive number. ? Code at least two CALL statements that test this procedure.

Reference no: EM132213327

Questions Cloud

Convert an infix expression to a postfix expression : Write semantic actions for the following grammar to convert an infix expression to a postfix expression that is stored in E_post.

Record adjusting entries in separate parts : DH Corporation (DHC) was founded in 2000 by Eric Conner and Phil Martin. The company designs, installs, and services security systems for high-tech companies.

Write a sequence to restore the registers from the stack : Write a sequence to restore the registers from the stack back onto the same registers.

Why is character of gain or loss on a disposition important : Why is the character of a gain or loss on a disposition important? What are the three types of recognized gains or losses that determine their taxation?

Calculate the discount price of an item in the table : Write a script that creates and calls a stored function named discount_price that calculates the discount price of an item.

Write the sequence of instructions you need to write : Write the sequence of instructions you need to write into Python from the moment you open the session to load a picture.

What is qbi deduction amount : Dorothy is an owner-employee in an engineering services firm that is organized as an S corporation. Her share of QBI income is $40,000 and her share.

Calculate the factorial value from 1 to n and outputs : Write a script that takes an input number - N, calculates the factorial value from 1 to N and outputs HTML5 text as shown below:

Calculate the product of the odd integers from 1 to n : Write a script that will calculate the product of the odd integers from 1 to n (or from 1 to n-1 if n is even, where n is some integer > 3).

User Account

All Pages