| Date |
Topic |
Slides |
Reading |
Assignments |
| 9/30 |
Introduction, Entity-Relationship model |
pdf |
1, 2.1 |
|
| 10/2 |
Entity-Relationship design |
pdf |
2.2-2.4 |
Exercise problems |
| 10/7 |
Relational model, Functional dependencies |
pdf |
3.1-3.5 |
Assignment 1 |
| 10/9 |
Multivalued dependencies, Normal forms |
pdf |
3.6-3.7 |
|
| 10/14 |
Relational algebra |
pdf |
5 |
Assignment 2 |
| 10/16 |
SQL queries |
pdf |
6.1-6.2 |
|
| 10/21 |
Subqueries, Aggregation |
pdf |
6.3-6.4 |
Assignment 3 |
| 10/23 |
Modifications, Schemas, Views |
pdf |
6.5-6.7 |
|
| 10/28 |
Constraints, Triggers |
pdf |
7 |
Assignment 4 |
| 10/30 |
Midterm Exam |
|
Solutions |
Practice test |
| 11/4 |
PSM, PL/SQL |
pdf |
8.1-8.2 |
Assignment 5 |
| 11/6 |
Embedded SQL, Database connectivity |
pdf |
8.3-8.5 |
|
| 11/11 |
Transactions, Authorization |
pdf |
8.6-8.7 |
Assignment 6 |
| 11/13 |
Datalog |
pdf |
10.1-10.3 |
|
| 11/18 |
Data warehousing, Data mining |
pdf |
Notes |
|
| 11/20 |
Object-relational model, ODL, OQL |
pdf |
4.1-4.5, 9 |
Assignment 7 |
| 11/25 |
Semistructured data, XML |
pdf |
4.6-4.7 |
|
| 11/27 |
No class |
|
|
|
| 12/2 |
XPath, XQuery |
pdf |
Notes |
|
| 12/4 |
Review |
|
|
|