The instructor will adjust this schedule as required.
There will be a Final Exam during the Final Exam period, which will cover the entire course.
| Week | Lectures | Crowdmark Assignments and Exams | |
|---|---|---|---|
| Part 1 | Part 2 | ||
| 1: May 11–15 |
L01: Course overview L02: Introduction to Databases |
L02: Introduction to Databases |
N/A |
|
2: May 18-22 |
N/A |
L03: Relational Databases |
N/A |
|
3: May 25–29 |
L04: Relational Algebra and Calculus - Part 1 |
L05: Relational Algebra and Calculus - Part 2 |
N/A |
| 4: June 1-5 |
L06: Relational Algebra and Calculus - Part 3 |
L07: Relational Algebra and Calculus - Part 4 |
N/A |
| 5: June 8–12 |
L08: Relational Algebra and Calculus - Part 5 |
L09: SQL Data Manipulation Part 1 |
A01 is available |
| 6: June 15–19 |
L10: SQL Data Manipulation Part 2 |
L11: SQL Data Manipulation Part 3 |
A01 is due (2026-06-19, 11:59 PM) |
| 7: June 22-26 |
L12: SQL Data Manipulation Part 4 |
L13: SQL Definition and Modification - Part 1 |
Mid-Term Exam (2026-06-25, 16:30-18:20 in STC 1012) |
| 8: June 29–July 3 |
L14: SQL Definition and Modification - Part 2 |
N/A |
A02 is available |
| 9: July 6–10 |
L15: Entity Relationship Diagrams |
L16: Mapping ERD to Relational Data Model |
A02 is due (2026-07-10, 11:59 PM) |
| 10: July 13–17 |
L17: Normalization - Part 1 |
L18: Normalization - Part 2 |
A03 is available |
| 11: July 20–24 |
L19: Transaction |
L20: Storage and Indexing - Part 1 |
A03 is due (2026-07-24, 11:59 PM) A04 is avaialble |
| 12: July 27–31 |
L21: Storage and Indexing - Part 2 |
L22: Storage and Indexing - Part 3 |
N/A |
| 13: Aug 4-5 |
L23: TBD |
L24: TBD |
A04 is due (2026-08-05, 11:59 PM) |