| Date |
Topic |
Slides |
Readings |
Assignments |
| 9/27 |
Introduction, Entity-Relationship model |
pdf |
1, 2.1 |
|
| 9/29 |
Entity-Relationship design |
pdf |
2 |
Practice Problems |
| 10/4 |
Relational model, Online dating |
pdf |
3.1-3.5 |
Assignment 1 |
| 10/6 |
Functional and multivalued dependencies, Normal forms |
pdf |
3.4-3.7 |
|
| 10/11 |
Relational algebra |
pdf |
5 |
Assignment 2 |
| 10/13 |
SQL: Simple queries |
pdf |
6.1-6.2 |
|
| 10/18 |
SQL: Subqueries, Aggregation |
pdf |
6.3-6.4 |
Assignment 3 |
| 10/20 |
SQL: Modifications, Schemas, Views |
pdf |
6.5-6.7 |
|
| 10/25 |
Constraints, Triggers |
pdf |
7 |
Assignment 4 |
| 10/27 |
Persistent stored modules |
pdf |
8.1-8.2, Notes |
|
| 11/1 |
Midterm Exam |
|
|
Assignment 5 |
| 11/3 |
Database connectivity |
|
8.3-8.5, Notes |
|
| 11/8 |
Transactions, Authorization |
pdf |
8.6-8.7 |
Assignment 6 |
| 11/10 |
Indexing |
pdf |
6.6.5, 6.6.6, Notes |
|
| 11/15 |
Datalog |
pdf |
10.1-10.3 |
Assignment 7 |
| 11/17 |
Data warehousing, Data mining |
pdf |
Notes |
|
| 11/22 |
Semistructured data, XML |
pdf |
4.6-4.7 |
|
| 11/24 |
No class |
|
|
|
| 11/29 |
XPath, XQuery |
pdf |
Notes |
|
| 12/1 |
Review |
|
|
|