Question: Problem 3 Create Stored Procedures to Maintain Your Database You know that many queries you will need to complete in your web application can be

Problem 3 Create Stored Procedures to Maintain Your Database You know that many queries you will need to complete in your web application can be stored with the database. Create the stored procedures below. Show the stored procedure and the data returned in your Word document. There are quite a few but you will use these later when you build the web site. Insert a new category into the categories table (make sure to pass the values as input parameters) Insert a new product into the products table (make sure to pass the values as input parameters) Insert a new customer into the customers table (make sure to pass the values as input parameters) Insert a new log file into the log table (make sure to pass the values as input parameters) Insert a new order into the orders table (make sure to pass the values as input parameters) Delete an order in the orders table, given the orderID. Delete a product given a productID Delete a customer given a customerID Delete a log entry given a customerID Delete a category given a category ID Step Review and document your programs Review and document your programs Preview and test your program. Again, make sure there is adequate documentation all of your programs. (ASP, CS, etc) If you need additional screen shots to show your program, just add them here. Review your code and make sure you used descriptive names for the controls. (Not textbox1 or label1) Screen shots of the web pages in the browser with the address bar showing. In other words, show me that your pages worked! Screen shots of the entire source code files you modified this week.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!