Course Calendar - Spring 2025
====================================

The schedule is tentative and subject to change.

+-----------------+------------+--------------------------------------------+-------------------------+
| Session         | Date       | Topic                                      | Readings                |
+=================+============+============================================+=========================+
| Week 1          | 1/7/2025   | Introduction to Database Systems and       | Chapters 1, 2.1, 2.2    |
|                 |            | Relational Data Model (2 classes)          |                         |
+-----------------+------------+--------------------------------------------+-------------------------+
| Week 2-3        | 1/14/2025  | Data Modeling - Normalization (3 classes)  | Chapter 2, 3            |
+-----------------+------------+--------------------------------------------+-------------------------+
| Week 3-4        | 1/21/2025  | Entity Relationship Models (3 classes)     | Chapter 4               |
+-----------------+------------+--------------------------------------------+-------------------------+
| Week 5          | 2/4/2025   | Catch up (1 class)                         |                         |
+-----------------+------------+--------------------------------------------+-------------------------+
| Week 5          | 2/7/2025   | Test #1                                    |                         |
+-----------------+------------+--------------------------------------------+-------------------------+
| Week 6-7        | 2/11/2025  | SQL Language (3 classes)                   | Chapter 6               |
+-----------------+------------+--------------------------------------------+-------------------------+
| Week 8          | 2/25/2025  | Constraints and Triggers (1 class)         | Chapter 7               |
+-----------------+------------+--------------------------------------------+-------------------------+
| Week 8          | 2/28/2025  | Views and Indexes (1 class)                | Chapter 8               |
+-----------------+------------+--------------------------------------------+-------------------------+
| Week 9          | 3/4/2025   | Spring Break                               |                         |
+-----------------+------------+--------------------------------------------+-------------------------+
| Week 10         | 3/11/2025  | SQL in a server environment (2 lectures)   | Course notes, Chapter 9 |
+-----------------+------------+--------------------------------------------+-------------------------+
| Week 11         | 3/18/2025  | Catch up (1 class)                         |                         |
+-----------------+------------+--------------------------------------------+-------------------------+
| Week 11         | 3/21/2025  | Test #2                                    |                         |
+-----------------+------------+--------------------------------------------+-------------------------+
| Week 12         | 3/25/2025  | Secondary Storage Management (1 class)     | Chapter 13              |
+-----------------+------------+--------------------------------------------+-------------------------+
| Week 12-13      | 3/28/2025  | Index Structures (2 classes)               | Chapter 14              |
+-----------------+------------+--------------------------------------------+-------------------------+
| Week 13         | 4/4/2025   | Query Execution (1 class)                  | Chapter 15              |
+-----------------+------------+--------------------------------------------+-------------------------+
| Week 14         | 4/8/2025   | Query Optimization (1 class)               | Chapter 16              |
+-----------------+------------+--------------------------------------------+-------------------------+
| Week 14-15      | 4/11/2025  | Transaction Management (3 classes)         | Chapters 17, 18, 19     |
+-----------------+------------+--------------------------------------------+-------------------------+
| Week 16         | 4/22/2025  | Catch up (1 class)                         |                         |
+-----------------+------------+--------------------------------------------+-------------------------+
| Finals Week     |            | Final Exam                                 |                         |
+-----------------+------------+--------------------------------------------+-------------------------+