CS460 is an undergraduate introduction to the principles of the relational database management systems (DBMSs). The goal of the course is to introduce students to the main issues on the design and implementation of a database system and to present how a system like that can be used effectively. Major topics of this course include:

•  Query Languages (SQL, Relational Algebra)
•  Storage and Indexing
•  Query Optimization
•  ER and Relational Data Models
•  Database Design
•  Concurrency Control and Recovery

Prof. George Kollios, Email: gkollios@cs.bu.edu
Office: MCS 104
Office Hours: Tuesday 11:00am - 12:30pm and Wednesday 10:00-11:00am, or by appointment
Phone: 617-358-891835

Lina Qiu, Email: qlina@bu.edu
Office Hours: Monday/Wednesday 11:00 am - 12:00 pm

Zichen Zhu, Email: zczhu@bu.edu
Office Hours: Tuesday/Thursday 3:30pm - 4:30 pm

Required Textbook
 

Raghu Ramakrishnan and Johannes Gehrke, "Database Management Systems", McGraw-Hill, Third Edition. 2002.

Workload

•  Four or five written assignments
• Three programming assignments
• Two exams; one midterm and one final

Very good programming skills and knowledge of basic data structures (e.g., CS 112).

Important Dates:

        Last day to drop the class without a W grade is Tue 10/10/17
        Last day to drop the class with a W grade is Fri 11/10/17

Exams

Midterm:  March 11, 2021 (tentative)
Final:   May 4, 2021.  
 

Lectures

Tue/Thu 12:30-1:45pm in KCB 101