| Day | Notes | Readings |
|---|---|---|
| Week 1 (Sep 4) |
Organizational Details: ppt Chapter 1: Why Databases? ppt |
Chapter 1 |
| Week 2 (Sep 11) |
Project Statement + Introduction to Oracle ppt Database Design: ER Modeling Constructs ppt |
Chapter 2 (modified) |
| Week 3 (Sep 18) | Relational Model, ER -> Relational translation ppt Discussion: SQL DDL ppt |
Chapter 3 (modified) |
| Week 4 (Sep 25) | Relational Model: Normalization Theory ppt | Chapters 19 |
| Week 5 (Oct 2) | Relational Algebra
ppt Relational Calculus ppt |
Chapter 4 |
| Week 6 (Oct 9) | SQL Queries ppt Constraints and Triggers ppt Example code and load files for ORACLE triggers (tarred gzipped file) Example code and load files for ORACLE triggers (directory of files) |
Chapter 5 |
| Week 7 (Oct 16) | SQL Views ppt DB Application Development ppt |
Chapters 6, 7 |
| Week 8 (Oct 30) | Disks, Buffers and Files ppt File Organizations and Indexing (part 1). ppt Indexing and Workloads (part 2) ppt |
Chapters 9, 8 |
| Week 9 (Nov 6) | Tree based indexing ppt hash based indexing ppt |
Chapters 10, 11 |
| Week 10 (Nov 13) | Query Processing Algorithms (Sorting) ppt Query Processing Algorithms ppt |
Chapters 13, 12, 14 |
| Week 11 (Nov 20) | Query Plan Examples ppt
Query Optimization ppt |
Chapters 15 |
| Week 12 (Dec 4) | Transaction Management, Concurrency Control ppt | Chapters 16, 17, 18 |
| Week 13 (Dec 11) | Project Presentations | |
| Week 14 (Dec 18) | Final Exam |