Schedule
Document Actions
The schedule below contains tentative reading assignments for each week of the quarter.
Date
|
Topic
|
Reading
|
|
Week 1 |
Intro, E/R model Weak entity sets, E/R
design |
1, 2.1, 2.3 2.2, 2.4 |
|
Week 2 |
Relational model,
Functional Dependencies Normal forms, Multivalued
dependencies |
3.1-3.5 3.6-3.7 |
|
Week 3 |
Monday Holiday Relational Algebra, SQL
queries |
5 , 6.1, 6.2, |
|
Week 4 |
More SQL, Subqueries,
Grouping/aggregation, Modifications, Schemas,
Views Lab - MS/SQL |
6.3, 6.4, 8.2, 6.5-6.7 or mssql.html |
|
Week 5 |
Constraints and Triggers Midterm on Wednesday |
7.1-7.3, 7.4 |
|
Week 6 |
More MS/SQL, Embedded SQL JDBC |
8.1, 8.3-8.5 jdbc.html, |
|
Week 7 |
Monday Holiday Object-relational |
4.5, 9.4, 9.5,
or-objects.html |
|
Week 8 |
Transactions,
Authorization ODL, OQL |
8.6, 8.7, 10.3, 10.4, 4.1-4.4 9.1 |
|
Week 9 |
Semistructured data, XML,
Xquery Project presentations
& demo’s |
4.6, 4.7, Notes |
|
Week 10 |
Data warehouses, Data
mining Final on Wednesday |
Notes |
Note that this may be adjusted as we proceed, since we may not be able to go as fast as I had thought. I will try to update this every week or ten days….
