Deliverable IV – Query Design

Using the tables developed earlier, develop a set of queries as specified in the query list. Include data in your tables to test each query. Be sure to save the queries and submit the database or database location. Provide printouts of both the SQL view and the query result. Be sure that there is data in your tables so that I can duplicate your results!

  • Upload the queries in a pdf document.
  • For each query, provide a printout of the SQL as well as the query result.
  • Query List