I use Moodle for my courses, which makes it challenging to make my
course content public. The website you see below is an automatically
generated approximation of my Moodle page, based on a script that I've
run.
General materials
- Syllabus
- Solutions to textbook Practice Exercises
Week 1
- Assignment: Introduction
- Due Wed Sep 17 12:30:00 CDT 2014
- Assignment: Relational Model
- Due Fri Sep 19 13:10:00 CDT 2014
Week 2
- Assignment: Relational Algebra
- Due Mon Sep 22 12:30:00 CDT 2014
- Assignment: SQL Part 1
- Due Wed Sep 24 13:10:00 CDT 2014
- Assignment: SQL Part 2
- Due Fri Sep 26 13:10:00 CDT 2014
Week 3
- More SQL problems
- Due Tue Sep 30 12:30:00 CDT 2014
- Entity-Relationship Modeling
- Due Wed Oct 01 12:30:00 CDT 2014
Week 4
- Design theory: analytical
- Due Mon Oct 06 12:30:00 CDT 2014
- Design theory: programming
- Due Wed Oct 08 12:30:00 CDT 2014
- The Page Organization assignment for next week is ...
- Additional reading, if interested
- Some hard drive specs from Seagate
- Some SSD specs from Samsung
- Anatomy of a Solid-state Drive
Week 5
- Exam 1 topics
- Exam 1: Monday, October 13
- Page organization, part 1
- Due Wed Oct 15 23:55:00 CDT 2014
- Page organization, part 2
- Due Sat Oct 18 23:55:00 CDT 2014
Week 6
- Buffer Manager, part 1
- Due Wed Oct 22 23:55:00 CDT 2014
- Buffer Manager, part 2
- Due Sat Oct 25 23:55:00 CDT 2014
Week 7
- Buffer Manager, part 3
- Due Mon Oct 27 23:55:00 CDT 2014
- B+ tree (individual)
- Due Sat Nov 01 23:55:00 CDT 2014
Week 8
- Extendable hashing (individual)
- Due Fri Nov 07 13:10:00 CST 2014
Week 9
- Query optimization 1, team
- Due Wed Nov 12 12:30:00 CST 2014
- Query optimization 2, individual
- Due Wed Nov 12 12:30:00 CST 2014
Week 10
- Exam 2 topics
- Exam 2: Monday, November 17
- Final paper: references
- Due Wed Nov 19 00:00:00 CST 2014
- Final paper: complete. No extensions allowed by college policy.
- Due Mon Nov 24 21:30:00 CST 2014