Computer Science 420: Database Systems
Lehman College, City University of New York
Spring 2003
Instructor:Dr. Katherine St. John
E-mail: stjohn@lehman.cuny.edu
Phone: 718-960-7423
Office: G 137D
Office Hours: Tuesdays 1:30-3, Thursdays 9:30-10:50, and by appointment
Lecture: Tuesdays and Thursdays 11-12:50pm
Announcements:
- Sunday, 4 May: Quiz 9 has been reset
to allow multiple attempts. All grades for Quiz 9 were saved. If
you would like the grade to show up on Blackboard, attempt the quiz again
(no need to answer anything) so that there's a record of your grade, and
send mail. Your previous grade can then be entered in the place of
your last attempt.
- Information about the final exam.
- All quizzes should now be available on Blackboard. Also, all grades on Blackboard have been restored from backup.
- Part of Lab 6
was omitted (part of the description of serial and date types). This
has been fixed, and you should download a new copy of the lab.
- Lab 7 has been modified to make the database
used simpler to implement (if you downloaded the presidents, don't worry,
those will be used in Lab 8).
- The prerequisite for this course is CMP 338 (Data Structures
and Algorithms I). It is highly recommended that you have
also completed CMP 337 (Discrete Mathematics and Applications
to Computer Science). If you have not taken the prerequisite
course, do not sign up for this course. All students who
have not completed the prerequisites will be adminstratively
dropped from the course during the first two weeks of classes.
This course assumes you can write complete program in Java that
does file manipulation, uses abstract data structures, and has
GUI's. A major component of this course is writing a large
database that is created and populated via programs and has
a graphical user interface.
If you would like to learn more about databases, but
would prefer not to program, consider taking CIS 244 (Introduction
to Database Management) instead.
Handouts:
- Syllabus
- Outline
- Slides used in lecture on 28 January:
- Slides for lecture on 30 January and 4 February:
(from the
textbook's
page-- Ullman's notes for Fall 2000):
- Quiz 0 (due 6 February)
- Slides for lecture on 6 February (from the
textbook's
page-- Ullman's notes for Fall 2000):
- Slides for lecture on 11 February (from the
textbook's
page-- Ullman's notes for Fall 2000):
- Lab 1 (13 February)
- Quiz 1 (due 13 February)
- Slides for lecture on 18 February (from the
textbook's
page-- Ullman's notes for Fall 2000):
- Lab 2 (20 February)
- Project Information
- Quiz 2 (due 20 February)
- Slides for lecture on 25 February (from the
textbook's
page-- Ullman's notes for Fall 2000):
- Lab 3 for 26 February
- Quiz 3 (due 26 February)
- Overhead slides used in lecture on 4 March (from the
textbook's
page-- Ullman's notes for Fall 2000):
- Lab 4 for 7 March
- Quiz 4 (due 7 March)
- Overhead slides used in lecture on 11 March (from the
textbook's
page-- Ullman's notes for Fall 2000):
- Lab 5 for 13 March
- Quiz 5 (due 13 March)
- Overhead slides used in lecture on 18 March (from the
textbook's
page-- Ullman's notes for Fall 2001):
- Lab 6 for 20 March
- Quiz 6 (due 20 March)
- Information about Exam 1 (25 March)
- Lab 7 for 27 March
- Overhead slides used in lecture on 1 April (from the
textbook's page-- Ullman's notes for Fall 2001):
- Quiz 7 (due 3 April)
- Lab 8 for 3 April
- Overhead slides used in lecture on 8 April (from the
textbook's
page-- Ullman's notes for Fall 2001):
- Quiz 8&9 (due 10 & 28 April)
- Lab 9 for 10 April
- Overhead slides used in lecture on 29 April (from the
textbook's
page-- Ullman's notes for Fall 2001):
- Quiz 10 (due 15 May)
- Overhead slides used in lecture on 6 May (from the
textbook's
page-- Ullman's notes for Fall 2001):
- Lab 10 for 8 May
- Overhead slides used in lecture on 13 May
Useful Links: