CS430 Database Management
Summer 2012
CS430 Schedule
CS430 Information
- Instructor:
- Russ Wakefield
Office: CSB Room 240
Office Hours: T/Th 9-11
Email: waker@cs.colostate.edu - GTA:
- Xing (Jason) Xie
Office: CSB Room 120
Office Hours: Arranged by email
Email: xing@cs.colostate.edu - Lecture: Behavior Science 103
- M/W/F 10:00 - 11:10
- Labs: Done at home on garden machines
Summer Schedule
| Week | Monday Lecture | Wednesday Lecture | Friday Lecture | Lab / Homework |
|---|---|---|---|---|
| 1 | Intro to CS430dl | Intro to DBMS - Ch 1 | E/R Diagrams - Ch 2 | DA1 |
| 2 | E/R Diagramming Examples | The Relational Model - Ch 3 | ER to SQL Examples | DA2, HW1 |
| 3 | Memorial Day - no class | Relational Algebra - Ch 4 | Relational Algebra Examples | DA3, L1 |
| 4 | SQL - Ch 5 | SQL | SQL Examples | DA4, HW2, HW1R |
| 5 | Normal Forms - Ch 19 | Normal Forms | Normal Forms Examples | DA5,HW3, L1R |
| 6 | Midterm Exam Take-home | Application Development - Ch 6 | Storage and Indexing - Ch 8 | HW2R |
| 7 | Physical Storage - Ch. 9 | Tree indexing - Ch 10 | Tree indexing Examples | DA6, L2, HW3R |
| 8 | Hash indexing - Ch 11 | University Holiday | Query Overview - Ch 12 | DA7, HW4 |
| 9 | Transaction Overview - Ch 16 | Transaction Overview | Transaction Examples | DA8, L3, L2R |
| 10 | Concurrency - Ch 17 | Concurrency | Concurrency Examples | DA9, L4, HW4R |
| 11 | Recovery - Ch 18 | Recovery | Aires Examples | DA10, HW5(no regrade), L3R |
| 12 | Final Exam Take-home | Final Exam Quizzes | Coffee shop | L4R |