Date	Topic	Reading Assignment
January 11	Introduction	Chapter 1
January 18, University Closed (Martin Luther King Jr. Day)
January 25	ER Model	Chapter 2 Oracle Account Setup
February 1	Relational Model	Chapter 3
February 8	SQL	Chapter 5
February 15	Laboratory	Lab Assignment Lab Answers Lab PowerPoint Oracle Admin Guide SQL Reference PL/SQL Reference
February 22	Normal Forms	Chapter 19
March 1	Midterm Exam	Quiz Solution Problem 1 Quiz Solution Problem 2 Midterm Solution
March 8, No Classes (Spring Break)
March 15	DB Programming and JDBC	Chapter 6 Chapter 7
March 22	Data Warehouse Conceptual Design	Case Study (Section 3) Data Warehouse Overview OLAP Videos
March 29	Data Warehouse Physical Design	Design Reading (Chapters 1-3, 6-8, 10) Data Warehouse Design
April 5	Query Optimization/Indexing	Chapter 12 Bitmap B-tree Bitmap paper (not required)
April 12	DBA and Database Tuning	DBA Reading
April 19	Guest Lecture	Robin Weaver, ITS, UNC Charlotte
April 26	Project Presentations
May 3	Project Presentations
May 10	Final Exam	8-10:30pm Textbook Problem Solutions

Return to the Course Home Page