Prerequisites:
CS402 or equivalent. It is assumed that each student has an extensive programming background. Failure to having such a background is likely to result in a failing grade.

Text:
There is no required book for this course. I will be using transparencies to teach the class. All the transparencies are available in pdf format here. This is an introductory course; hence, all of this material can be read in any "Introduction to Database Management Systems" book.

Grading:

Presentation	20%	Nov. 5 & 19, 2003
Group Project	35%	Demo date: Dec. 3, 2003
Examination	45%	Nov. 12, 2003

Academic Integrity:
Each member of this course bears responsibility for maintaining the highest standards of academic integrity. All breaches of academic integrity must be reported immediately.

Late Assignment Policy:
Assignments must be submitted on or before their due date. No late assignments will be assigned a grade.

Class Participation:
Students who actively participate in class will receive consideration should their final grades be on the borderline.

Group Project:
Students will implement a relational DBMS with a reasonable amount of functionality. Several thousand lines of code are common for this sort of project, and it typically consumes quite a bit of the semester. The project is meant to illuminate the internal working of a relational DBMS. Deliverables along the way will include a preliminary design document, a project management plan, and a detailed design document. A demonstration given to the instructor and the teaching assistant is required at the end of the semester. A poor project will almost certainly result in a poor grade for the entire course. Groups will consist of no more than three students.

Research Presentation:
Additional information about the research presentation will be provided as the semester progresses. Each pair of students working together will present a 20-minute overview of a technical research paper in the areas of information retrieval, data mining, or data warehouse. All students listening to the presentations must submit a one paragraph summary for each of the eight presentations of their choice. Each student's grade will be based on a composition of their individual group presentation and their presentation summaries. Presentation summaries will be authored individually. Students must suggest their own topic and must get approval for the given topic by October 22, 2003. Class presentations will be held on November 5 & 19, 2003. All presentations will be done in front of the entire class.

Introduction	1 - 44
SQL	45 - 122
Database Design	123 - 188
Query Optimization	189 - 211
Recovery and Concurrency Control	212 - 233
Integration of Structured Data and Text	234 - 241
Distributed Database Systems	242 - end
Information Retrieval / Data Mining / Warehouse	Class