Carleton College

• Don't miss lots of good stuff in the "References" block, which is in the right hand column.

• News forum
• Piazza: ask and answer questions here file

January 1 - January 7

• Introductory assignment

• Introductory assignment (submit here)

• Sample hard drive specifications

• Sample solid state drive specifications

January 8 - January 14

• Buffer Manager

• Buffer Manager part 1 (submit here) Assignment
• Buffer Manager part 2 (submit here) Assignment
• Next reading: 2.1 and 2.2, due Thursday, 1/12, at 11:55 pm Forum
• Buffer Manager part 3 (submit here) Assignment

January 15 - January 21

• Page Organization

• Page Organization 1 (submit here) Assignment
• Page Organization 2 (submit here) Assignment
• Page Organization 3 (submit here) Assignment

January 22 - January 28

• Relational Algebra Due on Monday, 1/23. Due in class if submitting on paper; due by 11:55 pm if submitting electronically.

• Relational algebra (submit here) Assignment
• Sample database Excel spreadsheet

• SQL assignment

• SQL assignment part 1 (submit here)
• SQL assignment part 2 (submit here)

January 29 - February 4

• Some code in Python that makes SQL queries

• Exam 1: Wednesday, February 1 (Exam topics)

• Exam 1 grades Assignment

February 5 - February 11

• Entity-Relationship Model assignment

• Entity-Relationship Model assignment (submit here)

• Indexing assignment

• Indexing assignment (submit here)

February 12 - February 18

• B+-tree find algorithm

• B+-tree insert algorithm

• B+-tree delete algorithm

• B+ tree assignment

• B+ tree assignment, part 1 (submit here)
• B+ tree assignment, part 2 (submit here)

February 19 - February 25

• Extendable Hashing assignment

• Extendable Hashing assignment (submit here)

February 26 - March 3

• Exam 2: Monday, February 27 (Exam topics)

• Exam 2 grades Assignment
• NoSQL Better Than MySQL? file
• Scaling the Web: Databases & NoSQL file
• Overview of NoSQL file
• Query Optimization Signups Scheduler

• Query Optimization, Individual Part

• Query Optimization, Team Part

• Password for query optimization team assignment Resource
• Query Optimization, Individual Part (submit here) Assignment
• Query Optimization, Team Part (submit here) Assignment
• Class on Wednesday Resource
• Class on Friday Resource

March 4 - March 10

• Next reading: 8.4.1, 8.4.2, 8.4.5 due 3/8, at 11:55 pm Forum

March 11 - March 17

• There is no final exam or major project due during exam week. There will be some sort of normally-sized "last" assignment due during finals week.

• Design Theory Assignment (due at end of last exam: Wed, 3/14, 2:30 pm)

• Design theory assignment (submit here)
• Moodle postings Assignment