CIS 761. Database Management Systems, Spring 2007

General course information

• Captain's log
• Syllabus
• The material covered during the course
• A web page for the textbook

Assignments

• Assignment #1 due Friday, January 26, 2007.
  (Model solutions)
• Assignment #2 due Wednesday, February 7, 2007.
  (Model solutions)
• Assignment #3 due Friday, February 23, 2007.
  (Model solutions)
• Assignment #4 due Monday, March 5, 2007.
  (Model solutions)
• Assignment #5 due Friday, March 16, 2007.
  (Model solutions)
• Assignment #6 due Friday, March 30, 2007.
  (Model solutions)
• Phase I of Project due Wednesday, April 11, 2007
• Assignment #7 due Friday, April 20, 2007.
  (Model solutions)
• Phase II of Project due Wednesday, April 25, 2007
• Assignment #8 due Friday, May 4, 2007.
  (Model solutions)

Exams

• Midterm, part I with solution key
• Midterm, part II with solution key
• Final with solution key

Lecture notes

• a condition for lossless joins
• "the Chase"
• general join dependencies
• examples of computing best decision trees

Ancillary material

• MySQL: how to set up and run.
  • An example script to set up the employee database.
  • An example script to set up the bank database.
• Oracle: how to set up and run.
  • An example script to set up the employee database.
  • An example script to set up the bank database.
• Previous exam questions
• SQL Tutorial
• MySQL reference manual