|15%||Four equally weighted homework assignments.|
|20%||Two project assignments: Project 1 is worth 15% and Project 2 is worth 5%. Students may choose between a programming option (to be done in Python) and a non-programming option|
|25%||Midterm (closed books)|
|40%||Final (cumulative, closed books)|
This is an approximate schedule; it is subject to changes as the course progresses. All deadlines for assignments that have not been posted yet are tentative and may change during the course. Lecture notes for a particular lecture will be available in courseworks ahead of the lecture. The notes are PDF files, one slide per page; if you plan on printing the notes, you may want to set up the printer to print at least two slides per page.
Overview. Introduction to
The Entity-Relationship Model.
Chapters 1 and 2.
|Think of an application for Project 1; interact with other students to discuss ideas and find teammate (no deliverable).|
The Relational Model, SQL Schema.
|Form a team for Project 1, by Friday Jan 27 (no deliverable).|
|The Relational Model (cont.)||Project 1.1 approval madness; Monday Jan 30 through Friday Feb 03.|
Chapter 4, Sections 4.1 and 4.2 only.
|Project 1.1, by Monday Feb 06, 5pm.|
|HW1, by Wednesday Feb 15, 4pm.|
|SQL (cont.).||Project 1.2, by Tuesday Feb 22, 5pm.|
Embedded SQL, APIs.
Q&A about the midterm exam.
|HW2, by Friday Mar 03, 5pm. You can not use grace days for this homework.|
Exam (closed book/notes)
March 15 - No class (spring break)
|Security and Authorization.
Chapter 21, Sections 21.1 - 21.3 and 21.6.
Chapter 19, except for Sections 19.6.2 (Decomposition into 3NF) and 19.8 (Other Kinds of Dependencies).
|Storage and Indexing.
Chapter 8 (only at the level of detail covered in class).
| Project 1.3, by Tuesday April 4, 5pm.
|Query Processing and
Chapter 12 (only at the level of detail covered in class).
Chapter 16 (only at the level of detail covered in class), except for Sections 16.5 ("Performance of Locking") and 16.6 ("Transaction Support in SQL").
|Overflow material, misc topics
Q&A about the final exam.
May 03 - No class (study day)
|Final Exam (closed book/notes)|