| Date | Reading | Lecture Topic | Assignment |
| 1/14 1/16 |
Chap 1 Chap 2 |
Introduction to databases Concepts and architecture |
Suggested: p.23: 1.1, 1.2, 1.9, 1.10 |
| 1/19 1/21 1/23 |
Sect 5.1 Sect 6.1-6.3 |
Holiday Relational model concepts Relational algebra |
Suggested: The 7 queries in Section 6.5 Page 186, # 6.16; due 1/30 |
| 1/26 1/28 1/30 |
Sect 6.4-6.5 Sect 5.2-5.4 |
Relational algebra Data Integrity Solutions to RA problems |
|
| 2/2 2/4 2/6 |
Sect 8.1-8.3 Sect 8.4 |
Exam 1 Data definition in SQL Basic SQL queries |
Create the tables for the Company database Data file to insert values |
| 2/9 2/11 2/13 |
Sect 8.5-8.8 Chap 9 |
Using PostGRE Nested queries and Outer joins Views |
Assignment 1 due 2/20/04 |
| 2/16 2/18 2/20 |
Chap 3 Chap 3 |
Holiday Data modeling ER diagrams |
Assignment 2 due: 3/1/04 |
| 2/23 2/25 2/27 |
Chap 4 Chap 10 Chap 10 |
ER diagrams and ER to relational mapping Practice with ER diagrams Functional dependencies |
|
| 3/1 3/3 3/5 |
Chap 10 Chap 10 Chap 10 |
Functional dependencies Normal forms Boyce-Codd normal forms |
Assignment 3 due: 3/8/04 |
| 3/8 3/10 3/12 |
|
Review Exam 2 Discussion of projects |
Project |
| 3/15-19 | Spring Break | ||
| 3/22 3/24 3/26 |
Chap 13 Chap 14 Chap 14 |
File organization Disk files Index structures |
|
| 3/29 3/31 4/2 |
Chap 14 Chap 15 Chap 15 |
B+ trees Query processing Query optimization |
|
| 4/5 4/7 4/9 |
Chap 16 Chap 17 |
DB design and tuning Transaction processing concepts Holiday |
|
| 4/12 4/14 4/16 |
Chap 17 Chap 18 Chap 18 |
Transaction processing theory Concurrency control Concurrency control |
|
| 4/19 4/21 4/23 |
Chap 19 Chap 20 Chap 22 |
DB recovery techinques Object-relational DB Object-relational DB |
|
| 4/26 4/28 4/30 |
Review Project demos Project demos |
|