|
SCHEDULE OF CLASSES
|
|
Date
|
Topic
|
Handouts
|
|
01/10/2005
|
Introduction and overview (A.R.
1)
|
The
Pre-Requisite Disclaimer Form
|
|
01/12/2005
|
Introduction and overview
|
Session
1
|
|
01/17/2005
|
No Class--Martin Luther King Day
|
|
|
01/19/2005
|
ER data model (review)
|
Session 2
|
|
01/24/2005
|
Relational data model (review)
|
Session 3
|
|
01/26/2005
|
Extended ER
|
Session 4
|
|
01/31/2005
|
**Extended ER (exercise)
|
Session 4 (Extra), Homework 1
|
|
02/02/2005
|
SQL (review)
|
Session 5
|
|
02/07/2005
|
SQL (advanced)
|
|
|
02/09/2005
|
**SQL (advanced, exercise)
|
Session 6
|
|
02/14/2005
|
OO and OR-DBMS (A.R. 3
, 2,
9)
|
Session 7 , Session 8
|
|
02/16/2005
|
**Oracle 10g ORDBMS and SQL3 (A.R. 4)
|
Sample Data (part1) , Sample Data (part2)
|
|
02/21/2005
|
No Class--President's Day
|
|
|
02/23/2005
|
**Database Connectivity
|
Session 9 Example Files: Example1,Example2,Example3,Example4,Example5,Example6 Source Code and Oracle Libraries
|
|
02/28/2005
|
Spatial Databases (A.R.
6)
|
Session 10
|
|
03/02/2005
|
**Spatial Index structures (A.R. 7,
11
, 12,
25
)
|
Homework 1 Due , Sample solution for Homework1
Session 11
HW1 query sample answers and instructions
Session 11 with white background
|
|
03/07/2005
|
Exam 1 review
|
Sample midterm, Homework 2
cars.txt, bikes.txt, people.txt,satellite.jpg
|
|
03/09/2005
|
Exam 1 (THH 201 and THH215)
|
Solution for Exam1
|
|
03/14/2005
|
No class--Spring Break
|
|
|
03/16/2005
|
No class--Spring Break
|
|
|
03/21/2005
|
XML (A.R.
13,15)
|
Session 14-Xml
|
|
03/23/2005
|
XML (A.R. 5,
XQuery 1.0
)
|
Session 14-Query,Session 14-Extra
|
|
03/28/2005
|
XML
|
Session 14-Schema
|
|
03/30/2005
|
Distributed Databases
|
DDBMS-Introduction, Homework 2 Due
|
|
04/04/2005
|
Distributed Databases
|
DDBMS-Design, Homework 3
|
|
04/06/2005
|
Distributed Databases
|
DDBMS-QueryProcessing
|
|
04/11/2005
|
Multidimensional Databases (A.R.
16, A.R.
20, A.R.
21)
|
Session 15-1
|
|
04/13/2005
|
OLAP (A.R.
17)
|
Session 15-2
|
|
04/18/2005
|
OLAP (A.R.
18, A.R.
24)
|
Session 16-1
|
|
04/20/2005
|
OLAP(A.R.
19, 22,
23)
|
Session 16-2, Homework 3 Due
|
|
04/25/2005
|
Exam 2 review
|
Sample final , Sample Solution for Homework 3
|
|
04/27/2005
|
Exam 2 (SGM 123)
|
|
|
|
|
|