Assignment 3

Based on your work for Exercise 3 write a query to do the following

  • report back the aircraft name, aircraft ID, and aircraft cruising range for all aircraft which have at least one pilot certified on them that make over $80,000.
  • Take the result of this query and save it to an XML file
  • View the XML file in browser and print out
  • Write an XSL file to filter and process your XML file so that it extracts and displays only aname and cruisingrange, and filters to only show aircraft that have cruising ranges greater than 2000 miles (this processing must be done via XSL, not in SQL). Your result should have table headers, in color, and below the headers you should list each aircraft in a row. (similar to the CD example provided).
  • Have browser display xml file linked with XSL stylesheet, then print out and turn in screen shot of browser window showing result.
For information on how to do the steps of A3 and how to setup and use your webspace on UNC servers see Class Resources page.