Topics

Unit 1: Why Representations Matter

DateTitleSlidesAssignment
Jan 27 (Tues)Intro / Information != DataSlidesN/A
Jan 29 (Thurs)Asking Questions with Fragmented InformationSlidesAssignment
Feb 3 (Tues)Information LossSlidesAssignment
Feb 5 (Thurs)Lossy vs Lossless RepresentationsSlidesAssignment

Unit 2: Conceptual Modeling

DateTitleSlidesIn-Class WorkAssignment
Feb 10 (Tues)Class CanceledN/AN/AN/A
Feb 12 (Thurs)Entities, Attributes, and RelationshipsSlidesN/AAssignment
Feb 17 (Tues)ConstraintsSlidesN/AReading & Assignment
Feb 19 (Thurs)ER Modeling WorkshopSlides Submit In-Class AssignmentReading
Feb 24 (Tues)Relational Model & SchemasSlidesN/AReading & Assignment
Feb 26 (Thurs)Rally Day (Class Canceled)N/AN/AN/A
Mar 3 (Tues)Sets and Bags (Recording on Moodle)TBDN/AReading & Assignment

Unit 3: Querying & Meaning

DateTitleSlidesAssignment
Mar 5 (Thurs)Getting started with SQL (DDL)SlidesN/A
Mar 10 (Tues)SQL DDL Continued; Intro to DMLSlidesReading
Mar 12 (Thurs)Guest Speaker: Data ManagementTBDN/A
Mar 17 (Tues)Spring Break (no classes)N/AN/A
Mar 19 (Thurs)Spring Break (no classes)N/AN/A
Mar 24 (Tues)SlidesTBDAssignment
Mar 26 (Thurs)Ship It ExerciseSlidesN/A
Mar 31 (Tues)Joins + Project IntroSlidesN/A

Unit 4: Real-World Constraints

DateTitleSlidesAssignment
Apr 2 (Thurs)Normalization | Group ContractSlidesAssignment
Apr 7 (Tues)Working with ChecksNone (See .ipynb on Moodle)N/A
Apr 7 (Tues)Implementing Checks and TriggersSlidesN/A
Apr 14 (Tues)Working Day: Meet with Stakeholders (not meeting in Seelye)NoneNone
Apr 16 (Thurs)Working Day: Check in with group + Halie about your proposal (not meeting in Seelye because of heat)TBDN/A

Unit 5: Optimization

DateTitleSlidesAssignment
Apr 21 (Tues)Transactions & Concurrency (+ group work)Slides</td>N/A
Apr 23 (Thurs)Disk Storage (+ group work)Slides</td>N/A
Apr 28 (Tues)Indexing (+ group work)SlidesN/A
Apr 30 (Thurs)Databases & Computer Systems | Semester Wrap-UpTBDN/A