Computer Science 420: Database Systems
Lehman College, City University of New York
Fall 2001

Announcements:

• Week of 10 December: we will meet in the lecture room, G227, on Tuesday and the lab, G219, on Thursday.
• Information about the final exam.
• Office hours for the rest of the term:
  • Tuesday, 11 December, 9:30-11am
  • Wednesday, 12 December, 2-5pm
  • Thursday, 13 December, 9:30-11am
  • Monday, 17 December, 2-5pm
• Frequently Asked Questions
• In lab, priority for machines goes to students who are enrolled in the course. If you are not enrolled in the course, please be polite and respectful to the students who are, and wait at least 10 minutes after lab starts before logging into a machine. If students enrolled continue are unable to use the machines, auditing students will be asked not to attend lab and their accounts will be turned off.
• Accounts for this course will be removed from the server, comet, on Monday, 14 January 2002. You should move any files you wish to keep to another machine before then.

Handouts:

• Syllabus
• Outline
• Overhead slides used in lecture on 28 August (from the textbook's page-- Ullman's notes for Fall 2001):
  • slides1.ps
  • slides1.pdf
• Guidelines for Homework
• Homework 1 (due 6 September)
• Slides for lecture on 30 August and 4 September: (from the textbook's page-- Ullman's notes for Fall 2001).
  • slides2.ps
  • slides2.pdf
  • slides3.ps
  • slides3.pdf
• Homework 2 (now due 20 September)
• Overhead slides used in lecture on 13 and 20 September (from the textbook's page-- Ullman's notes for Fall 2001):
  • Functional Dependencies, BNCF, 3NF: slides4.ps, slides4.pdf
• Overhead slides used in lecture on 25 September (from the textbook's page-- Ullman's notes for Fall 2001):
  • Multivalued Dependencies: slides5.ps, slides5.pdf
  • SQL: slides6.ps, slides6.pdf
• Overhead slides used in lecture on 2 October (from the textbook's page-- Ullman's notes for Fall 2001):
  • SQL: slides6.ps, slides6.pdf
  • more SQL: slides7.ps, slides7.pdf
• Homework 3 (now due 4 October)
• Lab 1 for 4 October
• Information about Exam 1.
• Overhead slides used in lecture on 16 October (from the textbook's page-- Ullman's notes for Fall 2001):
  • More on SQL: slides7.ps, slides7.pdf
  • Relational algebra: slides5.ps, slides5.pdf
• Homework 4 (now due 18 October)
• Lab 2 for 18 October
• Overhead slides used in lecture on 23 October (from the textbook's page-- Ullman's notes for Fall 2001):
  • Relational algebra: slides5.ps, slides5.pdf
  • Yet more on SQL: slides8.ps, slides8.pdf
• Homework 5 (due 25 October)
• Lab 3 for 25 October
• Overhead slides used in lecture on 30 October (from the textbook's page-- Ullman's notes for Fall 2001):
  • Yet more on SQL, part II: slides9.ps, slides9.pdf
• Homework 6 (due 1 November)
• Lab 4 for 1 November
• Overhead slides used in lecture on 6 November:
  • Review of Java (from introductory programming course taught in Fall 1998): plain java examples
  • Review of Course, thus far (using sample exam from Prof. Ullman's Fall 2000 course): midterm, solution,
• Lab 5 for 8 November
• Homework 7 (due 8 November)
• Project Information
• Overhead slides used in lecture on 13 November (from the textbook's page-- Ullman's notes for Fall 2001):
  • Yet more on SQL, part III: slides10.ps, slides10.pdf
• Lab 6 for 15 November
• Information about exam 2, including answer key.
• Overhead slides used in lecture on 27 November (from the textbook's page-- Ullman's notes for Fall 2001):
  • System aspects of SQL: slides13.ps, slides13.pdf
  • Exam 2
• Overhead slides used in lecture on 4 December (from the textbook's page-- Ullman's notes for Fall 2001):
  • Recursion: slides14.ps, slides14.pdf
• Lab 7 for 6 December
• Homework 9
• Overhead slides used in lecture on 11 December
  • Negation and Recursion: slides15.ps, slides15.pdf
    (from the textbook's page-- Ullman's notes for Fall 2001):
  • Airline Route Maps

Useful Links:

• Textbook's page (contains answers to starred exercises in the book)
• Object Data Management Group page contains the standard for ODL.
• PostgreSQL Webpage includes free SQL for linux, FAQ's and other documentation.