| |
Chapter (4th ed) |
Chapter (5th ed) |
Chapter (6th ed) |
Lecture Topic |
Notes |
Slides |
Discussion Handouts |
| 1 |
1.1-2, 1.6-10 |
1.1-2, 1.8-13 |
1.1-2, 1.7-13 |
Introduction |
|
|
|
| 2 |
1.3-5, 3.1, 4.11 |
1.3-7, 2.1, 3.1-2, 4.1 |
1.3-6, 2.1-5, 3.1-2, 4.5 |
Relational Model |
Notes | PPT, PDF |
|
| 3 |
3.2 |
2.2-3 |
6.1-6.1.3.3 |
Relational Algebra |
Notes | PPT, PDF |
|
| 4 |
4.1-3 |
3.1-4 |
3.1-5 |
Basic SQL |
Notes | PPT, PDF |
Slides (practice) |
| 5 |
4.4-6, 4.8-10 |
3.5-8, 3.10-11 |
3.6-9, 4.1, 4.3 |
More SQL |
|
|
|
| 6 |
6.1-4 |
4.2, 8.6 |
4.4, 5.3 |
Constraints & Triggers |
Notes | PPT, PDF |
|
| 7 |
4.7, 6.5-6 |
3.9, 3.10.4, 4.3, 8.7 |
4.2, 4.6 |
Views & Authorization |
Notes |
|
|
| 8 |
11.1-2, 11.5-7 |
11.1-2, 11.5-7 |
10.1-2, 10.5-6, 10.8 |
Disks & Files |
Notes | PPT, PDF |
|
| 9 |
12.1-3 |
12.1-3 |
11.1-4 |
Indexing (ISAM, B+tree) |
Notes | PPT, PDF |
|
| 10 |
12.5-8, 12.9.1-2 |
12.6-8, 12.10, 12.5.1-2 |
11.5.1-2, 11.6-8, 11.10 |
Indexing (B+tree, Extendible hashing) |
|
|
|
| 11 |
13.1-13.6 |
13.1-13.6 |
12.1-12.6 |
Join Algorithms |
Notes | PPT, PDF |
|
| 12 |
13.1-13.6 |
13.1-13.6 |
12.1-12.6 |
Join Algorithms (cont.) |
|
|
|
| 13 |
2.1-9 |
6.1-10 |
7.1-10** |
ER Model & ER to RDB |
Notes | PPT, PDF |
|
| 14 |
7.1-6, 7.8, 7.10 |
7.1-6, 7.8 |
8.1-6, 8.8 |
FD, BCNF, Decomposition |
Notes | PPT, PDF |
|
| 15 |
7.1-6, 7.8, 7.10 |
7.1-6, 7.8 |
8.1-6, 8.8 |
MVD, 4NF |
|
|
|
| 16 |
15 |
15 |
14 |
Transaction (Serializability) |
Notes | PPT, PDF |
|
| 17 |
16.1, 17.1-4, 17.6 |
16.1, 17.1-5 |
15.1, 16.1-5 |
Transaction (Locking and logging) |
|
|
|
| 18 |
16.7-8 |
16.7-8 |
15.8-9 |
Transaction (Isolation levels) |
|
|
|