Topics covered
| Formats | Chapters in Text | Week | |
| 0. Overview | 1 | ||
| 1. Introduction | ppt, pdf | Ch. 1 | 1 |
| 2. Relational Model | ppt, pdf | Ch. 2.4, 5.1 | 2 |
| Examples | ppt, pdf | ||
| 3. Database Design: The Entity-Relationship Approach | ppt, pdf | Ch. 4.1 -- 4.6 | 2 |
| Example -- Banking | ppt, pdf | ||
| 4. SQL | ppt, pdf | Ch. 2.3, 6.1--6.3 | 3,4 |
| 5. More SQL/Relational Algebra | ppt, pdf | Ch. 5.2, 6.4, 6.5 | 5,6 |
| 6. Constraints and Triggers | ppt, pdf | Ch. 7 | 6,7 |
| 7. Transactions, Views, and Indexes | ppt, pdf | Ch. 6.6, 8 | 8 |
| 8. Authorization | ppt, pdf | Ch. 10.1 | 8 |
| 9. Introduction to SQL Programming Techniques | ppt, pdf | Ch. 9.1 -- 9.3, 9.5, 9.6 | 8,9 |
| 10. XML | ppt, pdf | Ch. 11, 12 | 9,10 |
| Example -- Banking | ppt, pdf | ||
| 11. Design Theory for Relational Databases | ppt, pdf | Ch. 3 | 11,12 |