2020/11/14 ...
I've updated the schedule for the remainder of class,
including logistics for the final exam. There won't be
a reading assignment or an online session for Week 14; we
will wrap up in class. The online session for Week 13 will
go up today and be a bit shorter than usual.
Homework 8 is available and due at the end of the week.
It's a short practice on the ideas we saw in Week 13.
| Week | Date | Topic | Reading | In Class | Online | Assignment |
|---|---|---|---|---|---|---|
| 1 | 08/17-8/21 | Introduction to the course | . | notes | notes | . |
| 2 | 08/24-08/28 | Conceptual and relational data models | DB Design Ch. 7 | notes | notes | . |
| 3 | 08/31-09/04 | Conceptual and relational data models | DB Design Ch. 8 | notes | . | Homework 1 |
| 4 | 09/07-09/11 | Conceptual and relational data models | DB Design Ch. 8 | notes | notes | Homework 2 |
| 5 | 09/14-09/18 | Introduction to SQL and SQLite | . | online 1 | online 2 | . |
| 6 | 09/21-09/25 | Relational DB theory and programming | . | notes | exam | . |
| 7 | 09/28-10/02 | Relational DB theory and programming | . | notes | notes | Homework 3 |
| 8 | 10/05-10/09 | Relational DB theory and programming | Mastering RDB Ch. 2, Ch. 3 | notes | notes | Homework 4 |
| 9 | 10/12-10/16 | SQL programming | Mastering RDB Ch. 4, Ch. 5 | online 1 | online 2 | Homework 5 |
| 10 | 10/19-10/23 | SQL programming | Mastering RDB Ch. 6, Ch. 7 | notes | notes | Homework 6 |
| 11 | 10/26-10/30 | Database design | DB Design Ch. 11, Ch. 12 | notes | notes | . |
| 12 | 11/02-11/06 | Database design | . | notes | exam | Homework 7 |
| 13 | 11/09-11/13 | More complex SQL programs | . | notes | notes | Homework 8 |
| 14 | 11/16-11/20 | Course wrap-up | . | notes | . | . |
Our final exam period is Saturday, November 21, from 1:00-2:50 PM. The exam will be administered in person. Students in the Tuesday section: report to 322 ITTC. Students in the Thursday section: report to 328 ITTC. Sit in your assigned seats.