|
CHum 240 Class Schedule
Fall 2007 |
||||
| Day | Date | Topic | Assignment | Due |
|---|---|---|---|---|
| 1 | Tu. Sep. 4 |
Introductions
Databases Overview | -- | -- |
| 2 | Th. Sep. 6 |
Database History
Flat-files | Flat-file HW | Tu. Sep. 11 |
| 3 | Tu. Sep. 11 | Relational Databases | -- | -- |
| 4 | Th. Sep. 13 |
SQL
Select | Select HW | Tu. Sep. 18 |
| 5 | Tu. Sep. 18 |
SQL
Create Table Insert Update Delete | -- | -- |
| 6 | Th. Sep. 20 |
Natural Joins
Aliases Left & Right Joins | Joins HW (bye) | Tu. Sep. 25 |
| 7 | Tu. Sep. 25 |
Aggregates Grouping Having Null | -- | -- |
| 8 | Th. Sep. 27 |
Keys
Indexes | Grouping HW | Tu. Oct. 2 |
| 9 | Tu. Oct. 2 |
Review Exam Prep. | -- | -- |
| 10 | Th. Oct. 4 |
Exam 1 (SQL) | Design HW | Tu. Oct. 9 |
| 11 | Tu. Oct. 9 |
Quiz DB Design Normalization De-normalization | Quiz DB HW | Th. Oct. 11 |
| 12 | Th. Oct. 11 |
Integrity Constraints Foreign Keys Triggers | -- | -- |
| 13 | Tu. Oct. 16 | Quiz DB Design (conclusion) | -- | -- |
| 14 | Th. Oct. 18 |
FAQ Project | Project 1 | Th. Oct. 25 |
| 15 | Tu. Oct. 23 | FAQ Project Help Session | -- | -- |
| 16 | Th. Oct. 25 | FAQ Project Presentations | -- | -- |
| 17 | Tu. Oct. 30 | Library Project | Library Project | Th. Nov. 13 |
| 18 | Th. Nov. 1 |
Embeded SQL (PHP, Revolution, Java, etc.) Library Project Help Session | -- | -- |
| 19 | Tu. Nov. 6 |
Representing Hierarchies Library Project Help Session | -- | -- |
| 20 | Th. Nov. 8 | Library Project Help Session | -- | -- |
| 21 | Tu. Nov. 13 | Library Project Presentations | -- | -- |
| 22 | Th. Nov. 15 |
Exam 2 (design) | -- | -- |
| 23 | Tu. Nov. 20 |
Virtual Friday (no class) | -- | -- |
| 24 | Th. Nov. 22 | Thanksgiving Holiday! | -- | -- |
| 25 | Tu. Nov. 27 |
MySQL PHPMyAdmin String Functions (MySQL) Date Time Functions (MySQL) Project 3 | Project 3 | Tu. Dec. 11 |
| 26 | Th. Nov. 29 | Project 3 Help Session | -- | -- |
| 27 | Tu. Dec. 4 | Project 3 Help Session | -- | -- |
| 28 | Th. Dec. 6 | Project 3 Help Session | -- | -- |
| 27 | Tu. Dec. 11 | Project 3 Presentations | -- | -- |
| 28 | Th. Dec. 13 | Review for Final Exam | -- | -- |
| 29 | Th. Dec. 20 | Final Exam | -- | -- |