Stored Procedures:

$(25)$ Write a procedure that will insert a record to the product table

$(26)$ Write a procedure that when called it will increase the price by a percent for a particular product.

Views

$(27)$ Create a view named products$\_$more$\_$than$\_3\_$sold to select the following: For each product that

has more than three items sold within all sales transactions, retrieve the product ID$,$ product name, and

product price.

$(28)$ Create a view named products$\_$in$\_$multiple$\_$trnsc to select the following: for each product whose

items were sold in more than one transaction, retrieve the product name and product price.

$(29)$ retrieve the product id$,$ product name, and product price for each product that has more than three

items sold within all sales transactions OR whose items were sold in more than one sales transaction.STORE

INCLUDES

VENDOR

CATEGORY

SALESTRANSACTION

CUSTOMER

PRODUCT