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 2DA1
2 E/R Diagramming Examples The Relational Model - Ch 3 ER to SQL ExamplesDA2, HW1
3 Memorial Day - no class Relational Algebra - Ch 4 Relational Algebra ExamplesDA3, L1
4 SQL - Ch 5 SQL SQL ExamplesDA4, HW2, HW1R
5 Normal Forms - Ch 19 Normal Forms Normal Forms ExamplesDA5,HW3, L1R
6 Midterm Exam Take-home Application Development - Ch 6 Storage and Indexing - Ch 8HW2R
7 Physical Storage - Ch. 9 Tree indexing - Ch 10 Tree indexing ExamplesDA6, L2, HW3R
8 Hash indexing - Ch 11 University Holiday Query Overview - Ch 12DA7, HW4
9 Transaction Overview - Ch 16 Transaction Overview Transaction ExamplesDA8, L3, L2R
10 Concurrency - Ch 17 Concurrency Concurrency ExamplesDA9, L4, HW4R
11 Recovery - Ch 18 Recovery Aires ExamplesDA10, HW5(no regrade), L3R
12 Final Exam Take-home Final Exam Quizzes Coffee shopL4R