a1 - CS348: Introduction to Database Systems (Fall, 2009)...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
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
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/23/2009 for the course CS CS348 taught by Professor Albrama during the Fall '09 term at York UK.

Page1 / 2

a1 - CS348: Introduction to Database Systems (Fall, 2009)...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online