COMP 115
Databases
Lectures
Tuesday and Thursday
6:00—7:15
Anderson 212
Instructor
Jack Orenstein: jao@cs.tufts.edu
Office hours: Tuesday, Thursday
5:00—6:00 (immediately before class)
SEC 327
Resources
Piazza
Syllabus
Schedule
Teaching Assistants
Matthew Ahrens: matt.p.ahrens@gmail.com
Office hours: Tuesday, Wednesday, 11:30—1:00
TA rooms or Halligan Kitchen

Announcements

Review before 2nd exam

  • In December 6 class.

  • Prepare questions ahead of time.

  • Email, Piazza.

  • Questions brought to class get LOWEST PRIORITY.

Assignments

  • Assignment 8 is due December 6.

  • Assignment 9 is due December 10.

    Lectures

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


    Textbook

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

    Policy for late submissions

    10% penalty per day.

    Exams



    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