CSE 305 -- Principles of Database Systems

Fall 2017

Information for Students

Meeting Time and Place

M,W 4:00 - 5:20, Room: Engineering 143


The prerequisites for CSE 305 are: C or higher in CSE 219 or CSE 260. You must also be a CSE major. Knowledge of Java, Javascript, JDBC, and HTML is also essential.


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


New CS Building, Room #249, ext. 2-8453

Office Hours

Monday 3:30-4pm, Wednesday 3:30-4pm and 5:30-6:30pm, or by appointment

Teaching Assistants

Amol Damare (TA): adamare AT cs DOT stonybrook DOT edu; Office Hours: MW 10:00-11:00am in Old CS Room 2217
Arjun Krishna (half-TA): arjkrishna AT cs DOT stonybrook DOT edu; Office Hours: Thursdays 3:00-4:00pm in Old CS Room 2217
Kishan Nerella (Grader): knerella AT cs DOT stonybrook DOT edu; Office Hours: Tuesdays 2:50-3:50pm in Old CS Room 2217
Himanshu Kattelu (Undergraduate TA). Office Hours: Wednesdays 3:00-4:00pm in Old CS Room 2217

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.

The official course objectives and catalog description are available here.


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 & XHTML: The Definitive Guide, Sixth Edition, O'Reilly & Associates, Inc. ISBN-13: 978-0596527327.

D. Flanagan, Java in a Nutshell, Fifth Edition, O'Reilly & Associates, Inc. ISBN-13: 978-059600773.

G. Reese, Database Programming with JDBC and Java, Second Edition, O'Reilly & Associates, Inc. ISBN-13: 063-6920926160.

Course Syllabus

A schedule of the class lectures can be found here.

Course Overview Drawing

A quick overview of the course can be found here and here. An E-R diagram for the Student Registration system can be found here. An overview of Chapter 7 (Triggers) can be found here.

Will Cusick's Course Checklist

Will was a student in CSE 305, Fall 2015, and was the undergraduate TA for Spring 2016. His checklist for doing well in the course is 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. For help or more information go to the Blackboard Basics web site.


You can use Piazza for class discussion. If you have any problems or feedback for the developers, email team@piazza.com. Find our class page 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 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 Old CS Building, but a substantial part of it if not the entire project can be done on your laptop. The programming project will count an additional 30% of your final grade.

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

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://studentaffairs.stonybrook.edu/dss/accessibility/emergencies.shtml


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/commcms/academic_integrity

Phone Policy

All electronic devices must be muted and/or silenced during class. Thank you for your cooperation.

Useful links

Scott Smolka
Tue Sep 12 14:25:46 EDT 2017