CS348 Lecture : Assignment #1 Fall 2009
Document Summary
Assignment 1 (due friday, oct. 23rd at 5:00 pm) Overview: for the rst question, you must use your unix accounts and db2 to compose and evaluate a number of. Sql queries for a database that records information about courses. The schema for the database is illustrated by the following relational database schema that includes an indication of primary and foreign key constraints in the manner discussed in class. Sample commands for de ning the base tables for this schema can be downloaded from the course web site. Note that the schema stores information about both ongoing and past classes for a course. Also note that no marks are recorded for any enrollment of an ongoing class, and that, for a past class, a mark is recorded for each of its enrollments. Finally, you may assume that each class has at least one enrollment. Please read these instructions carefully as not following them may result in mark deductions.