A. Add a new folder to the DBP Web site named QACS. Create a Web page for the Queen Anne Curiosity Shop in this folder, using the file name index.html. Link this page to the DBP Web page.
B. Create an appropriate ODBC data source for your database.
C. Code a PHP page to display the data in the CUSTOMER table. Using your sample database, demonstrate that your page works.
D. Create a view called Customer Purchases View that has the columns Customer ID, Last Name, First Name, Sale ID, Sale Date, Sale Item ID, Item ID, Item Description, and Item Price.
E. Code a PHP page to display Customer Purchases View. Using your sample database, demonstrate that your page works.
F. Code two HTML/PHP pages to receive a date value As Of Date and display rows of the Customer Purchases View for purchases having Sale Date greater than or equal to As Of Date. Using your sample database, demonstrate that your pages work.
G. Write a stored procedure that receives values for Sale Item ID and New Item Price and sets the value of Item Price to New Item Price for the row having the given value of Sale Item ID. Generate an error message if no row has the given value of Sale Item ID. Using your sample database, demonstrate that your stored procedure works.
H. Code two HTML/PHP pages to invoke the stored procedure created in part G. Using your sample database, demonstrate that your page works.