Announcements

The Carleton Sentinel is our departmental email newsletter. It contains news about job opportunities in computer science, courses you may want to take, departmental events, and whatever else we think may be relevant. If you're not a subscriber, please subscribe! Go to the email list home page, click Subscribe, and enter your email address. Make sure that you aren't using some fancy spam filtering mechanism that looks for brackets in the subject line: you'll miss both this newsletter and course emails.

Week 1

Introduction Assignment: Due by 4:30 pm on Tuesday, 1/5.
Textbook reading: Sections 1.1 and 1.2.
Textbook reading: Sections 11.1, 11.2, 11.5, 11.6.
Buffer Manager Part 1: Due by 2:20 pm on Friday, 1/8.

Week 2

Buffer Manager Part 2: Due by 1:50 pm on Monday, 1/11.
Buffer Manager Part 3: Due by 1:50 pm on Wednesday, 1/13.
Textbook reading: Sections 2.1 and 2.2.
Page Organization Part 1: Due by 2:20 pm on Friday, 1/15.

Week 3

Page Organization Part 2: Due by 1:50 pm on Monday, 1/18.
Textbook reading: Sections 2.3.
Optional skimming, if you're curious: A relational model of data for large shared data banks, by E.F. Codd
Page Organization Part 3: Due by 1:50 pm on Wednesday, 1/20.
Exam 1: In class on Friday, 1/22.

Week 4

Relational Algebra: Due on paper at the beginning of class on Wednesday, 1/27.
SQL Part 1: Due by 2:25 pm on Friday, 1/29.

Week 5

SQL Part 2: Due by 1:50 pm on Monday, 2/1.
Textbook reading: Sections 6.1-6.7.
Database design: Due by 2:20 pm on Friday, 2/5.

Week 6

Textbook reading: Sections 12.1 and 12.2.
Indexing: Due by 1:50 pm on Wednesday, 2/10.
Exam 2: In class on Friday, 2/12.

Week 7

Textbook reading: Sections 12.3, 12.4, and 12.5
B⁺-trees Part 1: Due by 11:55 pm on Friday, 2/19.

Week 8

B⁺-trees Part 2: Due by 11:55 pm on Monday, 2/22.
Textbook reading: Sections 12.6, 12.7, and 12.8

Week 9

Extendable hashing: Due in class on Monday, 3/1.
Sign up to do the team part of the query optimization assignment.: You can do your slot next week, but sign up for a slot by Monday, 3/1.

Week 10

Query Optimization, individual part and team part.: Both due in class on Monday, 3/8.
Exam 3: In class on Wednesday, 3/10.

Finals Week

Transactions and Design Theory: Due by 3:00 pm on Monday, 3/15.