If you have not already implemented the Garden Glory database shown in Chapter 3 in a DB...

If you have not already implemented the Garden Glory database shown in Chapter 3 in a DBMS product, create and populate the Garden Glory database now in the DBMS of your choice (or as assigned by your instructor).

A. Create a user named GG-User with the password GG-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 GG. Create a Web page for Garden Glory in this folder—using 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 OWNED_PROPERTY. Add a hyperlink on the GG 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 PROPERTY_SERVICE. Add a hyperlink on the GG Web page to access the page. Using your database, demonstrate that your page works.

G. Create a view named Property_Service_View that displays OWNED_PROPERTY .PropertyID, PropertyName, PROPERY_SERVICE.EmployeeID, ServiceDate, and HoursWorked. Code a Web page using PHP to display the data in Property Service_ View. Add a hyperlink to the GG Web page to access the page. Using your database, demonstrate that your page works.

H. Code two HTML/PHP pages to add a new OWNER to the GG database. Create data for two new OWNERs and add them to the database to demonstrate that your pages work.