[UW Logo]

University Of Waterloo
David R. Cheriton School of Computer Science
CS 338 Winter 2006

Computer Applications in Business: Databases

A user-oriented approach to the management of large collections of data. Methods used for the storage, selection and presentation of data. Common database management systems. This course focuses on providing exposure to database concepts. See http://www.cs.uwaterloo.ca/undergrad/courses/cDescr/CS338.shtml for details.

Note:  a downloadable one-page summary of this information is available (PDF; 13KBytes).

Announcements

New:

2006-1-1:Lecture notes are available. We will be using the first section during the first class.

2006-1-1:Assignment 1 is now available, as a downloadable PDF, or in HTML. This assignment will be handed out at the first class and is due Monday, 2006-1-16.

Lectures

Thursdays, 7:00 - 9:50 P.M. (1900h to 2150h), MC 2038

A schedule of events for the term, including assignment and midterm dates is available as a downloadable PDF (16KBytes).

Course Personnel

Instructor

Trevor Grove
D.R. Cheriton School of Computer Science
Davis Centre 2562
E-mail:   trg+cs338w2006@cs.uwaterloo.ca (please put [cs338] in each message subject)
Voice:   (519) 888-4679 (UW ext 4679)

Office hours: to be determined

Teaching assistants

To be announced.

Course Resources

Course Mailing List: https://lists.uwaterloo.ca/mailman/listinfo/cs338
Note that you must subscribe to this list -- you are not automatically subscribed. I will be using the mailing list in place of a news-group because so many people have trouble with reading and posting news from off campus. An important feature of the mailing list is its web-based message archive, which lets you look back at any time to review all of the messages that have been sent.

CS 338 Course Notes: available online now.

Course Textbook: Fundamentals of Database Systems, Fourth Edition; Elmasri and Navathe; Addison-Wesley, 2004. The Third Edition (c) 2000 is also acceptable. A Reserve copy will be placed on one-hour reserve at the Davis library.

Workload

The marking scheme for the course will be based on a "best of" combination of assignments (five, unequally weighted), one midterm and the final. See the information sheet for more details. Note that the final exam mark must be 50% or greater.

Assignment Policies

Assignments will use a combination of electronic submission and paper submission. Details will be provided with each assignment.

Unless otherwise indicated, assignments are to be done individually. Informal collaboration is acceptable, but work submitted for marking must be an individual effort.

The School's penalty for plagarism is severe. See http://www.cs.uwaterloo.ca/undergrad/programs/policies/cheating.shtml

Assignments

DB2 Hints for CS 338. Read this before trying to use DB2.

Assignment 1: downloadable PDF, or in HTML. This assignment will be due 2006-1-16.

Supplementary Materials

The UNIX Hosts that are available to CS338 students can be found in the list of Computer Science Hosts. Note however that access to the DB2 system we will be using is available only on the system rees.math.

There is a UNIX tutorial that you may wish to read if you are not familiar with the CS UNIX environment. The MFCF Consultants are also available to answer UNIX questions. They can be found in MC 3011, Monday to Friday from 9:30 to 17:30.

Other Resources