CS432: Course Information

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).

Instructor

• Jayavel Shanmugasundaram

Office: 4105A Upson Hall
Email:

Teaching Assistants

• Adina Crainiceanu, Adrian Munteanu, Kelwin Tamtoro, Fan Yang, Warren Wong, Lin Zhu

Location and Hours

• Lectures: 2:30-3:20pm MWF
• Location: Olin Hall 255

Textbook

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

This is a required textbook, and is available in the campus bookstore. 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 attend CS414 along with this course.

Workload and Grading

The grades for CS432 will be determined based on assignments (40%), exams (55%), and class participation (5%).

Assignments

• Assignment 1: Disks and Files, Entity-Relationship Model. (5%, written assignment)
• Assignment 2: Relational Algebra and Calculus. (5%, written assignment)
• Assignment 3: SQL. (5%, SQL queries)
• Assignment 4: Indexing and sorting. (5%, written assignment)
• Assignment 5: Relational operators and query optimization. (5%, written assignment)
• Assignment 6: Concurrency control. (5%, written assignment)
• Assignment 7: Recovery (5%, written assignment)
• Assignment 8: Schema design (5%, written assignment)

Exams

1. Mid-term exam. (20%)
2. Final exam. Cumulative with emphasis on the last half of the course. (35%)

Class Participation

• Participation in class discussions (5%)