|
|
|
Readings
required
|
|
Jan. 4
|
Introduction to database
systems
|
Ch. 1
|
|
9
|
Relational model, relational
algebra
|
Ch. 3 (except 3.5), 4.1-4.2
|
|
11
|
Relational calculus, QBE
|
Ch. 4.3-4.5, 6
|
|
16
|
ER modeling
|
Ch. 2
|
|
18
|
ER modeling
|
Ch. 2
|
|
23
|
ER-to-relational mapping
|
Ch. 3.5
|
|
25
|
SQL: Simple, set operations,
nested queries
|
Ch. 5.5.1-5.4
|
|
26
|
Assn
1: relations; querying; ER
|
|
|
30
|
DB2 Overview
|
|
|
Feb. 1
|
SQL: Aggregation, nulls
|
Ch. 5.5-5.6
|
|
2
|
648:
project topic
|
|
|
6
|
SQL: Embedded SQL, cursors
|
Ch. 5.7-5.8
|
|
8
|
SQL: Dynamic SQL, ODBC,
CLI
|
Ch. 5.9-5.10
|
|
13
|
SQL: Integrity constraints,
triggers
|
Ch. 5.11-5.13
|
|
"
|
Assn
2: SQL (DB2)
|
|
|
15
|
Normal forms & normalization
|
Ch. 15.1-15.7.1
|
|
19
|
Midterm
exam (7:00-9:00PM; EL 211)
|
|
|
20
|
Flex time and review
|
|
|
22
|
|
|
|
27
|
Data storage on disks,
indexing, hashing *
|
Ch. 7, 8, 9, 10
|
|
Mar. 1
|
Physical database design
and index selection
|
Ch. 16.1-16.5
|
|
2
|
648:
project status
|
|
|
6
|
Implementation of relational
operators
|
Ch. 12
|
|
8
|
Implementation of relational
operators
|
Ch. 12
|
|
|
Assn
3 (448): normalization; physical design
|
|
|
13
|
Query evaluation methodology,
optimization
|
Ch. 13
|
|
15
|
Query optimization
|
Ch. 13, 14
|
|
20
|
Transactions, concurrency
control
|
Ch. 18, 19
|
|
22
|
Concurrency control, recovery
|
Ch. 19, Recovery notes
|
|
27
|
Recovery
|
Recovery notes
|
|
29
|
Flex time and review
|
|
|
30
|
Assn
4: optimization; transactions
|
|
|
Apr. 3
|
648:
project
|
|
|
Apr. 11
|
Final
Exam
|
9-12AM in MC 1056,
1085
|
Home | General Information | Weekly Schedule
Course Notes | Newsgroup | Assignments & Exams | FAQ
Last updated 3 January 2001