cscC43/csc343 Winter 2008

Assignment 2 Clarifications and Corrections

Check this page regularly for any hints, clarifications or corrections related to Assignment 2

Feb 11, 2008

Please submit (using the cdf submit command) electronically a file called a2.txt containing a completed cover page and a file called a2.sql containing your solutions (in order) for Assignment 2. You should delimit each answer using comments:

-- BEGIN QUERY 1
query
-- END QUERY 1

The latter file must be loadable into (and must run on) cdf postgres. Please also hand in printouts of both in lecture or under your professor's office door. As with the first assignment, you must submit both electronic and paper copies by the due date and time.

Feb 4, 2008

Please download a new version of the assignment that includes the following instructions.

Your solutions may not have any insert (or update) statements.

For each query, if you create any intermediate views (or any DDL artifacts) you must drop the view statements at the end of the query as well. For example,

     create view helpForQ2 ....
     select company, ....  from....
     drop view helpForQ2

You will lose marks for not following the output schema for each query (including the order of attributes and for not dropping views).

A new ddl is also available without the erroneous comma.