|
|
|
Calendar / Notes
|
| # |
Day |
Date |
Topic(s) |
Lecture Notes |
Readings* |
Assignments (week assigned) |
| 1 |
Tue |
Aug 21 |
DBMS, data modeling, ER review |
No class meeting |
Read Elmasri 1, 2, 3 |
hw1 |
| 2 |
Tue |
Aug 28 |
Course intro, relations, relational algebra |
Capra 01
Ramakrishnan 04 |
Read Elmasri 4, 5, 6 |
hw2 |
| 3 |
Tue |
Sep 4 |
ER-to-relational mapping, SQL |
Capra 02
Ramakrishnan 05 |
Read Elmasri 7, 8 |
hw3
Current Topics Assignment
Project proposal |
| 4 |
Tue |
Sep 11 |
Oracle SQL |
Capra 03 |
Read Elmasri 8
Ref Oracle guides |
|
| 5 |
Tue |
Sep 18 |
Normal Forms |
Capra 04
Ramakrishnan 19 |
Read Elmasri 10 |
hw4
Project design |
| 6 |
Tue |
Sep 25 |
Normal Forms
Storage, files, hashing
Review for exam |
on board, in class |
Read Elmasri 13 |
|
| 7 |
Tue |
Oct 2 |
Mid-Term Exam
Storage, files, hashing |
on board, in class |
|
|
| 8 |
Tue |
Oct 9 |
Indexing |
on board, in class |
Read Elmasri 14 |
hw5 |
| 9 |
Tue |
Oct 16 |
Indexing |
on board, in class |
Read Elmasri 15, 16 |
|
| 10 |
Tue |
Oct 23 |
NO CLASS -- Read/try PL/SQL |
PL/SQL Notes 1
PL/SQL Notes 2
Example data |
Oracle documentation |
hw6
hw6data.txt
Project final report |
| 11 |
Tue |
Oct 30 |
PL/SQL |
PL/SQL Notes 3
Exercises |
Oracle documentation |
|
| 12 |
Tue |
Nov 6 |
Transactions |
on board, in class |
Read Elmasri 17 |
hw7 |
| 13 |
Tue |
Nov 13 |
Transactions |
on board, in class
Oracle Transactions Notes |
Read Elmasri 17 |
|
| 14 |
Tue |
Nov 20 |
Query processing, optimization, tuning |
Query Optimization |
Read Elmasri 15, 16 |
hw8 |
| 15 |
Tue |
Nov 27 |
Database Security |
Elmasri 23 slides
In-Class Exercise |
Read Elmasri Ch. 23 |
hw9 |
| 16 |
Tue |
Dec 4 |
Datalog
Course Review |
Datalog examples |
Read Elmasri 24.4 |
|
| |
Mon |
Dec 10 |
6:00pm - 8:30pm, Final Exam |
|
|
|
|
Read = read this material, you may be tested on it
Ref = reference material
Skim = skim this material
|