CS3811 - 2005

Instructor: Dr. R. Rosebrugh, Dunn 203

General Information

The course meeting time is 9:30MWF in Dunn 104. Help with assignments or projects is available other times by appointment; contact me by email.

The textbook is Database Systems: the complete book by Garcia-Molina, Ullman and Widom. We will cover all of chapters 1-10 and selected topics from chapters 11-20. Also recommended is An Introduction to Database Systems (8th ed) by Date.

The page for the Ullman-Widom book (including lecture notes) is at http://www-db.stanford.edu/~ullman/dscb.html ;

Check this URL regularly for information about the course.

There will be written assignments, in-class quizzes, midterm tests, and a project. In-class tests will be held on February 16 and March 30.

The project will be assigned in early February and will be completed near the end of term.

Grades

Note: In order to pass the course:

a passing mark on the aggregate of the tests and the project must be obtained;
and you must be present for 80% of the quizzes (they will be from assigned homework problems).

Grades will be assigned using approximately the following weights:

Assignments and quizzes: 20
Tests: 40
Project: 40

Project

The Project description is at 381105pr.html .

Assignments

Assignment 1

From the text: 2.1.3, 2.1.5, 2.1.10, 2.2.6, 2.3.4. Due January 19.

Please attempt the other text problems.

Assignment 2

From the text: 2.4.4 a); from Chapter 3: 1.2, 2.4 a) & c), 3.2, 4.5 a) & c), 5.2 i) & ii), 5.7. Due Feb 2.