This table will be updated after each lecture to reflect what really happened in class. Reading assignments are from Database Management Systems, Third Edition by Ramakrishnan and Gehrke unless indicated otherwise.
| Week | Date | Lecture Notes [Reading] | Handouts, Problem Sets |
|---|---|---|---|
| 1 | 2/23, T | L1, Course overview and introduction to data management [chapter 1] | Syllabus |
| 2/25, H | L2, Introduction to data management (cont.) | ||
| 2 | 3/2, T | L3, MySQL, JDBC Demo [notes] | |
| 3/4, H | L4, DBMS (Peeking under the hood) [Chapter 1, notes] | PS 1 [Given] [FAQ] (Due: 3/16) | |
| 3 | 3/9, T | L5, Peeking under the hood (cont.) | |
| 3/11, H | L6, JDBC [6.2, 6.3] | ||
| 4 | 3/16, T | L7, Database design using ER Data Model [2] | |
| 3/18, H | L8, The Relational Model [3] | PS 2 [FAQ] (Due: 3/28) | |
| 5 | 3/23, T | L9, The Relational Model (cont.) | |
| 3/25, H | L10, The Relational Model (cont.) | PS 3 [FAQ] (Due: 4/7) | |
| 6 | 3/30, T | L11, Relational Algebra and Relational Calculus [4] | |
| 4/1, H | L12, SQL: Queries, Constraints, Triggers [5] | ||
| 7 | 4/6, T | L13, SQL: Queries, Constraints, Triggers (cont.) | |
| 4/8, H | L14, DB app development [6] | PS 4 [FAQ] (Due: 4/22) | |
| 8 | 4/13, T | L15, DB app development (cont.) Client-side scripting [ HTML tutorial ] [ CSS tutorial ] | |
| 4/15, H | L16, Flask [Grinberg: 1, 2] | ||
| 9 | 4/20, T | L17, Templates and forms [Grinberg: 3, 4] | |
| 4/22, H | L18, Databases with Flask [Grinberg: 5] | PS 5 [FAQ] (Due: 5/4) | |
| 10 | 4/27, T | L19, Schema refinement and normal forms [19] | |
| 4/29, H | Midterm Exam | ||
| 11 | 5/4, T | L21, Adjustment Day (no class) | |
| 5/6, H | L22, Adjustment Day (no class) | PS 6 [FAQ] (Due: 5/21) | |
| 12 | 5/11, T | L23, Schema refinement (cont.) | Final Project [FAQ] (Due: 11:59pm, Thursday, June 10, KST) |
| 5/13, H | L24, Storage and indexing [8] | ||
| 13 | 5/18, T | L25, Storage and indexing (cont.) | |
| 5/20, H | L26, Query evaluation [12] | PS 7 [FAQ] (Due: 5/29) | |
| 14 | 5/25, T | L27, Query evaluation (cont.), Transaction management [16] | |
| 5/27, H | L28, Transaction management (cont.) | PS 8 [FAQ] (Due: 6/7) | |
| 15 | 6/1, T | L29, Final project presentations | |
| 6/3, H | L30, Final project presentations | ||
| 16 | 6/8, H | Reading Day (no class) | |
| 17 | 6/17, H | Final (12:30-3:00pm) |