CSE 305 -- Principles of Database Systems

Fall 2023






Information for Students

Meeting Time and Place

M,W 4:00 - 5:20. Classes will be delivered synchronously online via zoom and recorded to the cloud for asynchronous viewing. You can access the recordings here. Here are the instructions for joining the zoom meeting:

Join Zoom Meeting
https://stonybrook.zoom.us/j/91242641510?pwd=VHZ1UkVzd3BIZEJjRkVuZG\ NXRmRMQT09

Meeting ID: 912 4264 1510
Passcode: 874858
One tap mobile
+16468769923,,91242641510# US (New York)
+16469313860,,91242641510# US

Prerequisites

The prerequisites for CSE 305 are: C or higher in CSE 216 or CSE 260; CSE major.

Instructor

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

Office

New CS Building, Room #249

Office Hours

Wednesday 3-4pm and 5:20-6:20pm, or by appointment. Office hours will be held online using zoom:

Join Zoom Meeting
https://stonybrook.zoom.us/j/98885420688?pwd=ZldKTFlpSnNTSlZjUTBSVkdHaG8wdz09

Meeting ID: 988 8542 0688
Passcode: 375098
One tap mobile
+16468769923,,98885420688# US (New York)
+16469313860,,98885420688# US

Teaching Assistants

Sijie Ding (TA); sijding@cs.stonybrook.edu; Office Hours: Mon 9-11pm, Personal Zoom Room

Varun Vora (TA); vvora@cs.stonybrook.edu; Office Hours: Tue, Thu 3:00-4:00pm, Personal Zoom Room

Sairam Reddy (TA); ssudireddy@cs.stonybrook.edu; Office Hours: Wed, Fri 9-10am, Personal Zoom Room

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.

Textbook

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

W. Lemahieu, S. Vanden Broucket, and B. Baeses, Principles of Database Management, Cambridge University Press, 2018. This book is not required. Chapter 11 serves as an excellent NoSQL reference.

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 Brightspace Site

You can access class information on-line at: https://it.stonybrook.edu/services/brightspace. From there, you will be able to launch Brightspace and also find resources for students, including tips for students and a link that will let you download the Brightspace mobile app, which is called Pulse.

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: There will be three programming assignments involving the design and implementation of a working database systems. These assignments will count for 30% of your final grade. Programming assignment no. 3 will involve implementing JDBC connectivity with your database, fetching/updating the data, and encapsulating the results in the form of Java Objects. The application logic for rendering the data from the Java Objects to the GUI is handled by the existing project code provided by the TA.

Exams: The remainder of your final grade will be based on the mid-term (25%) and final exam (30%). Both exams will be held online using Brightspace and the Respondus lockdown browser. Details to be provided on Brightspace.

Our course is using Respondus LockDown Browser and Monitor for exams. You must install Respondus Lockdown Browser for Stony Brook, available here, prior to the start of the first exam. Should you need help during the exam, click the chat button on the bottom of the screen.

Required Syllabi Statements

The University Senate has authorized that the following required statements appear in all teaching syllabi on the Stony Brook Campus. This information is also available at http://www.stonybrook.edu/commcms/provost/faculty/handbook/academic_policies/syllabus_statement.php

Student Accessibility Support Center Statement: If you have a physical, psychological, medical or learning disability that may impact your course work, please contact Student Accessibility Support Center, Stony Brook Union, Suite 107, (631) 632-6748, or at https://www.stonybrook.edu/sasc/. 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 Student Accessibility Support Center. For procedures and information go to the following website: http://www.stonybrook.edu/ehs/fire/disabilities and search Fire Safety and Evacuation and Disabilities..

Academic Integrity Statement: Each student must pursue their academic goals honestly and be personally accountable for all submitted work. Representing another person's work as your own is always wrong. Faculty is required to report any suspected instances of academic dishonesty to the Academic Judiciary. Faculty in the Health Sciences Center (School of Health Technology & Management, Nursing, Social Welfare, Dental Medicine) and School of Medicine are required to follow their school-specific procedures. For more comprehensive information on academic integrity, including categories of academic dishonesty please refer to the academic judiciary website at https://www.stonybrook.edu/commcms/academic_integrity/index.html

Critical Incident Management: Stony Brook University expects students to respect the rights, privileges, and property of other people. Faculty are required to report to the Office of University Community Standards any disruptive behavior that interrupts their ability to teach, compromises the safety of the learning environment, or inhibits students' ability to learn. Faculty in the HSC Schools and the School of Medicine are required to follow their school-specific procedures. Further information about most academic matters can be found in the Undergraduate Bulletin, the Undergraduate Class Schedule, and the Faculty-Employee Handbook.

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 their 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.

Phone Policy

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

Useful links


Scott Smolka
Sun Sep 3 14:25:46 EDT 2023