Chapter and section numbers refer to the (optional) class textbook (7th edition). The readings are not required: the lectures will cover all material needed for homework assignments and exams. This schedule is subject to changes as the course progresses. The slides for each lecture, including also the slides with the in-lecture annotations, will appear in the "Files" section on CourseWorks.

• Tue Sep 3: Course Overview. Introduction to DBMS. Chapter 1.
• Thu Sep 5: The Entity-Relationship Model. Chapter 6 except for Sections 6.7, 6.10, and 6.11.
• Tue Sep 10, Thu Sep 12: The Entity-Relationship Model (continued). Chapter 6 except for Sections 6.7, 6.10, and 6.11.
• Tue Sep 17: The Relational Model. Sections 2.1-2.3.
• Thu Sep 19, Tue Sep 24: The Relational Model (continued). Sections 2.5, 3.1, 3.2, 3.3, 6.7 (except for Section 6.7.2), and 6.8.
• Thu Sep 26, Tue Oct 1, Thu Oct 3: Relational Algebra. Section 2.6 (but use the notation and conventions in the lectures, which are slightly different from the textbook).
• Tue Oct 8: SQL Queries, Constraints, Triggers. Sections 3.4-3.10.
• Thu Oct 10: SQL: Queries, Constraints, Triggers (continued). Section 4.4.
• Tue Oct 15, Thu Oct 17: SQL: Queries, Constraints, Triggers (continued). Sections 4.1, 4.2, 4.5, and 5.3.
• Tue Oct 22: Embedded SQL, Cursors, SQL APIs. Sections 5.1 and 5.2.
• Thu Oct 24, during lecture time: Midterm exam (closed book, closed notes).
• Tue Oct 29, Thu Oct 31: Schema Refinement and Normal Forms. Sections 7.1, 7.2, 7.3.1, 7.4.1, 7.4.2, and 7.5.1.
• Tue Nov 5: University Holiday (Election Day).
• Thu Nov 7, Tue Nov 12: Object-Relational DBMS: Database Design. Section 8.2 and Chapter 29 (Chapter 29 is available online).
• Thu Nov 14: Overview of Storage and Indexing. (No readings from textbook.)
• Tue Nov 19: Introduction to Query Processing and Optimization. Sections 15.1-15.6, but only to the level of detail covered in the course.
• Thu Nov 21, Tue Nov 26: Introduction to Query Processing and Optimization. Sections 15.1-15.6, but only to the level of detail covered in the course.
• Thu Nov 28: University Holiday (Thanksgiving Day).
• Tue Dec 3, Thu Dec 5: Introduction to Transaction Processing. Chapter 17, but only to the level of detail covered in the course.
• Thu Dec 19, 9:00-11:00 a.m. ET: Final exam (cumulative; closed book, closed notes).