Date
|
Topics
|
Slides/Lecture notes
|
Add'l resources
|
1/29
|
Intro to the class
|
Lecture1
|
|
1/31
|
Design, Modeling, Entity-relationship model.
|
Lecture 2
Homework 1
|
chap. 1
chap. 6
|
2/5
|
Entity-relationship model.
|
Lecture 3
|
chap. 6
|
2/7
|
Relational model. From ER to Relational model. Relational algebra.
|
Lecture 4
Oracle notes
|
chap. 2
chap. 6
|
2/12
|
Relational model. Queries. SQL
|
Homework 1 due.
Lecture 5
|
chap. 2
chap. 3
|
2/14
|
SQL
|
SQL assignment
Dataset for SQL assignment
Lecture 6
|
chap. 3
|
2/19
|
SQL.
|
SQL assignment part 1 due
Lecture 7
|
chap. 3,4
|
2/21
|
Integrity constraints.
|
Lecture 8
|
chap. 4
|
2/26
|
Normalization
|
SQL assignment part 2 due
Lecture 9
Answers SQL part A
|
chap. 7
|
2/28
|
Midterm 1
|
|
|
3/4
|
Normalization
|
Lecture 10
|
chap. 7
|
3/6
|
Normalization.
|
Lecture 11
Homework 2
|
chap. 7
|
3/11
|
Storage: Files
|
Note: Daylight savings time began 3/9/2008
Project phase 1
Lecture 12
|
chap. 11
|
3/13
|
Storage: Indexing/Hashing
|
Lecture 13
Homework 2 due
Midterm solutions
|
chap. 11,12
|
3/17
|
Spring Break
|
|
|
3/20
|
Spring Break
|
|
|
3/25
|
Indexing/Hashing
|
Lecture 14
BibTeX file example
|
chap. 12
|
3/27
|
Query Processing
|
Lecture 15
Sample midterm.
Answers SQL part B
|
chap. 13
|
|
4/1 |
Query processing: Join algorithms
|
Lecture 16
|
chap. 13
|
4/3
|
Midterm 2
|
|
|
4/8
|
Query processing: Join algorithms
|
Project part 1 due.
Lecture 17
Homework 3
|
chap. 13
|
4/10
|
Query optimization
|
Lecture 18
|
chap. 14
|
4/15
|
Query optimization
|
Homework 3 due
Don't forget your taxes
Lecture 19
|
www.irs.gov
|
4/17
|
Transactions. Concurrency/recovery
|
Lecture 20
|
chap. 15
|
4/22
|
Concurrency/recovery
|
Passover
Lecture 21
|
chap. 15
chap. 16
|
4/24
|
Concurrency/recovery
|
Passover
Lecture 22
|
chap. 16
|
4/29
|
Recovery
|
Lecture 23
|
chap. 17
|
5/1
|
Parallel/Distributed databases. Object-oriented/object-relational db. XML
|
Project due
Lecture 24
Homework 4
|
|
5/6
|
Warehouses, Information Retrieval, Data mining. Data federation.
|
Lecture 25
|
|
5/8
|
Recap!
|
|
|
| 5/13 |
Recap!
|
Last chance for questions/clarifications
|
|
| 5/15 | Final Exam | 8:00-10:00 am CSIC 1121 | |
