The following schedule of class lectures is subject to change. I will let you know about any changes as far in advance as possible. You are responsible for reading the appropriate chapter in the course textbook before each class. The reading assignment is indicated in the first column. For example, for the lectures on Principles of Database Systems (Classes 1-3) you should read Chapters 1 and 2 of the text. The lectures are ordered in such a way as to expose you to material you will need for the programming project (e.g. relational algebra, SQL) as early in the course as possible.
Classes will be taught online using zoom during normal class time and recorded for viewing offline. The zoom link will be posted on the course homepage and on Brightspace.
Class# Date Lecture# Topic ------ ---- -------- ----- 1 8/28 1 Principles of Database Systems 2 8/30 1 cont. 9/4 Labor Day 3 9/6 2 Relational Databases & Transaction Processing 4 9/11 2 cont. 5 9/13 3 The Relational Model & SQL DDL 6 9/18 3 cont. 7 9/20 3 cont. 8 9/25 4 Conceptual Design Using the ER Model 9 9/27 4 cont. 10 10/2 4 cont. 11 10/4 5 Relational Algebra & SQL 10/9 Fall Break 12 10/11 5 cont. 13 10/16 5 cont. 14 10/18 Midterm Exam 15 10/23 6 Schema Refinement and Normalization 16 10/25 6 cont. 17 10/30 6 cont. 18 11/1 6 cont. 20 11/6 8 Using SQL in an Application 21 11/8 8 cont. 22 11/13 9 File Organization and Indexing 23 11/15 9 cont. 24 11/20 10 Query Optimization: The Basics 11/22 Thanksgiving Break 25 11/27 10 contd. 26 11/29 11 Query Optimization 27 12/4 7 Triggers 28 12/6 NoSQL 29 12/11 Review for Final 12/12 Final Exam (8:30--11:00pm)