CSC 465-01: Database Management Systems
Spring 2003
TR 12:30 PM to 1:45 PM
Textbook:
Ramakrishnan & Gehrke, Database Management Systems, 3rd
Edition
|
Meeting Date |
Meeting Day |
Text Chapter(s) |
Lesson |
Assignment Due |
|
1/9/2003 |
Thursday |
Chapter 1 |
Introduction - Course Outline & Overview of Database Systems |
|
|
1/14/2003 |
Tuesday |
Chapter 1 & Chapter 2 |
Overview of Database Systems & Introduction to Database Design |
|
|
1/16/2003 |
Thursday |
Chapter 2 |
Introduction to Database Design |
|
|
1/20/2003 |
Monday |
Holiday |
Holiday |
|
|
1/21/2003 |
Tuesday |
Chapter 3 |
The Relational Model |
|
|
1/23/2003 |
Thursday |
Snow Day |
Snow Day |
|
|
1/28/2003 |
Tuesday |
Chapter 3 Review for Exam 1 |
The Relational Model Chapters 1-3 |
|
|
1/30/2003 |
Thursday |
Exam 1 |
Chapters 1-3 |
|
|
2/4/2003 |
Tuesday |
Chapter 4 |
Relational Algebra and Calculus |
|
|
2/6/2003 |
Thursday |
Chapter 4 |
Relational Algebra and Calculus |
|
|
2/11/2003 |
Tuesday |
Chapter 4 |
Relational Algebra and Calculus |
|
|
2/13/2003 |
Thursday |
Chapter 5 |
SQL: Queries, Constraints, Triggers |
|
|
2/18/2003 |
Tuesday |
Chapter 5 |
SQL: Queries, Constraints, Triggers |
|
|
2/20/2003 |
Thursday |
Chapter 5 |
SQL: Queries, Constraints, Triggers |
|
|
2/25/2003 |
Tuesday |
Review for Exam 2 |
Chapters 4, 5 |
|
|
2/27/2003 |
Thursday |
Exam 2 |
Chapters 4, 5 |
|
|
3/3/2003 |
Monday |
Spring Break |
Spring Break |
|
|
3/4/2003 |
Tuesday |
Spring Break |
Spring Break |
|
|
3/5/2003 |
Wednesday |
Spring Break |
Spring Break |
|
|
3/6/2003 |
Thursday |
Spring Break |
Spring Break |
|
|
3/7/2003 |
Friday |
Spring Break |
Spring Break |
|
|
3/11/2003 |
Tuesday |
Chapter 6 |
Database Application Development |
|
|
3/13/2003 |
Thursday |
Chapter 6 |
Database Application Development |
|
|
3/18/2003 |
Tuesday |
Chapter 19 |
Schema Refinement and Normal Forms |
|
|
3/20/2003 |
Thursday |
Chapter 19 |
Schema Refinement and Normal Forms |
|
|
3/25/2003 |
Tuesday |
Chapter 19 |
Schema Refinement and Normal Forms |
|
|
3/27/2003 |
Thursday |
Review for Exam 3 |
Chapters 6, 19 |
|
|
4/1/2003 |
Tuesday |
Review for Exam 3 |
Chapters 6, 19 |
|
|
4/3/2003 |
Thursday |
Exam 3 |
Chapters 6, 19 |
|
|
|
|
|
|
|
|
4/8/2003 |
Tuesday |
Chapter 12 |
Overview of Query Evaluation |
|
|
4/10/2003 |
Thursday |
Chapter 16 |
Overview of Transaction Management |
|
|
4/15/2003 |
Tuesday |
Chapter 16 |
Overview of Transaction Management |
|
|
4/17/2003 |
Thursday |
Chapter 8 |
Overview of Storage and Indexing |
|
|
4/18/2003 |
Friday |
Holiday |
Holiday |
|
|
4/22/2003 |
Tuesday |
Chapter 8 |
Overview of Storage and Indexing |
|
|
4/24/2003 |
Thursday |
Chapter 20 |
Physical Database Design and Tuning |
|
|
4/29/2003 |
Tuesday |
Chapter 20 |
Physical Database Design and Tuning |
|
|
5/1/2003 |
Thursday |
Last Day of Class Review for Final Exam |
Comprehensive |
|
|
5/5/2003 |
Monday 1:00 PM to 3:00 PM |
Final Exam |
Comprehensive |
|