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: Introduction to Relational Algebra |
L05: Relational Algebra |
N/A |
| 4: June 1-5 |
L06: Relational Algebra |
L07: Relational Algebra |
N/A |
| 5: June 8–12 |
L08: Relational Algebra |
L09: Introduction to SQL |
A01 is available |
| 6: June 15–19 |
L10: SQL |
L11: SQL Definition |
A01 is due (2026-06-19, 11:59 PM) |
| 7: June 22-26 |
L12: SQL Definition |
L13: SQL Query |
Mid-Term Exam (2026-06-25, 16:30-18:20 in STC 1012) |
| 8: June 29–July 3 |
L14: SQL Exercises |
N/A |
A02 is available |
| 9: July 6–10 |
L15: SQL Modification L15: Advanced SQL |
L16: SQL Exercises |
A02 is due (2026-07-10, 11:59 PM) |
| 10: July 13–17 |
L17: Entity Relationship Diagrams |
L18: Mapping |
A03 is available |
| 11: July 20–24 |
L19: Normalization |
L20: Normalization |
A03 is due (2026-07-24, 11:59 PM) A04 is avaialble |
| 12: July 27–31 |
L21: Normalization |
L22: Normalization |
N/A |
| 13: Aug 4-5 |
L23: Storage and RAID |
L24: Transactions |
A04 is due (2026-08-05, 11:59 PM) |