Tentative Calendar -- may be
changed/updated during the semester
|
#
|
Day
|
Date
|
Topic(s)
|
Lecture Notes
|
Readings
|
Assignments
|
1
|
Mon
|
Aug 28
|
Course Introduction
Review Data Modeling and ER diagrams
|
|
Elmasri Ch.2, Ch. 3, Ch. 4
|
|
|
Mon
|
Sept 4
|
LABOR DAY -- NO CLASS
|
|
|
Assign:
Current topics assignment
|
2
|
Mon
|
Sept 11
|
Review: Relations and Relational Algebra
|
|
Elmasri Ch. 5, Ch. 6, Ch. 7
|
Assign:
Indiviual DB project
|
3
|
Mon
|
Sept 18
|
Relational Algebra
SQL and SQL*PLUS
|
|
Oracle SQL*Plus documentation
|
Assign Sept 19:Homework #1
|
4
|
Mon
|
Sept 25
|
SQL and SQL*Plus
Oracle
|
|
Elmasri Ch. 8, Ch. 9
Oracle 9i documentation
Codd's 1970 CACM paper
|
Due Sept 27: Homework #1
|
5
|
Mon
|
Oct 2
|
Class Cancelled
|
|
|
|
6
|
Mon
|
Oct 9
|
Normal Forms
|
see note
|
Elmasri Ch. 10, Ch. 11
|
Due: Individual DB
|
7
|
Mon
|
Oct 16
|
MIDTERM EXAM -- IN-CLASS
|
|
|
|
8
|
Mon
|
Oct 23
|
Indexing
|
see note
|
Elmasri Ch. 13, Ch. 14
|
Assign: Group DB
Assign: Current Topics Assignment II
|
9
|
Mon
|
Oct 30
|
Indexing (continued)
Query Processing, Optimization and Tuning
|
see note
oct30 notes
|
Elmasri Ch. 15, Ch. 16
|
Assign: Homework #2
|
10
|
Mon
|
Nov 6
|
Query Processing, Optimization and Tuning (continuted)
Transactions
|
oct30 notes
|
Elmasri Ch. 17
|
Due: Group DB mini-world description
Due Nov 8: Homework #2
|
11
|
Mon
|
Nov 13
|
Transactions
|
|
Oracle 9i documentation
|
|
12
|
Mon
|
Nov 20
|
PL/SQL
|
PL/SQL notes
|
Oracle 9i documentation
|
|
13
|
Mon
|
Nov 27
|
PL/SQL
Reports (if time allows)
|
More PL/SQL notes
|
Oracle 9i documentation
|
|
14
|
Mon
|
Dec 4
|
Group project demos
|
|
|
Due: Group DB
|
|
Fri
|
Dec 8
|
FINAL EXAM -- Fri, Dec 8, 12:00noon - 4:00pm -- Manning 214
|
|
|
|