COMS W4111.001-Introduction to Databases
Columbia University
Spring 2018

Collaboration and Academic Honesty | Homework and Project Policies | Contests and Rewards | CourseWorks and Piazza Discussion Board | Announcements | Lecture Schedule and Readings | Project 1: Part 1, Part 2, Part 3 | Project 2 | Grading Statistics

Course Description: You will learn what a database system is, how you can design databases effectively and in a principled manner, and how you can develop applications using databases. The course will focus on relational and object-relational databases.


You need to get permission from the instructor if you do not have these prerequisites. This course is intended for both Computer Science majors as well as nonmajors.

Topics: The fundamentals of database design and application development using databases: entity-relationship modeling, logical design of relational databases, relational data definition and manipulation languages, SQL; object-relational databases; query processing; physical database tuning; transaction processing.

Textbook: Raghu Ramakrishnan, Johannes Gehrke: Database Management Systems, 3rd edition, McGraw-Hill, 2002. ISBN: 0072465638. On reserve in the Science and Engineering Library.

Lectures: Tuesdays and Thursdays, 2:40-3:55 p.m., 501 Northwest Corner Building


Instructor: Prof. Luis Gravano

Instructional Assistants, Office Hours:

All instructional assistants hold their office hours in the TA/CA Room.