CS 432 Fall 2006

CS432 provides a basic introduction to the principles of relational database management systems. Students are also encouraged to concurrently enroll in CS433 (Practicum in Database Systems). CS432 meets from 2:30-3:20pm on Mondays, Wednesdays and Fridays in 255 Olin Hall.

Announcements

The final exam will take place on Monday, December 11, from 2-4:30pm in 101 Philips Hall. The exam covers all the material that we covered in class with an emphasis on the material not covered in the prelim. Good luck!

Course Schedule and Lecture Notes

Course Staff and Office Hours

Instructor: Johannes Gehrke, Fridays 1:15-2:15pm, 4105B Upson Hall.
TAs [please use cs432ta-l at cs dot cornell dot edu to send email to the TAs]
- Mingsheng Hong.
- Parvati Iyer, Tuesdays 10:00-11:00am; place 328B Upson.
- Jeff Peng, Wednesdays 4:30-5:30pm, 328A Upson.

Textbook

"Database Management Systems" by Raghu Ramakrishnan and Johannes Gehrke. Third edition, 2002.

This is a required textbook. The contents of this book do not constitute the syllabus for the course - the classroom lectures define the course content, and the textbook is a reference.

Prerequisites

CS432 will assume knowledge of material covered in CS212 (Computers and Programming) and CS312 (Structure and Interpretation of Computer Programs). CS414 (Systems Programming and Operating Systems) will help with some of the advanced topics taught later in the semester. While CS414 is not a prerequisite, we encourage you to take CS414 along with this course.

Grading

The grades for CS432 will be determined based on assignments (50%) and two exams (50%).

Assignments

Assignment 1: Disks, Files, Entity-Relationship Model, Relational Algebra, Relational Calculus (10%, written assignment)
Assignment 2: SQL, indexing and sorting (10%, SQL queries and written assignment)
Assignment 3: Relational Operators, Query Optimization (10%, written assignment)
Assignment 4: Concurrency control, Recovery (10%, written assignment)
Assignment 5: Schema design and normal forms (10%, written assignment)

Exams

Mid-term exam, Thursday, October 19, 2006, 7:30pm, B17 Upson Hall. (20%)
Final exam. Cumulative with emphasis on the last half of the course. Monday, December 11, 2006, 2:00pm, 101 Phillips Hall. (30%)