CSE 344 Winter 2025 Schedule

January
Monday	Tuesday	Wednesday	Thursday	Friday
06 09:30-10:20 Lecture MGH 389 Syllabus; Relational Model	07	08 09:30-10:20 Lecture MGH 389 SQL SELECT-WHERE, Set builder semantics, Nested loop semantics	09 Section SQL Basics	10 09:30-10:20 Lecture MGH 389 (Inner) Joins
13 09:30-10:20 Lecture MGH 389 Outer Joins and SQL NULL	14	15 09:30-10:20 Lecture MGH 389 Database design for collections 23:59 HW1 due	16 Section Joins; Connecting to SQLite from Java	17 09:30-10:20 Lecture MGH 389 Aggregation and SQL GROUP BY
20 MLK Day	21	22 09:30-10:20 Lecture MGH 389 Combining Aggregation and Joins 23:59 HW2 due	23 Section Aggregation	24 09:30-10:20 Lecture MGH 389 Subqueries
27 09:30-10:20 Lecture MGH 389 Implementing predicate logic with subqueries	28	29 09:30-10:20 Lecture MGH 389 More subqueries 23:59 HW3 due	30 Section Subqueries	31 09:30-10:20 Lecture MGH 389 Relational Algebra

February
Monday	Tuesday	Wednesday	Thursday	Friday
03 09:30-10:20 Lecture MGH 389 Entity-Relationship (ER) modeling	04	05 09:30-10:20 Lecture MGH 389 CRUD apps 23:59 HW4 due	06 Section Relational Algebra, E-R design	07 09:30-10:20 Lecture MGH 389 Functional Dependencies
10 09:30-10:20 Lecture MGH 389 Normalization; BCNF	11	12 09:30-10:20 Midterm	13 Section TBD	14 09:30-10:20 Lecture MGH 389 TBD
17 President's Day	18	19 09:30-10:20 Lecture MGH 389 Transaction Basics 23:59 HW5 due	20 Section TBD	21 09:30-10:20 Lecture MGH 389 Transaction Serializability
24 09:30-10:20 Lecture MGH 389 TBD	25	26 09:30-10:20 Lecture MGH 389 TBD 23:59 HW6 due	27 Section TBD	28 09:30-10:20 Lecture MGH 389 TBD