CSE/ISE 305 -- Principles of Database Systems

Spring 2009





Information for Students

Meeting Time and Place

M,W 5:20 - 6:40, Room: Computer Science Buidling, Room 2311 (Wireless Seminar Room)

Prerequisites

The official prerequisites of CSE/ISE 305 are CSE 219 and CSE 220. 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 4:50pm-5:20pm and 6:40pm-7:40pm, or by appointment

Teaching Assistants

Xin Zhao, xinzhao AT cs DOT sunysb DOT edu; Office Hours: Tu,Th 11:30-1:00, in Room #2206 of the Computer Science Building.
Jonathan Farrell (undergrad TA), jc.farrell AT hotmail DOT com; Office Hour: Tue 1:00-2:00, in Room #2110 of the Computer Science Building.
Claude Castille (undergrad TA), claude.castille AT gmail DOT com; Office Hour: Thu 1:00-2:00, in Room #2110 of the Computer Science Building.

Textbooks

Michael Kifer, Arthur Bernstein and Philip Lewis, Database Systems: An Application Oriented Approach, Introductory Version, 2/E, Addison-Wesley, 2005. ISBN 0-321-22838-3

The next three books are optional, and are listed as handy references.

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.

Access to Class's Blackboard Site

You can access class information on-line at: http://blackboard.sunysb.edu. If you have used Stony Brook's Blackboard system previously, your login information (Username and Password) has not changed. If you have never used Stony Brook's Blackboard system , your initial password is your SOLAR ID# and your username is the same as your Campus Net ID , which is generally your first initial and the first 7 letters of your last name (if you have a sparky account, it's your username). For help or more information go to the Blackboard Student Helpdesk web site. For problems logging in, go to the helpdesk in the Main Library SINC Site or the Union SINC Site; you can also call: 631-632-9602 or e-mail the Helpdesk.

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 course 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 three homework assignments. They will count for 15% 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 and Undergraduate Transaction Processing Labs, Room 2114 and 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 (25%).

If you have a physical, psychological, medical, or learning disability that may impact your course work, please contact Disability Support Services at (631) 632-6748 or http://studentaffairs.stonybrook.edu/dss/. They will determine with you what accommodations are necessary and appropriate. All information and documentation is confidential.

Students who require assistance during emergency evacuation are encouraged to discuss their needs with their professors and Disability Support Services. For procedures and information go to the following website: http://www.sunysb.edu/ehs/fire/disabilities.shtml

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
Wed Jan 27 14:25:46 EDT 2009