Collaboration and Academic Honesty | Project Policies | Project 1 Contest | CourseWorks and Ed Discussion Board | Announcements | Lecture Schedule and Readings | Project 1: Part 1, Part 2, Part 3 | Project 2 | Grading Statistics

Course Description: The course covers what a database system is, how to design databases effectively and in a principled manner, how to query databases, and how to develop applications using databases: entity-relationship modeling, logical design of relational databases, relational algebra, SQL, database application development, database security, and an overview of query optimization and transaction processing.

Prerequisites:

• COMS W3134, W3136, or W3137 (equivalent courses taken elsewhere are acceptable as well)

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 (optional): Avi Silberschatz, Henry F. Korth, S. Sudarshan: Database System Concepts, Seventh Edition, McGraw-Hill, 2019. ISBN: 9780078022159

Lectures: Tuesdays and Thursdays, 11:40 a.m.-12:55 p.m. ET, at TBD

Grades:

• 50% projects (2): Project 1 is worth 40% of the course grade, while Project 2 is worth 10% of the course grade. Project 1 involves programming in Python.
• 20% midterm: TBD, during lecture time (closed book, closed notes)
• 30% final: TBD (cumulative; closed book, closed notes)

Instructor: Prof. Luis Gravano (pronouns: he, him)

• Office Hours:
  • Tuesdays, 2:00-3:00 p.m. ET: in person at 507 Uris
  • Thursdays, 2:00-3:00 p.m. ET: in person at 507 Uris
  • By appointment by email
• Email: gravano@cs.columbia.edu

Instructional Assistants:

• TBD

The full office hours schedule, including links for online office hours and locations for in-person office hours, will be available in a Google Calendar. You will soon find the link to the Google Calendar in an Announcement on CourseWorks.