COMP 115
Databases
Lectures
Monday and Wednesday
4:30—5:45
Sci-Tech Center, Room 136
Instructor
Jack Orenstein: jao@cs.tufts.edu
Office hours: Monday, Wednesday
3:30—4:30 (immediately before class)
Sci-Tech lobby
Resources
Piazza
Syllabus
Schedule
Teaching Assistants
Yanan Qi: yqi04@tufts.edu
Office hours: Tuesday, Thursday
10:30—12:00
Halligan Collaboration Room
Ethan Oliver: Ethan.Oliver@tufts.edu
Jason Zhang: Shukun.Zhang@tufts.edu

Announcements

  • Assignment 9: December 9.

Lectures

Lecture Download Date Title
25 Dec 9 Exam 2 Review
24 Dec 4 NoSQL Systems
23 Dec 2 Database Resilience
22 Nov 25 Concurrency Control 2
21 Nov 20 Concurrency Control 1
20 Nov 18 SQL Updates and Transactions
19 Nov 13 Stored Procedures
18 Nov 6 Writing Database Applications
17 Nov 4 Query Optimization (continued)
16 Oct 30 Query Optimization
15 Oct 28 Query Processing 2
14 Oct 23 Query Processing 1
13 Oct 16 Exam 1 Review
12 Oct 15 More on B-trees
11 Oct 9 B-trees
10 Oct 7 Storage and Indexing
09 Oct 2 Even More on SQL select
08 Sep 30 More on SQL Select
07 Sep 25 SQL Basics
06 Sep 23 Schema Design 2
05 Sep 18 Schema Design 1
04 Sep 16 Relational Algebra
03 Sep 11 The Relational Model of Data
02 Sep 9 Data Modeling
01 Sep 4 Introduction

Assignments

Assignment 1 Instructor's solution
Assignment 2 Instructor's solution
Assignment 3 Instructor's solution
Assignment 4 Instructor's solution
Assignment 5 Instructor's solution
Assignment 6 Instructor's solution
Assignment 7 Instructor's solution
Assignment 8 Instructor's solution
Assignment 9 Instructor's solution


Quizzes

Quiz answers and discussions can be found on Piazza.
Quiz 1
Quiz 2
Quiz 3
Quiz 4
Quiz 5

Exams

Exam 1 Answers
Exam 2 from Spring 2019 Answers
Exam 2 from Fall 2018 Answers

Textbook

Database Systems: The Complete Book, Second Edition
by Garcia-Molina, Ullman, Widom

You can order this book online.

Policy for late submissions

  • Assignments must be submitted by the end of the due date.
  • You have four tokens that you can use to buy extensions. Each token buys you one day.
  • You may use no more than two tokens for one assignment.
  • You must request a token from me, by email.
  • The time-consuming assignments are likely to be A2, A4, A6, A8. Use your tokens wisely.