January |
February |
March |
April |
May |
| Tuesday | Thursday |
| Jan 18
Introduction (Chapters 1 & 2) |
Jan 20
DB Design Overview (Chapter 16) |
| Jan 25
Assign: Project Phase 1 Project Overview and Teams |
Jan 27
ER Model (Chapter 3) |
| Tuesday | Thursday |
| Feb 01
ER Model (Chapter 3) Study Problems |
Feb 03
Relational Introduction (Chapter 7) |
| Feb 08
Due: Tutorial Introduction to MS Access Chapter 10.7 |
Feb 10
Due: Phase 1 Intermediate Relational Algebra (Chapter 7) |
| Feb 15
Return: Phase 1 Intermediate Assign: Homework 1 WinRDBI Relational Algebra (Chapter 7) |
Feb 17
Relational Algebra (Chapter 7) |
| Feb 22
Due: Phase 1 Assign: Phase 2 Phase Summary Presentations Relational Algebra (Chapter 7) |
Feb 24
Query Optimization (Chapter 18) Phase Summary Presentations |
| Feb 29
Due: Homework 1 Return: Phase 1 Relational Design (Chapter 14 & 15) Phase Summary Presentations |
| Tuesday | Thursday |
| Mar 02
Relational Design (Chapter 14 & 15) Phase Summary Presentations |
|
| Mar 07
Return: Homework 1 Deadline:Regrade Phase 1 Exam Review Relational Design (Chapter 14 & 15) |
Mar 09
Midterm Exam |
| Mar 14
Spring Break |
Mar 16
Spring Break |
| Mar 21
Deadline: Regrade Homework 1 Relational Design (Chapter 14 & 15) |
Mar 23
Due: Phase 2 Intermediate Return: Midterm Relational Design (Chapter 14 & 15) |
| Mar 28
Return: Phase 2 Intermediate TRC/DRC (Chapter 9) |
Mar 30
Assign: Homework 2 Deadline: Regrade Midterm TRC/DRC (Chapter 9) |
| Tuesday | Thursday |
| Apr 04
Due: Phase 2 Assign: Phase 3 TRC/DRC Study Problems |
Apr 06
SQL (Chapter 8) |
| Apr 11
Return: Phase 2 SQL (Chapter 8) |
Apr 13
Due: Homework 2 Assign: Homework 3 SQL (Chapter 8) |
| Apr 18
Due: Phase 3 Intermediate Deadline: Regrade Phase 2 Transactions (Chapter 19) System Catalog (Chapter 17) |
Apr 20
Return: Homework 2 Return: Phase 3 Intermediate Recovery (Chapter 21) |
| Apr 25
Due: Homework 3 Concurrency Control (Chapter 20) |
Apr 27
Deadline: Regrade Homework 2 Concurrency Control (Chapter 20) |
| Tuesday | Thursday |
| May 02
Due: Phase 3 Return: Homework 3 Security and Authorization (Chapter 22) Exam Review Evaluation |
May 04
Final Exam 7:40am-9:30am |
