| Week |
Date |
Topics |
Readings |
Assignments |
| 1 |
10/1 |
Introduction, Entity-Relationship model and design slides |
1, 4.1-4.4 |
Practice Problems, Solutions |
| 2 |
10/8 |
Relational model, Functional dependencies, Normal forms slides |
2.1-2.2,4.5-4.6,3.1-3.5 |
HW1 |
| 3 |
10/15 |
Relational algebra, SQL: Simple queries slides |
5, 6.1-6.2 |
HW2 |
| 4 |
10/22 |
SQL: Subqueries, Aggregation, Schemas, Modifications slides |
6.2-6.5 |
|
| 5 |
10/29 |
SQL: Joins, Views, Indexes, Constraints slides |
6.3, 7.1-7.2, 8.1-8.4 |
HW3 |
| 6 |
11/5 |
Midterm, Triggers, Stored Procedures slides |
7.5, 9.1-9.4 |
|
| 7 |
11/12 |
Transactions, Authorization slides |
6.6, 10.1 |
HW4 |