|
|
|
Calendar / Notes
|
| # |
Date |
Topic(s) |
Lecture Notes |
Readings* |
Assigned |
Due |
| 1 |
Aug 25 |
Course intro, ER review, relational algebra |
Capra 01
Ramakrishnan 04 |
Read Elmasri 1, 2, 3, 4 |
hw1 |
|
| 2 |
Sep 1 |
ER-to-relational mapping, SQL |
Ramakrishnan 05 |
Read Elmasri 5, 6, 7 |
hw2 |
hw1 |
| 3 |
Sep 8 |
Oracle SQL |
Capra 03 |
Read Elmasri 8
Ref Oracle guides |
hw3
Current Topics Assignment
Project proposal |
hw2 |
| 4 |
Sep 15 |
Normal Forms |
Capra 04
Ramakrishnan 19 |
Read Elmasri 10 |
|
hw3 |
| 5 |
Sep 22 |
Storage, files, hashing |
on board, in class |
Read Elmasri 13 |
hw4
Project design |
Project proposal |
| 6 |
Sep 29 |
Indexing |
on board, in class |
Read Elmasri 14 |
hw5 |
hw4 |
| 7 |
Oct 6 |
Indexing |
on board, in class |
Read Elmasri 14 |
|
|
| 8 |
Oct 13 |
PL/SQL |
PL/SQL Notes 1
PL/SQL Notes 2
Example data
PL/SQL Notes 3
Exercises |
Oracle documentation |
hw6
hw6data.txt |
hw5 |
| 9 |
Oct 20 |
Mid-Term Exam |
NO lecture after exam |
|
|
|
| 10 |
Oct 27 |
Transactions |
on board, in class |
Read Elmasri 17 |
Project final report |
Project design |
| 11 |
Nov 3 |
Transactions |
on board, in class |
Read Elmasri 17 |
hw7 |
hw6 |
| 12 |
Nov 10 |
Oracle Transactions
Query Processing, Optimization and Tuning |
Oracle Transactions
Query Optimization |
Oracle documentation |
hw8 (cancelled) |
hw7 |
| 13 |
Nov 17 |
Distributed DBs
Data Mining and Data Warehousing |
Ramakrishnan 22b |
|
hw9 |
hw8 (cancelled) |
| 14 |
Nov 24 |
No Class |
|
|
|
|
| 15 |
Dec 1 |
Database security
Datalog |
Elmasri 23 slides
In-Class Exercise
Datalog examples |
Read Elmasri Ch. 23 |
|
hw9 |
| 16 |
Dec 8 |
Final Exam |
|
|
|
|
|
Read = read this material, you may be tested on it
Ref = reference material
Skim = skim this material
|