We encourage students to engage in these reading activities, which introduce the core concepts of database systems. These activities progress from foundational models and design principles to SQL, storage, query optimization, transactions, recovery, and practical application development.
|
Week |
Topic |
Reading |
|---|---|---|
|
1 |
Introduction to Database Systems |
Chapter 1 |
|
2 |
Relational Model |
Chapter 2 |
|
3 |
Introduction to Database Design |
Chapter 6 |
|
5 |
Relational Database Design (Normalization) |
Chapter 7 |
|
5 |
SQL: Constraints and Triggers |
Chapters 3, 4, 5 |
|
6 |
SQL Queries |
Chapters 3, 4, 5 |
|
7 |
Tree-Based Indexing |
Chapters 12, 13, 14 |
|
8 |
Hash-indexing |
Chapters 12, 13, 14 |
|
9 |
Query Processing |
Chapters 15, 16 |
|
10 |
Query Optimization |
Chapters 15, 16 |
|
11 |
Transaction Processing |
Chapters 17, 18 |
|
12 |
Transaction Processing Protocols |
Chapters 17, 18 |
|
13 |
Crash Recovery |
Chapter 19 |
|
14 |
Application Design and Development |
Chapters 8, 9 |
