Databases |
|
|
|
|
|
Schedule: Subject To
Change |
|
|
|
|
|
|
|
|
|
# |
Day |
Date |
Chapter |
Topics |
Due at 11:55 pm |
|
1 |
M |
9/10 |
1 |
Introduction |
|
2 |
W |
9/12 |
9 |
Storing data: disks and files |
|
3 |
F |
9/14 |
9 |
Storing data: disks and files |
|
|
4 |
M |
9/17 |
2 |
Database design, ER Model |
Warmup |
|
5 |
W |
9/19 |
2 |
Database design, ER Model |
|
6 |
F |
9/21 |
3 |
Relational Model |
|
|
7 |
M |
9/24 |
3 |
Relational Model |
|
8 |
W |
9/26 |
4 |
Relational Algebra |
Minibase 1 |
|
9 |
F |
9/28 |
4 |
Relational Algebra |
|
|
10 |
M |
10/1 |
4 |
Relational Algebra |
Problem Set 1 |
|
11 |
W |
10/3 |
5 |
SQL |
|
12 |
F |
10/5 |
5 |
SQL |
|
|
13 |
M |
10/8 |
5 |
SQL |
Minibase 2 |
|
14 |
W |
10/10 |
|
Exam 1 |
|
15 |
F |
10/12 |
8 |
Storage and indexing |
|
|
|
M |
10/15 |
|
BREAK |
|
16 |
W |
10/17 |
10 |
Tree structured indexing |
|
17 |
F |
10/19 |
10 |
Tree structured indexing |
|
|
18 |
M |
10/22 |
11 |
Hash indexing |
PostgreSQL 1 |
|
19 |
W |
10/24 |
11 |
Hash indexing |
|
20 |
F |
10/26 |
12 |
Overview of query evaluation |
|
|
21 |
M |
10/29 |
13 |
External sorting |
Problem Set 2 |
|
22 |
W |
10/31 |
14 |
Evaluation of relational
operators |
|
23 |
F |
11/2 |
15 |
Query optimization |
|
|
24 |
M |
11/5 |
15 |
Query optimization |
Minibase 3 |
|
25 |
W |
11/7 |
19 |
Schema refinement and normal
forms |
|
26 |
F |
11/9 |
19 |
Schema refinement and normal
forms |
|
|
27 |
M |
11/12 |
15 |
Transaction management |
Final assignment |
|
28 |
W |
11/14 |
15 |
Transaction management |
|
|
|
|
|
|
self or |
Su |
11/19 |
|
Exam 2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|