Homework 2
CS422, Fall 2010

Due: Wednesday, October 20

Please upload your solutions to CSNS. Note that file uploading will be disabled automatically after 11:59PM of the due date, so please turn in your work on time.

(48pt) Complete the following queries using the sample database University (university-create.sql, university-drop.sql). Feel free to insert more records into the tables to test your queries, but do not use any views.

Please put all the queries in an SQL script hw2-queries.sql, and make sure that each query is labeled with the exercise number, e.g.

-- 4.20 (a)
select ...