1. Code a Web page using PHP to display the data in SERVICE. Add a hyperlink on the GG Web page to access the page. Using your database, demonstrate that your page works.
2. Create a view named Property_Service_View that displays PROPERTY.PropertyID, PropertyName, 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.
3. 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.
Project Question
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).