Chris Pollett>Old Classes>CS220, Fall 1998

Computer Science 220
Database Management and Systems Design

Fall 1998 Syllabus/Homepage

Last modified 08/31/98

Instructor

Chris Pollett
CH 126
Ext 7344.

Office Hours

TR 2:20-3:50pm

Classroom and Meeting Times

Classes meet TR 11:50am - 1:05pm in JC102.

Required Textbooks

Other Useful Textbooks

These texts are not required. However, interested students may want to look at them.

Prerequisites

To enroll in this course, you must have taken CSCI 160.

Topics

The purpose of this course is to introduce the student to the design, implementation, and theory of database systems. Topics to be discussed include the entity-relationship approach, storage structures such as hashes, indexes, B+-trees, the relational data model, SQL, normalization, query processing and optimization, concurrency control and recovery techniques.

Grade Breakdown

Homeworks    40% 
Midterm      30%    
Final        30%

Important dates

The midterm will be Oct. 27.

Homework Assignments

Homework will generally be given every week or two and will be a mixture of written assignments and programming assignments.

Late Policy

In general, you will have at least one week to work on a homework assignment and two opportunities to attend my office hours before a given assignment is due.

Late homeworks will not be accepted; however, your low homework score will be dropped.

Exams

As shown above in the grade breakdown there will be both a midterm and final in this course. The final will cover only material from the second half or the semester. These exams will test whether or not the student has mastered the material both presented in class or assigned as homework during the semester. I will try to avoid both tricky and ambiguous questions. The week before each exam I will try to give out a list of problems representative of the level of difficulty of problems the student will be expected to answer on the exam.

Homework Sets

| HW1| HW2| HW3| HW4| HW5|

Some Useful Links

Prepared by Chris Pollett.