CSE 305 -- Principles of Database Systems

Fall 2009





Information for Students

Meeting Time and Place

M,W 5:20 - 6:40, Room: Computer Science Building, Room 2129 (Advanced Programming Lab)

Prerequisites

The official prerequisites of CSE 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

Yifan Peng, yipeng AT cs DOT sunysb DOT edu; Office Hours: Mon 4:00-5:00, Thu 2:00-3:00 in Room #2110 of the Computer Science Building.
Claude Castille (undergrad TA), claude.castille AT gmail DOT com; Office Hours: Tue 1:00-2:00 and 4:00-5:00 in Room #2110 of the Computer Science Building. Course Objectives
Introduce students to the design of database management systems through E/R design and the theory of normalization.
Discuss conceptual aspects of relational databases, such as relational algebra and query languages.
Through a significant project, allow student to gain experience in the design and implementation of a database system.

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 Disablility Support Services office, 128 ECC Building (631) 632-6748. They will review your concerns and determine, with you, what accommodations are necessary and appropriate. All information and documentation of disability 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 web site: http://www.ehs.sunysb.edu and search Fire Safety and Evacuation and Disabilities.

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.

Each student must pursue his or her academic goals honestly and be personally accountable for all submitted work. Representing another person's work as your own is always wrong. Any suspected instance of academic dishonesty will be reported to the Academic Judiciary. For more comprehensive information on academic integrity, including categories of academic dishonesty, please refer to the academic judiciary website at http://www.stonybrook.edu/uaa/academicjudiciary/ Adopted by the Undergraduate Council September 12, 2006


Useful links

Scott Smolka
Thu Aug 27 14:25:46 EDT 2009