Weekly Schedule
Week 1 (April 20–25) 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 | |
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 |
||
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) |
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 |