COMS W4111.001-Introduction to Databases
Spring 2017

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

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

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.
Prerequisites:
  • COMS W3134, W3136, or W3137 (equivalent courses taken elsewhere are acceptable as well) and
  • Fluency in Java (see note below on programming and nonprogramming options for projects, though).

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.
Grades:
  • 15% homework assignments (4, all equally weighted)
  • 20% projects (2): Project 1 is worth 15% of the course grade, while Project 2 is worth 5% of the course grade. Note: for the projects, you can choose between a programming option (to be done in Python) and a nonprogramming option
  • 25% midterm (closed book): Thu Mar 9, in class
  • 40% final (closed book): Thu May 11, 1:10-4 p.m.
Instructor:  Prof. Luis Gravano
Office: 706 Schapiro CEPSR
Office Hours:
  • Wednesdays, 9:30-11:30 a.m.
  • By appointment by email
Telephone: 1-212-939-7064
Email: gravano@cs.columbia.edu
Instructional Assistants Office Hours Location Email
Atif Ahmed
Tuesdays, 10 a.m.-12 n.
TA/CA Room atif.ahmed@columbia.edu
Terra Blevins
Mondays, 4:15-6:15 p.m.
TA/CA Room tlb2145@columbia.edu
Min Fan
Fridays, 2-4 p.m.
TA/CA Room mf3084@columbia.edu
Jibben Hillen
Wednesdays, 1-3 p.m.
TA/CA Room jlh2218@columbia.edu
Aayush Mudgal
Thursdays, 4-6 p.m.
TA/CA Room am4590@columbia.edu
Savvas Petridis
Wednesdays, 3-5 p.m.
TA/CA Room sdp2137@columbia.edu
Jiangfeng Wang
Fridays, 12 n-2 p.m.
TA/CA Room jw3107@columbia.edu

Luis Gravano
gravano@cs.columbia.edu