Using a previously created database, develop the following queries….

Question Answered step-by-step Using a previously created database, develop the following queries…. Using a previously created database, develop the following queries.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.Code at least two CALL statements that test this procedure. (Note that this table doesn’t allow duplicate category names.) Execute the query.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. Execute the query.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 should return the value of the total for that item. Execute the query. Computer Science Engineering & Technology MYSQL CS MISC Share QuestionEmailCopy link Comments (0)

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now