CS 4604: Fall 2018
Introduction to Database
Management Systems
Introduction to Database
Management Systems
| Date | Topic | Reading | Homework/ Assignment |
| Tue, Aug 28 | Introduction and Course Logistics | DMS, Chapter 1 | |
| Thu, Aug 30 | The Relational Model and Relational Algebra | DMS, Chapter 3, 4 | Project Assignment 1 |
| Tue, Sep 4 | SQL Part 1 |
DMS, Chapters 4, 5 | |
| Thu, Sep 6 | Handout 1 (practice in class) | DMS, Chapters 3, 4, 5 | Project Assignment 1 due Homework 1 |
| Tue, Sep 11 | SQL Part 2 | DMS, Chapters 4, 5 | |
| Thu, Sep 13 | Entity/Relationship Models Part 1 | NOT from book | Homework 1 due Homework 2 |
| Tue, Sep 18 | Entity/Relationship Models Part 2 | NOT from book | |
| Thu, Sep 20 | Entity/Relationship Models Part 3 and Handout 2 (practice in class) | NOT from book | |
| Tue, Sep 25 | Storing Data and Indexes |
DMS, Chapter 10 | Homework 2 due Homework 3 |
| Thu, Sep 27 | Hashing and Sorting | DMS, Chapter 11, 13 | |
| Tue, Oct 2 | Query Processing and Midterm Review | DMS, Chapter 12, 14 | Homework 3 due Homework 4 |
| Thu Oct 4 | Midterm examination (in class) | ||
| Tue, Oct 9 | Query Optimization | DMS, Chapter 15 and Paper | |
| Thu, Oct 11 | NoSQL and MapReduce | NOT in book. See MR paper. | |
| Tue, Oct 16 | Functional Dependencies | DMS, Chapter 19 | Homework 4 due Homework 5 Project Assignment 2 |
| Thu, Oct 18 | BCNF, 3NF and Normalization | DMS, Chapter 19 | |
| Tue, Oct 23 | Handout 3 (practice in class) | DMS, Chapter 19 | |
| Thu, Oct 25 | Transactions Part 1: Intro. to ACID | DMS, Chapter 16, 17 | Homework 5 due |
| Tue, Oct 30 | Transactions Part 2: 2PL/2PLC and Deadlocks | DMS, Chapter 16, 17 | |
| Thu, Nov 1 | Recitation for Project (PHP etc) | Project Assignment 2 due Homework 6 Project Assignment 3 |
|
| Tue, Nov 6 | No lecture: Extra office hours in class | ||
| Thu, Nov 8 | Logging and Recovery Part 1 | DMS, Chapter 18 | Homework 6 due Homework 7 |
| Tue, Nov 13 | Logging and Recovery Part 2 | DMS, Chapter 18 | |
| Thu, Nov 15 | Data Mining and Warehousing | DMS, Chapter 26 | Homework 7 due |
| Tue, Nov 20 | Thanksgiving break | ||
| Thu, Nov 22 | Thanksgiving break | ||
| Tue, Nov 27 | Practice Problems | ||
| Thu, Nov 29 | In-class office hours (time for project) | ||
| Tue, Dec 4 | Final Review | Project Assignment 3 due | Fri, Dec 7 | Final examination (7:45-9:45am) |