| 1 |
2025-09-01 (一) |
|
|
| Ch 0. Course Overview |
|
|
|
| (Slides |
Recordings) |
2025-09-04 (四) |
|
| Ch 1. Introduction |
|
|
|
| Ch 2. Introduction to the Relational Model |
|
|
|
| (Slides |
Recordings) |
Assignment 0: Signing Honor Code (Due: Wed, 09/10) |
|
| 2 |
2025-09-08 (一) |
|
|
| Ch 2. Introduction to the Relational Model |
2025-09-11 (四) |
|
|
| Ch 3. Introduction to SQL |
Course ADD/DROP Finalization (Due: Fri, 09/12) |
|
|
| 3 |
2025-09-15(一) |
|
|
| Ch 3. Introduction to SQL |
2025-09-18(四) |
|
|
| Ch 3. Introduction to SQL |
|
|
|
| Ch 4. Intermediate SQL |
Final Project - Part 1: Team Up & Ideation (Due: Wed, 09/17) |
|
|
| 4 |
2025-09-22(一) |
|
|
| Ch 4. Intermediate SQL |
2025-09-25(四) |
|
|
| Ch 4. Intermediate SQL |
Assignment 1: Apply SQL on real-world datasets (Due: Wed, 10/15) |
|
|
| 5 |
2025-09-29(一) |
|
|
| Ch 6. Database Design Using The E-R Model |
2025-10-02(四) |
|
|
| Ch 6. Database Design Using The E-R Model |
|
|
|
| 6 |
2025-10-06(一) |
|
|
| Ch 6. Database Design Using The E-R Model |
2025-10-09(四) |
|
|
| Ch 7. Relational Database Design - Normalization |
|
|
|
| 7 |
2025-10-13(一) |
|
|
| Ch 7. Relational Database Design - Normalization |
2025-10-16(四) |
|
|
| Ch 7. Relational Database Design - Normalization |
|
|
|
| 8 |
2025-10-20(一) |
|
|
| (No Onsite Class) Dennis Travel to Conference (CSCW) |
|
|
|
| Ch 7. Relational Database Design - Normalization |
2025-10-23(四) |
|
|
| (No Onsite Class) Dennis Travel to Conference (CSCW) |
|
|
|
| Ch 7. Relational Database Design - Normalization |
Final Project - Part 2: TBA (Due: TBA) |
|
|
| 9 |
2025-10-27(一) |
|
|
| Ch 7. Relational Database Design - Normalization |
**2025-10-30(四) |
|
|
| Midterm** |
|
|
|
| 10 |
2025-11-03(一) |
|
|
| Ch 7. Relational Database Design - Normalization |
2025-11-06(四) |
|
|
| Ch 12. Physical Storage Systems |
|
|
|
| 11 |
2025-11-10(一) |
|
|
| Ch 12. Physical Storage Systems |
2025-11-13(四) |
|
|
| Ch 13. Data Storage Structures |
Assignment 2: Create your first database - applying E-R Model & Relational Model (Due: TBA) |
|
|
| 12 |
2025-11-17(一) |
|
|
| Ch 13. Data Storage Structures |
2025-11-20(四) |
|
|
| Ch 14. Indexing |
|
|
|
| 13 |
2025-11-24(一) |
|
|
| Ch 14. Indexing |
2025-11-27(四) |
|
|
| Ch 14. Indexing |
|
|
|
| Ch 15. Query Processing |
|
|
|
| 14 |
2025-12-01(一) |
|
|
| Ch 15. Query Processing |
2025-12-04(四) |
|
|
| Ch 16. Query Optimization |
|
|
|
| 15 |
2025-12-08(一) |
|
|
| Ch 16. Query Optimization |
2025-12-11(四) |
|
|
| Wrap-Up |
Course withdrawal (Due: 11/28) |
|
|
| 16 |
**2025-12-15(一) |
|
|
| (NO CLASS, FINAL STUDY WEEK)** |
**2025-12-18(四) |
|
|
| Final Exam** |
Final Project - Part 3: Final Submission (Due: 12/14) |
|
|