Assignment 1: relational algebra and calculus. Due 9/18/2003 at the start of class; hand in on paper. Answers.
Assignment 2: SQL. Due 9/25/2003 at the start of class; hand in on paper, or send electronic version to dinkar@gradient.cis. Oracle script for creating and populating tables for the first two questions. Answers.
Assignment 3: ER & normalization. Due 10/7/2003 at the start of class; hand in on paper. Answers.
Assignment 4: XQuery and
DTDs. Due 10/16/2003 at the start of class; hand in on paper or
submit electronically to dinkar@gradient.cis. To test your answers,
use Galax, in
~zives/galax/bin on eniac, or download a version for Windows and
Cygwin (which you can get here). You can also
download source code or binaries for Linux or Solaris from the Galax
web site. The data files are db-proc.xml and
db-inproc.xml. Answers.