The design of database management systems to obtain consistency, integrity, and availability of data. Conceptual models and schemas of data: relational, hierarchical, and network. Students undertake a semester project that includes the design and implementation of a database system. (https://www.cs.stonybrook.edu/students/Undergraduate-Studies/courses/CSE305)
Instructor: Dr. Paul Fodor
214 New Computer Science Department, Stony Brook University
Office hours: Tuesdays and Thursdays 5:00PM-6:30PM
Phone: 1 (631) 632-9820
Email: paul.fodor@stonybrook.edu
Class email (forwarded to all the instructors and teaching assistants, fast response): cse305ta@cs.stonybrook.edu
| Week | Date | Lecture Topics/Notes | Readings |
| 1 | Mo. 8/29 | Administrative information | ABET |
| Wed. 8/31 | Overview and History of Databases and Transactions | Chapter 1 | |
| 2 | Mo. 9/5 | No classes in Session (after Labor Day - Observed) | See Stony Brook Calendars here: http://www.stonybrook.edu/commcms/registrar/calendars/academic_calendars.html |
| Wed. 9/7 | Relational Databases: the Big Picture | Chapter 2 | |
| 3 | Mo. 9/12 | The Relational Data Model | Chapter 3 |
| Wed. 9/14 | The Relational Data Model (cont.) | n/a | |
| 4 | Mo. 9/19 | The Relational Data Model (cont.) | n/a |
| Wed. 9/21 | Conceptual Modeling of Databases with Entity-Relationship Diagrams and Unified Modeling Language | Chapter 4 | |
| 5 | Mo. 9/26 | Conceptual Modeling of Databases with Entity-Relationship Diagrams and Unified Modeling Languag (cont.) | n/a |
| Wed. 9/28 | Relational Algebra & SQL | Chapter 5 | |
| 6 | Mo. 10/3 | Relational Algebra & SQL (cont.) | n/a |
| Wed. 10/5 | Midterm Review | See Blackboard here:http://blackboard.stonybrook.edu | |
| 7 | Mo. 10/10 | MIDTERM EXAM 1 | n/a |
| Wed. 10/12 | Relational Algebra & SQL (cont.) | n/a | |
| 8 | Mo. 10/17 | Relational Algebra & SQL (cont.) | n/a |
| Wed. 10/19 | Using SQL in an Application (JDBC) | Chapter 8 | |
| 9 | Mo. 10/24 | Java Servlets and JDBC | n/a |
| Wed. 10/26 | Java Server Pages | n/a | |
| 10 | Mo. 10/31 | J2EE Intro. | n/a |
| Wed. 11/2 | Database Design with The Relational Normalization Theory | Chapter 6 | |
| 11 | Mo. 11/7 | Database Design with The Relational Normalization Theory (cont.) | n/a |
| Wed. 11/9 | Midterm Review | See Blackboard here:http://blackboard.stonybrook.edu | |
| 12 | Mo. 11/14 | MIDTERM EXAM 2 | n/a |
| Wed. 11/16 | Database Design with The Relational Normalization Theory (cont.) | n/a | |
| 13 | Mo. 11/21 | Triggers and Active Databases | Chapter 7 |
| Wed. 11/23 | Thanksgiving Break - No classes in Session | See Stony Brook Calendars here: http://www.stonybrook.edu/commcms/registrar/calendars/academic_calendars.html | |
| 14 | Mo. 11/28 | File Organization and Indexing | n/a |
| Wed. 11/30 | Implementation of Relational Operations | n/a | |
| 15 | Mo. 12/5 | Relational Query Optimization | n/a |
| Wed. 12/7 | Final review | See Blackboard here:http://blackboard.stonybrook.edu | |
| Final | Tu., 12/13 | FINAL EXAM: 8:30pm-10:30pm, in classroom | See Final Exams University Schedule here: http://www.stonybrook.edu/commcms/registrar/registration/exams.html |
If you have a physical, psychological, medical or learning disability that may impact your course work, please contact Disability Support Services, ECC (Educational Communications Center) Building, room 128, (631) 632-6748. They will determine with you what accommodations, if any, 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.stonybrook.edu/ehs/fire/disabilities
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. Faculty are 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 http://www.stonybrook.edu/commcms/academic_integrity/index.html
Stony Brook University expects students to respect the rights, privileges, and property of other people. Faculty are required to report to the Office of Judicial Affairs 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.