If you have not already implemented The Queen Anne Curiosity Shop database shown in Chapter 3 in a DBMS product, create and populate the QACS database now in the DBMS of your choice (or as assigned by your instructor).
A. Create a user named QACS-User with the password QACS-User+password. Assign this user to database roles so that the user can read, insert, delete, and modify data.
B. If you haven’t completed exercise 7.50, do it now.
C. Add a new folder to the DBC Web site named QACS. Create a Web page for The Queen Anne Curiosity Shop in this folder—use the file name index.html. Link this page to the DBC Web page.
D. Create an appropriate ODBC data source for your database.
E. Code a Web page using PHP to display the data in SALE. Add a hyperlink on the QACS Web page to access the page. Using your database, demonstrate that your page works.
F. Code a Web page using PHP to display the data in ITEM. Add a hyperlink on the QACS Web page to access the page. Using your database, demonstrate that your page works.
G. Create a view named Sale_Item_Item_View that displays SALE.SaleID, SALE_ITEM .SaleItemID, SALE.SaleDate, ITEM.ItemDescription, and SALE_ITEM.ItemPrice. Code a Web page using PHP to display the data in Sale_Item_Item_View. Add a hyperlink to the QACS Web page to access the page. Using your database, demonstrate that your page works.
H. Code two HTML/PHP pages to add a new CUSTOMER to the QACS database. Create data for two new CUSTOMERs and add them to the database to demonstrate that your pages work.
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.