|
Week
|
Topics
|
Textbook
|
Notes/Slides:
Link
|
|
1
|
Part I: An Overview of Database Management, Database System
Architecture
|
1.1 - 1.7, 2.1 - 2.11
|
Ch1.ppt Ch2.ppt
|
|
2
|
An Introduction to Relational Databases, An Introduction
to SQL
|
3.1 - 3.10, 4.1 – 4.9
|
Ch3.ppt Ch4.ppt
|
|
3
|
Part II: The
Relational Model
|
5.1 – 5.8, Review
|
Ch5.ppt
|
|
4
|
Exam I
|
|
|
|
5
|
Relations, Relational Algebra
|
6.1 – 6.7, 7.1 – 7.10
|
Ch6.ppt Ch7.ppt
|
|
6
|
Relational Calculus, Integrity
|
8.1 – 8.9, 9.1 – 9.13
|
Ch8.ppt Ch9.ppt
|
|
7
|
Views
|
10.1-10.7, Review
|
Ch10.ppt
|
|
8
|
Exam II
|
|
|
|
9
|
Part III: Database Design, Functional Dependencies, Further
Normalization I
|
11.1 – 11.7, 12.1 – 12.7
|
Ch11.ppt Ch12.ppt
|
|
10
|
Further Normalization II, Semantic Modeling
|
13.1 – 13.8, 14.1 – 14.7
|
Ch13.ppt Ch14.ppt
|
|
11
|
Part IV: Transaction Management, Recovery,
Concurrency
|
15.1 – 15.9, 16.1 – 16.6, Review
|
Ch15.ppt Ch16.ppt
|
|
12
|
Exam III
|
|
|
|
13
|
Recovery Revisited, Distributed Databases
|
16.7-16.12, 21.1 – 21.8
|
Ch16.ppt distributed.ppt distributedDBMS.ppt
|
|
14
|
Part VI: Object Databases, Object/Relational
Databases
|
25.1 – 25.6, 26.1 – 26.7,
|
Object.ppt objectRelationalDBMS.ppt Ch26.ppt
|
|
15
|
The WWW and XML
|
27.1 – 27.8, Review
|
Ch27.ppt
|
|
16
|
Exam IV
|
|
|