CS3811 - 2008

Instructor: Dr. R. Rosebrugh, Dunn 203

General Information

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

The textbook is A First Course in Database Systems by Garcia-Molina, Ullman and Widom. We will cover chapters 1-12, with lighter coverage of Ch 9,10 as time requires. Note from Ullman about the text: A First Course in Database Systems The third edition was published in 2007. This book covers database design and implementation. It is the first half of Database Systems: The Complete Book, which you should choose instead if your interests go beyond database applications and include implementation of a DBMS.. Also recommended is An Introduction to Database Systems (8th ed) by C. J. Date.

The page for the Garcia-Molina-Ullman-Widom book (including lecture notes) is at http://infolab.stanford.edu/~ullman/fcdb.html ;

Check this URL regularly for information about the course.

There will be written assignments, in-class quizzes, midterm tests, and a project.

The project will will be done in small groups, will be assigned by late October and will be completed near the end of term. The project assignment is at 381108pr.html .


Note: In order to pass the course:

Grades will be assigned using approximately the following weights:

The midterm tests will be held on October 24 and November 26.


The Project description is at 381108pr.html .


Assignment 1

From the text: 2.2.3 a), b), 2.3.2 a), c), e), 2.4.3 a), c), e), g), 2.5.3 a), b), c), 6.1.4 a), c), e).
Due September 22.

Please attempt the other text problems.