Topic outline


  • Week 1 (April 2025)
    Recommended readings: U & W: 1.1-1.2, 2.1-2.2, 2.4, 6.1-6.3
    Tue 20 April
    16:15-18:00 Lecture (PDF slides)
    Model:
    Introduction to Databases and Relational Models (Prof. Nitin Sawhney)
    Theory: Introduction to Relational Algebra (Prof. Barbara Keller)
    Application: Introduction to SQL (Sami El-Mahgary)
    Wed 20 April
    10:15-12:00 Exercise session (Long and Etna)
    Thr 20 April
    10:15-12:00 Exercise session (Binh and Trang)
    Fri 20 April
    10:15-12:00 Exercise session (Sophie and Etna)
    Week 2 (April 26 – May 2) 
    Recommended r eadings: 4.7, 3.1-3.2, 2.3, 7.1-7.4, 8.1-8.2
    Mon 26 April
    18:00 Homework 1 deadline at 18:00 
    Tue 27 April
    16:15-18:00 Lecture (PDF slides)
    Model:
    UML Modeling & Relational Diagrams - Part I (Prof. Nitin Sawhney)
    Theory: Functional Dependencies & Normal Forms I (Prof. Barbara Keller)
    Application: Defining SQL Tables, Integrity Constraints and Views (Sami El-Mahgary)
    Wed 28 April
    10:15-12:00 Exercise session (Long and Etna)
    Thr 29 April
    10:15-12:00 Exercise session (Binh and Trang)
    Fri 30 April
    10:15-12:00 Exercise session (Sophie and Etna)
    Week 3 (May 3–9)
    Recommended r eadings: 4.8, 3.3-3.6, 6.4.3-6.4.7
    Mon 3 May
    18:00 Homework 2 deadline at 18:00
    Tue 4 May
    16:15-18:00 Lecture (PDF slides)
    Model:
    UML Modeling & Relational Diagrams - Part II (Prof. Nitin Sawhney)
    Theory: Functional Dependencies & Normal Forms II (Prof. Barbara Keller)
    Application: Advanced SQL and Aggregation (Sami El-Mahgary)
    Wed 5 May
    10:15-12:00 Exercise session (Long and Etna)
    Thr 6 May
    10:15-12:00 Exercise session (Binh and Trang)
    Fri 7 May
    10:15-12:00
    14:15-16:00
    Exercise session (Sophie and Etna)
    Exercise session (Binh and Trang)
    Week 4 (May 10–16)
    Recommended r eadings: U & W: 1.2.4, 6.6, 7.5, 8.1-8.4
    Mon 10 May
    18:00 Homework 3 deadline at 18:00 (extended)
    Project Part 1 deadline at 18:00 (extended)
    Tue 11 May
    16:15-18:00 Lecture (PDF slides)
    Views and Indexes
     (Prof. Nitin Sawhney)
    Transactions (Prof. Barbara Keller)
    Triggers (Prof. Nitin Sawhney)
    Wed 12 May
    10:15-12:00 Exercise session (Long and Etna)
    Wed 12 May
    18:00 Homework 3 deadline at 18:00 
    Project Part 1 deadline at 18:00

    Thr 13 May
    10:15-12:00 Exercise session (Binh and Trang) (Moved to Friday 14:15 - 16:00)
    Fri 14 May
    10:15-12:00 Exercise session (Sophie and Etna)
    Week 5 (May 17–23) 
    Recommended r eadings: A. Badia: 1.5, 3.3.2, 3.3.3, 3.4.1, 6.2.2.
    Tue 18 May
    16:15-18:00 Lecture (PDF slides)
    SQLite in Python
    (Sami El-Mahgary)

    Data Analysis using SQL Queries (Sami El-Mahgary)

    Wed 19 May
    10:15-12:00 Exercise session (Long and Etna)
    Wed 19 May
    18:00 Homework 4 deadline at 18:00 
    Thr 20 May
    10:15-12:00 Exercise session (Binh and Trang)
    Fri 21 May
    10:15-12:00 Exercise session (Sophie and Etna)
    Week 6 (May 24–30) 
    Tue 25 May
    16:15-18:00 Lecture
    Course Wrap-up
    Project Presentations & Discussion
    Wed 26 May
    10:15-12:00 Exercise session (Long and Etna)
    Wed 26 May
    18:00 Homework 5 deadline at 18:00
    Project Part 2 deadline at 18:00
    Thr 27 May
    10:15-12:00 Exercise session (Binh and Trang)
    Fri 28 May
    10:15-12:00 Exercise session (Sophie and Etna)
    Week 7 (May 31 – June 6)
    Wed 2 June
    10:15-12:00 Additional Exercise Session (Long, Sophie, and Etna)
    Fri 4 June
    18:00 Project Part 3 Deadline at 18:00
    Week 8 (June 7 – June 13)
    Mon 7 June
    18:00 Project Part 3 Deadline at 18:00
    Fri 11 June
    18:00 Project Deliverable Package Deadline at 11:00