CS 133 Lecture Slides

Topic

Date

pdf

pdf 2 per page

pdf 6 per page

Introduction and E/R Model Wed. 1/21/04 dbintro dbintro dbintro
Relational Model and Translation from E/R Wed. 1/28/04 er-rel er-rel er-rel
Functional Dependencies Mon. 2/2/04 fds fds fds
Normalization and Decomposition Wed. 2/4/04 norm norm norm
Multi-Valued Dependencies Mon. 2/9/04 mvds mvds mvds
Decomposition Wed. 2/11/04 decomp decomp decomp
Relational Algebra Mon. 2/16/04, and Wed. 2/18/04 ra ra ra
SQL, Part 1 Mon. 2/23/04 sql1 sql1 sql1
SQL, Part 2 Wed. 2/25/04 sql2 sql2 sql2
Constraints Mon. 3/01/04 constraints constraints constraints
Objects and Relations Wed. 3/03/04 oodbms oodbms oodbms
Object-Relational Mon. 3/08/04 or or or
Object-Oriented (ODMG and JDO) Mon. 3/22/04 odmg-jdo odmg-jdo odmg-jdo
Semi-Structured Data (XML) Mon. 4/05/04 xml xml xml
Logic Databases and Datalog Wed. 4/07/04 datalog datalog datalog
Authorization Mon. 4/12/04 auth auth auth
Transactions Mon. 4/12/04 trans trans trans
Concurrency Control Mon. 4/19/04 conc conc conc
Recovery Wed. 4/21/04 recover recover recover
Spatial Databases Mon. 4/26/04 spatial spatial spatial
Temporal Databases Wed. 4/28/04 temporal temporal temporal
On-Line Application Processing Wed. 4/28/04 olap olap olap

Other Class Materials

Homework