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