CS 4604: Spring 2014
Introduction to Database
Management Systems
Introduction to Database
Management Systems
| Date | Topic | Reading | Homework/ Assignment |
| Tue, Jan 21 | Introduction and Course Logistics | DMS, Chapter 1 | |
| Thu, Jan 23 | The Relational Model and Algebra | DMS, Chapter 3, 4 | |
| Tue, Jan 28 | SQL and Relational Algebra Part 1 |
DMS, Chapters 4, 5 | |
| Thu, Jan 30 | SQL and Relational Algebra Part 2 | DMS, Chapters 4, 5 | |
| Tue, Feb 4 | SQL and Relational Algebra Part 3 |
DMS, Chapters 3.6, 5, 25.9, 25.10.1 | Homework 1 |
| Thu, Feb 6 | Entity/Relationship Models Part 1 | NOT from book | |
| Tue, Feb 11 | Entity/Relationship Models Part 2 | NOT from book | Homework 1 due Homework 2 |
| Thu, Feb 13 | Class Cancelled (Winter storm PAX) | ||
| Tue, Feb 18 | Entity/Relationship Models Part 3 | NOT from book | Project Assignment 1 |
| Thu, Feb 20 | Storing Data and Indexes |
DMS, Chapter 10 | Homework 2 due |
| Tue, Feb 25 | Class Cancelled | Project Assignment 1 due Homework 3 |
|
| Thu, Feb 27 | Hashing and Sorting | DMS, Chapter 11, 13 | |
| Tue, Mar 4 | Query Processing and Review | DMS, Chapter 12, 14 | Homework 3 due |
| Thu, Mar 6 | Midterm examination (in class) | ||
| Tue, Mar 11 | Spring Break | ||
| Thu, Mar 13 | Spring Break | ||
| Tue, Mar 18 | Query Optimization | DMS, Chapter 15 and Paper | Homework 4 |
| Thu, Mar 20 | NoSQL and MapReduce | NOT in book. See MR paper. | |
| Tue, Mar 25 | Semi-structured data and XML | DMS, Chapter 27 | Homework 4 due Homework 5 Project Assignment 2 |
| Thu, Mar 27 | Functional Dependencies | DMS, Chapter 19 | |
| Tue, Apr 1 | BCNF, 3NF and Normalization | DMS, Chapter 19 | Homework 5 due |
| Thu, Apr 3 | Handout 3 (practice in class) | DMS, Chapter 19 | |
| Tue, Apr 8 | Transactions Part 1: Intro. to ACID | DMS, Chapter 16, 17 | Project Assignment 2 due Homework 6 |
| Thu, Apr 10 | Transactions Part 2: 2PL/2PLC and Deadlocks | DMS, Chapter 16, 17 | |
| Tue, Apr 15 | Class Cancelled | Homework 6 due Homework 7 |
|
| Thu, Apr 17 | Logging and Recovery Part 1 | DMS, Chapter 18 | |
| Tue, Apr 22 | Logging and Recovery Part 2 | DMS, Chapter 18 | Project Assignment 3 |
| Thu, Apr 24 | Recitation for Project (PHP etc.) | Homework 7 due |
|
| Tue, Apr 29 | Data Mining and Warehousing | DMS, Chapter 26 | |
| Thu, May 1 | Practice Problems | ||
| Tue, May 6 | Final Review | Project Assignment 3 due on May 6 12:00noon | |
| Sat, May 10 | Final examination, 7:45am-9:45am | ||