Develop and test at least ten SQL queries using the JOIN syntax discussed in class. At least four of your queries should involve aggregation. To receive full credit, you should use all JOIN variations discussed in class (ON, USING, NATURAL, OUTER) and aggregation with and without GROUP BY clause. Please, generate a script file called query5.sql with all of your join and aggregation queries. Your queries must not produce empty results and also must complete in a reasonable amount of time (a few seconds at most). If any of your queries takes a long time to complete, consider modifying it by adding more conditions that limit the size of the intermediate results or final result.
Develop and test at least two views and at least four queries that use the views. Please, generate a script file called view5.sql with all of your view definitions and queries.
Please, create a new directory in your project directory on the CS server called hw5 and move query5.sql and view5.sql there. Please make sure that all of the relevant files and no others are in that directory.
The instructions on how to submit your project can be found here.
Note that if you made any changes to your database schema or instance by modifying the files you submitted for hw3 you should commit those changes to your hw3 svn repository as well. We will not re-grade them but will use them to create and populate your database, so we can test your hw5 submission.
The due date for the SQL lab is midnight on Tuesday, November 5, 2013.