CMPT 354 Fall 2000 - Class Schedule
Notational convention:
L1: The first lecture of a week (M )
L2: The second lecture of a week (W)
L3: The third lecture of a week (F)
-
Chapter 1. Introduction (1.5 lectures) [Week 1:L2, L3]
-
Chapter 2. The ER-Model (2.5) [Week 2:L1-L2]
-
Chapter 3. The Relational Model (3.5) [Week 2: L3, Week 3:L1-L3]
Note: Homework # 1 distribution (SQLServer7.0)
-
Chapter 4. Relational Algebra and Calculus (3.5) [Week 4: L1-L3]
Note: Homework #1 due, homework #2 distribution
-
Chapter 5. SQL: Queries, Programming, Triggers (3) [Week 5: L1, L2, L3]
-
Chapter 6. Query-by-Example (QBE) (2) [Week 6: L2, L3]
Note Week 6:L1 Thanksgiving Day
-
Chapter 7. Storing Data: Disks and Files (2.5) [Week 7:L2-L3, Week 8: L1]
Note: Midterm [Week 7: L1]
-
Chapter 8. File Organization and Indexes (2) [Week 8: L2-L3]
-
Chapter 9. Tree-Structured Indexing (3) [Week 9: L1-L3]
-
Chapter 10. Hash-Based Indexing (2) [Week 10: L1-L2]
Note: Week 10: L3 Homework #2 due
-
Chapter 11. External Sorting (2) [Week 10: L3, Week 11: L2]
Note: Week 11:L1 Remembrance Day, Week 12:L3 Homework #3 due
-
Chapter 12. Evaluation of Relational Operations(3) [Week 11:L3, Week 12:L1, L2]
-
Chapter 13. Introduction to Query Optimization (2) [Week 12: L3, Week 13, L1]
-
Chapter 14. A Typical Relational Query Optimizer (2) [Week 13: L2, L3]
-
Final Exam (Week 14)
Page maintained by: Jiawei Han
Last update: September 5, 2000