| Date |
Topic |
Reading (4th Edition)
|
| T, January 8 |
Organizational Issues, Introduction |
Handout; Chapter 1 |
| R, January 10 |
Entity-Relationship Model |
Chapter 2 |
| T, January 15 |
Entity-Relationship Model, emphasis on relationship type
constraints (min,max) |
Chapter 2 |
| R, January 17 |
Relational Model |
Chapter 3 |
| T, January 22 |
Relational Model and Algebra |
Chapter 3 |
| R, January 24 |
Relational Algebra |
Chapter 3 |
| T, January 29 |
SQL |
Chapter 4, SQL Tutorial |
| R, January 31 |
SQL |
Chapter 4, SQL Tutorial |
| T, February 5 |
SQL |
Chapter 4, SQL Tutorial |
| R, February 7 |
SQL |
Chapter 4, SQL Tutorial |
| T, February 12 |
Data Modifications, Views,
Integrity Constraints |
Sections 4.7,4.11,4.12 |
| R, February 14 |
MIDTERM |
MIDTERM |
| T, February 19 |
Integrity constraints, triggers |
Sections 6.3, 6.4 |
| R, February 21 |
Triggers (examples), Start with Storage and File Structures |
Sections 11.1, 11.2, 11.4-6 |
| T, February 26 |
Storage and File Structures; Start with Indexing |
Sections 11.1, 11.2, 11.4-6, 12.1 |
| R, February 28 |
Indexing |
Sections 12.2, 12.3, 12.4, 12.10 |
| T, March 4 |
Query Processing and Optimization |
Sections 13.1, 13.2, 13.3 |
| R, March 6 |
Query Processing and Optimization |
Sections 13.4-13.7, 14.1-14.4 |
| T, March 11 |
Transaction Processing |
Sections 15.1-15.5 |
| R, March 13 |
Transaction Processing, System Architecture |
Sections 15.1-15.5, 16.1, Handouts chapter 10 |
| S, March 22 (6pm-8pm) |
FINAL EXAM |
FINAL EXAM |