|15%||Four equally weighted homework assignments|
|20%||Two projects - Project 1 is worth 15% and Project 2 is worth 5%|
|25%||Midterm (closed books)|
|40%||Final (cumulative, closed books)|
This schedule is subject to changes as the course progresses. All deadlines for assignments that have not been posted yet are tentative. Lecture notes for a particular lecture will be available on Courseworks ahead of the lecture.
Overview. Introduction to
The Entity-Relationship Model.
Chapters 1 and 2.
|Think of applications for Project 1; interact with other students to discuss ideas and find teammate; use Piazza. Form a team by tomorrow (no deliverable).|
The Relational Model, SQL Schema.
|Project 1.1 approval; Wednesday May 25 just before and just after lecture, Thursday and Friday May 25-26 (no deliverable).|
|The Relational Model (cont.)||Project 1.1, Thursday June 1, 5pm.|
Chapter 4, Sections 4.1 and 4.2 only.
|HW1, Monday June 5, 5pm.|
|SQL (cont.).||Project 1.2, Thursday June 8, 5pm.|
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).
Object-Relational DBMS: Database Design.
Chapter 23, Sections 23.1 through 23.7.
Q&A about the midterm exam.
|HW2, Monday June 12, 5pm.|
Exam (closed book/notes). It covers topics of lectures #1 to
#6; it does not include the topics of lecture #7.
of Storage and Indexing.
Chapter 8 (only at the level of detail covered in class).
| Project 1.3
Monday June 19, 5pm.
|Introduction to Query Processing and
Chapter 12 (only at the level of detail covered in class).
|HW3, by Wednesday June 21, 5pm.|
Introduction to Transaction Processing.
the final exam.
| Project 2, by Monday June 26, 5pm.
HW4, by Monday June 26, 5pm.
Exam (closed book/notes).
The final exam is cumulative.