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