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