Class Notes (1,100,000)
CA (650,000)
UW (20,000)
CS (1,000)
CS348 (20)
Lecture

Assignment #1 Fall 2009


Department
Computer Science
Course Code
CS348
Professor
Ihab Ilyas

This preview shows half of the first page. to view the full 2 pages of the document.
CS348: Introduction to Database Systems
(Fall, 2009)
Assignment 1 (due Friday, Oct. 23rd at 5:00 pm)
Overview: For the first 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 defining 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.
mark
snum
term
cnum
section
grade
snum
section
term sname
cnum
snum
pnum
term
year
section
enrollment student
schedule
cnum
term
section
day
time
room
pname
course
cnum
cname
professor
class
pnum
office
dept
cnum
1
You're Reading a Preview

Unlock to view full version