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