C20.0046 - Spring, 2008 - Johnson
Homework 2
Due: by email to sterndbms08@gmail.com, 8pm, Sunday, 3/9
 (NB: who's address is this not?)

Important things to remember:

  1. If you wish, you may collaborate with one or two partners, in which case you may turn in a joint submission. Each student must understand all solutions submitted jointly, however.
  2. If you get stuck, ask for help!

Practice questions

(do, but do not turn in!) Any and all subparts of exercises 5.1, 5.2, 5.3, 5.4.

Assigned questions

Give just SQL queries for the following questions. You're free to use all SQL feature.
  • Exercise 5.1, parts 2,5,8,9,10
  • Exercise 5.3, parts 9,10.

mjohnson-at-stern.nyu.edu