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