| Class # |
Date |
Lecture |
Topic |
Assignment |
Date Due |
| 1 |
Tu 9/7/99 |
Lecture 1 |
Introduction.
Overview.
|
|
|
| 2 |
Th 9/9/99 |
Lecture 2 |
Introduction to Access.
Overview, contd.
|
hw1
|
Tu 9/14/99 |
| 3 |
Tu 9/14/99 |
Lecture 3 |
Relational Databases
Overview
|
|
|
| 4 |
Wed 9/15/99 |
Lecture 4 (make up) |
Relational Algebra
|
|
|
| 5 |
Th 9/16/99 |
Lecture 5 |
Relational Algebra, contd.
|
hw2
|
Tu 9/21/99 |
| 6 |
Tu 9/21/99 |
Lecture 6 |
SQL
|
|
|
| 7 |
W 9/22/99 |
Lecture 7 (make-up)
|
SQL
|
|
|
| 8 |
Th 9/23/99 |
Lecture 8
|
SQL, aggregate functions
|
hw3
|
|
| 9 |
Tu 9/28/99 |
Lecture 9
|
Joins, null values, misc SQL.
Start Embedded SQL
|
|
|
| 10 |
Th 9/30/99 |
Lecture 10
|
Finish Embedded SQL.
Security, Views and SQL
|
hw4
|
|
| 11 |
Tu 10/5/99 |
Lecture 11
|
Midterm review.
|
|
|
| 12 |
Th 10/7/99 |
In-class Midterm
Exam
|
Relational database principles
Relational Algebra
SQL
Security and Views in SQL
|
Take-home
part of Midterm
|
Th Oct 14, 9:00am (before class) |
|
Tu 10/12/99 |
No class
October break |
|
|
|
| 13 |
Th 10/14/99 |
Lecture 12
|
Database Design
Schema Refinement
Start: functional dependencies
|
Hw 5
|
10/21/99 before class |
| 14 |
Tu 10/19/99 |
Lecture 13
|
Database Design
The ER Model
Student presentations
|
|
|
| 15 |
Th 10/21/99 |
Lecture 14
|
Database design, ER Model cont'd
Security issues in Oracle
(Stud. presentations)
|
|
|
| 16 |
Tu 10/26/99 |
Lecture 15
|
Functional dependencies.
|
|
|
| 17 |
Th 10/28/99 |
Lecture 16
|
Normal forms, finish.
File organization. Indexes.
|
|
|
| 18 |
Tu 11/2/99 |
Lecture 17
|
B+ trees
|
|
|
| 19 |
W 11/3/99 |
Lecture 18
(make-up)
|
B+ trees
|
|
|
| 20 |
Th 11/4/99 |
Lecture 19 |
Hash-based indexing
|
|
|
|
Tu 11/9/99 |
Independent work |
|
|
|
|
Th 11/11/99 |
Independent work |
|
|
|
| 21 |
Tu 11/16/99 |
Lecture 20
|
External Sorting
|
|
|
| 22 |
Th 11/18/99 |
Lecture 21
|
Concurrency control
|
|
|
| 23 |
Tu 11/23/99 |
Lecture 22 |
Concurrency control: transactions, locks.
|
|
|
|
Th 11/25/99 |
Thanksgiving break |
|
|
|
|
Tu 11/30/99 |
Independent work
on final project |
|
|
|
|
Th 12/2/99 |
Second written exam |
|
|
|
| 24 |
Tu 12/7/99 |
Lecture 23
|
Special Topic presentations I
|
|
|
| 25 |
Th 12/9/99 |
Lecture 24
|
Special Topic presentations II
|
|
|
| 26 |
Tu 12/14/99 |
Final Project Presentations
|
|
|
|