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.
- 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 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
- Jeff Peng, Wednesdays 4:30-5:30pm, 328A Upson.
- "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.
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.
The grades for CS432 will be determined based on assignments (50%) and two exams
- 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)
- 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%)