This course is being reintroduced to the CS curriculum after a 7-year hiatus. As this is a new course with a new professor, this semester will have some bumps, so please be patient. If are you uncomfortable with that fact that the syllabus/schedule is likely to alter, you may not want to take this course in the current semester. I will make every effort to ensure that is a smooth semester; please contact me if you would like to discuss this in detail.
This syllabus is a living document; please be aware that many elements on this page will change throughout the semester, including the course schedule. It is the student's responsibility to review this page periodically for updates.
I value any and all student feedback. If you would like to provide anonymous course feedback, use this submission form here. Please be constructive in any comments so that I can adjust the course as best possible.
For the reading assignments the section numbers are inclusive, so "1.1-1.1.2" means you should read all the sections from 1.1 up to and including section 1.1.2. This is a tentative schedule, it will change as we go.
|WEEK||DAY||ANNOUNCEMENTS||TOPIC & READING||LAB|
|1||Jan 21||Introduction to Databases;
|2||Jan 28||Data Storage and Buffer Management
||Lab 0: Binary I/O Warm-up|
|Jan 30||Drop/Add ends (Jan 31)|
|3||Feb 04||Lab 1: Buffer Manager|
|4||Feb 11||ER Model
|5||Feb 18||Relational Model
||Lab 2: Homework - Disks, Buffers, ER Models|
|6||Feb 25||Relational Algebra
||Lab 3: Heap Page|
|7||Mar 04||Lab 4: Homework - Relational Models, Relational Algebra|
|Mar 06||No class|
Midterm (In class) 2:40pm–4:40pm Sci 128
||Lab 5 warm-up exercise|
|9||Mar 25||Lab 5: B+ Tree Index|
|Mar 27||CR/NC and Withdraw
deadline (Mar 28)
|12||Apr 15||Sorting; Query Evaluation
||Lab 6: Homework - Indexing, SQL, Sorting|
|13||Apr 22||Query Optimization
||Lab 7 warm-up exercise|
||Lab 7: SwatMovie Database|
Final 2:00pm–5:00pm Sci 199