![]()
Quick links
| Instruction for Oracle access information | |||||||||
PHP materials
|
|||||||||
| PHP example |
![]()
|
Week |
Date |
Topic |
Notes |
Presentation |
Homework |
Chapter |
|
1 |
22-Aug-07 |
Introduction | 1 | |||
|
|
24-Aug-07 |
|||||
|
2 |
27-Aug-07 |
Relational algebra | ch2.pdf | 2 & 3 | ||
|
29-Aug-07 |
||||||
|
|
31-Aug-07 |
|||||
|
3 |
3-Sep-07 |
Labor day | 2 & 3 | |||
|
|
5-Sep-07 |
Relational algebra/SQL | ||||
|
|
7-Sep-07 |
Quiz on relational algebra | ||||
|
4 |
10/14-Sep-07 |
No class | 3 | |||
| 5 | 17-Sep-07 | SQL | examples in | PPTX or PDF | 3 | |
| 19-Sep-07 | SQL | |||||
| 21-Sep-07 | SQL | |||||
| 6 | 24-Sep-07 | Quiz on SQL | ||||
|
26-Sep-07 |
Advanced SQL | 4 | ||||
| 28-Sep-07 | ||||||
|
7 |
1-Oct-07 | E-R design | 6 | |||
|
3-Oct-07 |
||||||
|
5-Oct-07 |
||||||
|
8 |
8-Oct-07 |
Midterm | ||||
|
10-Oct-07 |
6 | |||||
|
|
12-Oct-07 | |||||
| 9 | 15/17-Oct-07 | No class | ||||
| 19-Oct-07 | Relational Database Design | 7 | ||||
| 10 | 22-Oct-07 | Keys and FDs - Closure | ||||
| 24-Oct-07 |
1NF
and BCNF |
|||||
| 26-Oct-07 |
Decomposition
to BCNF |
7 |
||||
| 11 |
29-Oct-07 |
3NF | ||||
| 31-Oct-07 |
||||||
| 2-Nov-07 |
||||||
| 12 | 5-Nov-07 | 4NF and MVDs | my note | 7 | ||
| 7-Nov-07 |
Application
Design and Development |
Exp of trigger |
Exp of JDBC |
8 |
||
| 9-Nov-07 |
XML
|
10 | ||||
| 13 |
12-Nov-07 |
Quiz
5 |
||||
| 14-Nov-07 | ||||||
| 16-Nov-07 | ||||||
| 14 |
19/24-Nov-07 |
Thanksgiving
holiday & Fall break |
||||
| 15 |
26-Nov-07 |
Extended Aggregation in SQL |
18 | |||
| 28-Nov-07 |
Data
warehousing & mining |
Cube, Rollup, Rank |
windowing example |
|||
| 30-Nov-07 |
Creating
decision tree |
|||||
| 16 |
2-Dec-07 |
Ming
association rules |
||||
| 4-Dec-07 |
Information retrieval | file1.txt |
file2.txt |
file3.txt |
Program and Query |
|
| 6-Dec-07 |
Information retrieval | |||||
| Sample
test |
2004-02 |
2004-01 |
2005-01 |
|||
| 2005-02 |
2006-02 |
2006-03 |
||||
| Summary |
2007-01 |
|||||
| Homework
solution |
HW8 |
HW9 |
HW10 |
|||
| 17 |
Exam
week |
![]()
Last Updated on 10/03/2007 03:59 PM -0600