| Week | Date | Topics | Reading | Assignments |
|---|---|---|---|---|
| 1 | 10/2 | Introduction, Entity-Relationship model and design |
FC: 1, 4.1-4.4 DS: 1, 2 |
hw1 |
| 2 | 10/9 | Database design, Relational model, Functional dependencies |
FC: 2.1-2.2, 3.1-3.5, 4 DS: 3, 4 |
hw2 |
| 3 | 10/16 | Normal forms, Relational algebra, SQL: Schemas, Simple queries |
FC: 2.3-2.5, 5, 6.1-6.2 DS: 4, 5 |
hw3 |
| 4 | 10/23 | SQL: Subqueries, Aggregation, Modifications |
FC: 6.2-6.5
DS: 5 |
hw4 |
| 5 | 10/30 | SQL: Joins, Views, Indexes, Constraints |
FC: 6.3, 7.1-7.2, 8.1-8.4
DS: 5, 6 |
hw5 |
| 6 | 11/6 | Midterm; Transactions, Authorization |
FC: 6.6, 10.1
DS: 10, class notes |
hw6 |
| 7 | 11/13 | Midterm review; Triggers, Stored procedures |
FC: 7.5, 9.1-9.4
DS: 6, class notes |
hw7 |
| 8 | 11/20 | Database connectivity, Web programming |
FC: 9.5-9.7
DS: 10 class notes |
hw8 (due Dec 2) |
| 9 | 11/22 | Data warehousing, Data mining |
class notes
DS: 7, App. G |
hw9 (due Dec 10) |
| 10 | 12/4 | NoSQL Databases, Big Data, MapReduce | - | 12/10 | Final project deadline! | no class |