Quick links
 | Week 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
| Instruction for Oracle access information |
| Previous tests 2001-1 2001-2 2001-3 2002-1(?) 2002-2 2002-3(?) 2003-1 2003-2 2003-3 2004-1 2004-2 2004-3 |
| |
| |
| |
| |
|
|
Week |
Date |
Topic |
Notes |
Presentation |
Homework |
Chapter |
|
23-Aug-05 |
Introduction |
pdf or ppt | hw1 sol1 | 1 | ||
|
|
25-Aug-05 |
Student Registration System |
pdf or ppt | 2 | ||
|
30-Aug-05 |
Relational Data Model |
pdf or ppt | hw2 sol2 | 3 | ||
|
|
1-Sep-05 |
|
hw3 sol3 | |||
|
6-Sep-05 |
No Class |
|||||
|
|
8-Sep-05 |
No Class |
||||
|
13-Sep-05 |
Conceptual Modeling & ER Diagram |
pdf or ppt | hw4 sol4 | 4 | ||
|
|
15-Sep-05 |
|
||||
|
20-Sep-05 |
Relational Algebral and SQL |
pdf or ppt | 5 | |||
|
|
22-Sep-05 |
|
hw5 sol5 | |||
|
27-Sep-05 |
||||||
|
29-Sep-05 |
Review (Chapter 1 - 5) |
exp | review (ppt) | hw6 sol6 | ||
|
4-Oct-05 |
Relational Normalization Theory |
pdf or ppt | 6 | |||
|
|
6-Oct-05 |
Midterm 1 |
test1 Q & A | project | ||
|
11-Oct-05 |
Relational Normalization Theory |
6 | ||||
|
|
13-Oct-05 |
|
practice | |||
|
18-Oct-05 |
PHP & SQL |
|||||
|
|
20-Oct-05 |
Norm. Theory - In class exercises |
||||
|
25-Oct-05 |
Relational Normalization Theory |
|||||
|
|
27-Oct-05 |
|
||||
|
1-Nov-05 |
4NF & Review |
pdf or ppt | ||||
|
|
3-Nov-05 |
Midterm 2 |
answer | |||
|
8-Nov-05 |
Triggers and Active Database |
pdf or ppt | 7 | |||
|
|
10-Nov-05 |
Using SQL in Application |
plsql/jdbc-pdf | pdf or ppt | practice | 8 |
|
15-Nov-05 |
Physical Data Organization and Indexing |
9 10 | ||||
|
|
17-Nov-05 |
Query Processing |
||||
|
22-Nov-05 |
Thanksgiving Holiday |
|||||
|
|
24-Nov-05 |
Thanksgiving Holiday |
||||
|
29-Nov-05 |
Transaction Processing |
13 | ||||
|
|
1-Dec-05 |
Review |
||||
|
6-Dec-05 |
Exam Week |
|||||
|
|
8-Dec-05 |
|
Last Updated on 11/14/2005 09:28 AM -0700