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.