CSE 532 -- Graduate Database Systems

Spring 2000





Information for Students

Meeting Time and Place

M,W 3:20 - 4:40, Room: Humanities 304

Prerequisites

The official prerequisites of CSE 532 are CSE 303. Knowledge of Java, Javascript, JDBC, and HTML is also essential.

Instructor

Scott A. Smolka: sas AT cs DOT sunysb DOT edu, http://www.cs.sunysb.edu/~sas/

Office

Computer Science Building, Room #1423, ext. 2-8453

Office Hours

M,W 5:00-6:00, or by appointment

Teaching Assistants

Gang Peng, Computer Science Building, Room #1208, gpeng AT cs DOT sunysb DOT edu; Office Hours: Tu 12:00-2:00 pm and Thu 1:00-2:00 pm.

Textbooks


Raghu Ramakrishnan, Database Management Systems, Second Edition, McGraw-Hill, 2000. ISBN 0-07-232206-3

Raghu Ramakrishnan, Lecture Slides for the textbook Database Management Systems. Copies available for purchase from the Campus Bookstore.

C. Musciano and B. Kennedy, HTML, The Definitive Guide, Second Edition, O'Reilly & Associates, Inc. ISBN 1-56592-235-2.

D. Flanagan, Java in a Nutshell, Second Edition, O'Reilly & Associates, Inc. ISBN 1-56592-262-X.

G. Reese, Database Programming with JDBC and Java, O'Reilly & Associates, Inc. ISBN 1-56592-270-0.

Course Syllabus

A schedule of the class lectures can be found here.

Course Work

The following, which is subject to change, is a summary of the work required for this course.

Reading Assignments: The topics discussed in the lectures correspond to the various chapters of the Ramakrishnan text. The order is different as I will try to expose you to the material you need to get going on your course project as early on in the semester as possible. The course outline gives the approximate dates for each major topic to be discussed. You are responsible for reading the appropriate chapter from the text and the appropriate set of transparencies from the lecture notes before each class.

Homework Assignments: There will be two or three homework assignments. They will count for 10% of your final grade.

Programming Assignments: You will design and implement a working database system using HTML for the user interface, Sybase for the remote database server, and Java, Javascript and JDBC for connectivity between the user interface and database server. The project will be carried out in the Graduate Transaction Processing Lab, Room  1239 of the Computer Science Building, but a substantial part of it can be done on your home PC, if you own one. The programming project will count an additional 25% of your final grade.

Exams: The remainder of your final grade will be based on the final exam (35%) and a mid-term (30%).

If you have a physical, psychological, medical or learning disability that may impact on your ability to carry out assigned course work, I would urge that you contact the staff in the Disabled Student Services office (DSS), Room 133, Humanities, 632-6748v/TDD. DSS will review your concerns and determine with you what accommodations are necessary and appropriate. All information and documentation of disability are confidential.

Grading


NO INCOMPLETES will be given for this course.
Late homeworks and programming assignments will be penalized, on the order of 5% off for each business day late.
Collaboration on assignments and exams is not permitted. Students found in violation of this rule of conduct will automatically receive an F on the assignment or exam in question. Two such incidents, over the course of your stay at Stony Brook, will lead to automatic expulsion from the Graduate Program.


Useful links

Scott Smolka
Mon Jan 17 14:25:46 EDT 2000