Lecture Slides

# Date Topic Slide Note
0 8.31 Course Overview [Download PDF]
1 8.31 Ch1: Overview of DB Systems [Download PDF]
2 9.2 Ch2: ER-diagram [Download PDF]
3 9.7 Ch2: ER-diagram (UML) [Download PDF]
4 9.9 Ch4: The Relational Algebra [Download PDF]
5 9.14 Ch4: The Relational Algebra [Download PDF]
6 9.16 Ch3: Relational Model and SQL DDL [Download PDF] Functional Spec Due
7 9.21 Ch5: SQL DML [Download PDF]
8 9.23 Web Programming [Download PDF]
[Download PDF]
9 9.28 Ch5: SQL DML [Download PDF]
10 9.30 Ch5: Relational Calculus
Ch8,9: Storage and Indexing
[Download PDF]
11 10.5 Ch8,9: Storage and Indexing [Download PDF]
12 10.12 Ch8,9: Storage and Indexing [Download PDF]
13 10.14 Ch10: Tree Indexes [Download PDF]
14 10.19 Ch10: Hash Indexes [Download PDF] Minibase Project #1 Due
15 10.21 Ch12-14: Query Evaluation [Download PDF]
M 10.30 MIDTERM EXAM
16 11.2 Ch12-14: Query Evaluation [Download PDF]
AF 11.4 UNISTAR Festival (Query Evaluation) Design Spec Due
17 11.9 Ch19: Functional Dependency and Normal Forms [Download PDF]
18 11.11 Ch15: Query Optimization [Download PDF] Minibase Project #2 Due
19 11.16 Ch16: Transaction Management [Download PDF]
20 11.17 Ch17: Concurrency Control [Download PDF]
21 11.23 Ch 17: Concurrency Control [Download PDF]
22 11.25 Ch 17: Concurrency Control [Download PDF] Minibase Project #3 Due
23 11.30 PL/SQL [Download PDF] Final Report Due
24 12.2 Ch 27: Web Search Engine [Download PDF]
25 12.7 Ch 28: Spatial Data Management [Download PDF]
26 12.9 Final Exam

You need Acrobat Reader to read a pdf file - Donwload Acrobat Reader



Link :