$$\begin{array}{c} \mbox{\small\bf CS 387 -- Fall 2002} \\ [-0.... ...http://www.csis.pace.edu/\~\em scharff/cs387f2002)} \end{array}$$

Instructor:	Professor Christelle Scharff
Office:	163 William Street
	Floor 2 - Room 228
	New York, NY
Email:	cscharff@pace.edu
Class time:	Tuesday and Thursday 3:30-5:00pm
Classroom:	E323
Office Hours:	Tuesday and Thursday 5:00-6:00pm - Wednesday 3:00-6:00pm

Required Textbook: Databases and transaction processing - An application-oriented approach, Philip M. Lewis, Arthur Bernstein and Michael Kifer, Addison Wesley, ISBN 0-201-70872-8.

General Information:

CS 387 prepares you to face the real world of databases applications and developments.

It presents the fundamental concepts of database design. It provides a study of data models, data normalization; data description languages and their design and form, query facilities including relational algebra and query functions.

It will focus on the SQL query language (but it is not a course on SQL).

Prerequisite: A C or better in CS 232 and CS 242.

The Following CS 387 Policies are Strictly Enforced

Assignments: See http://www.csis.pace.edu/~scharff/cs387f2002 and ``Guidelines for All assignments''.

Examinations: There will be two learning experiences and a final examination.

Important Dates:

Learning Experience 1:	Tuesday, October 1st	3:30pm - 5:00pm
Learning Experience 2 :	Thursday, November 7th	3:30pm - 5:00pm
Final Exam:	Wednesday, December 18th	12:50-2:30 pm

Students must receive average on the combined average of learning experiences and final in order to pass the course. That is, a passing grade will not be awarded only on the basis of outstanding homeworks and project.

Learning experiences and final cover material from the lectures, homeworks and textbook.

Course Grades: Your overall course average for CS 387 will be computed using the following category weights:

Homeworks/Project Assignments	20%
Learning Experience 1	20%
Learning Experience 2	20%
Final Exam	30%
Participation	10%

Participation includes attendance, participation in the Discussion lists in Blackboard and surveys. Attendance is required. Over 3 absences without excuse will result in a reduction in grade for the semester. Those whose attendance is not regular, do not do well in this course in general.
Grades are computed the following way:

A	90-100
A-	88-90
B+	85-88
B	82-85
B-	80-82
C+	75-80
C	70-75
C-	65-70
D+	60-65
D	55-60
F	0-55

Academic Integrity: You are encouraged to discuss the intellectual aspects of assignments with one another. However, each individual is responsible for formulating a solution on his/her own. You must know the difference between cheating and discussing the intellectual aspects of an assignment. All students submitting the same or suspiciously similar assignments will receive a grade of zero and be penalized. The penalty for a second offense is failure in the course. Honesty is highly valued and dishonesty is punished. Furthermore those found to be cheating a second time are formally brought up on charges of academic dishonesty! (Please refer to the University rules and regulations regarding academic dishonesty).

Course Handouts and Lecture Slides: Course handouts will be available on the CS 387 web page (http://www.csis.pace.edu/~scharff/cs387f2002). Copies of lecture slides will be available on the WWW. It is your responsibility to print the lecture notes before each class.

Regrading of Learning Experiences and Homeworks: If you feel that a mistake was done in the grading of your Learning Experience or homework, you may make a written demand to be regraded.

Comments: All of the above regulations are binding on any student taking CS 387 during the Fall 2002 semester and they will be strictly enforced.