COMP 115 Databases, Fall 2019
COMP 115
Databases
Lectures
Monday and Wednesday
4:30—5:45
Sci-Tech Center, Room 136
Instructor
Jack Orenstein:<br>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<br>Download<br>Date<br>Title
25<br>↓<br>Dec 9<br>Exam 2 Review
24<br>↓<br>Dec 4<br>NoSQL Systems
23<br>↓<br>Dec 2<br>Database Resilience
22<br>↓<br>Nov 25<br>Concurrency Control 2
21<br>↓<br>Nov 20<br>Concurrency Control 1
20<br>↓<br>Nov 18<br>SQL Updates and Transactions
19<br>↓<br>Nov 13<br>Stored Procedures
18<br>↓<br>Nov 6<br>Writing Database Applications
17<br>↓<br>Nov 4<br>Query Optimization (continued)
16<br>↓<br>Oct 30<br>Query Optimization
15<br>↓<br>Oct 28<br>Query Processing 2
14<br>↓<br>Oct 23<br>Query Processing 1
13<br>↓<br>Oct 16<br>Exam 1 Review
12<br>↓<br>Oct 15<br>More on B-trees
11<br>↓<br>Oct 9<br>B-trees
10<br>↓<br>Oct 7<br>Storage and Indexing
09<br>↓<br>Oct 2<br>Even More on SQL select
08<br>↓<br>Sep 30<br>More on SQL Select
07<br>↓<br>Sep 25<br>SQL Basics
06<br>↓<br>Sep 23<br>Schema Design 2
05<br>↓<br>Sep 18<br>Schema Design 1
04<br>↓<br>Sep 16<br>Relational Algebra
03<br>↓<br>Sep 11<br>The Relational Model of Data
02<br>↓<br>Sep 9<br>Data Modeling
01<br>↓<br>Sep 4<br>Introduction
Assignments
Assignment 1<br>Instructor's solution
Assignment 2<br>Instructor's solution
Assignment 3<br>Instructor's solution
Assignment 4<br>Instructor's solution
Assignment 5<br>Instructor's solution
Assignment 6<br>Instructor's solution
Assignment 7<br>Instructor's solution
Assignment 8<br>Instructor's solution
Assignment 9<br>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<br>Answers
Exam 2 from Spring 2019<br>Answers
Exam 2 from Fall 2018<br>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.<br>You have four tokens that you can use to buy extensions. Each token buys you one day.<br>You may use no more than two tokens for one assignment.<br>You must request a token from me, by email.<br>The time-consuming assignments are likely to be A2, A4, A6, A8. Use your tokens wisely.