CS432/CS532 Database Systems Syllabus
Department of Computer Science
T.J. Watson School of Engineering
State University of New York at Binghamton
Class Time and Place
- Time: 1:15 PM - 2:40 PM Tuesday & Thursday
- Classroom: LN2447
- Name: KD Kang
- Office: EB Q10
- Office Hours: 4PM - 5PM on Tuesday and Thursday or by appointment
- Phone: (607) 777-4368
- Email: firstname.lastname@example.org
- Web: http://www.cs.binghamton.edu/~kang
- Name: Gourav Rattihalli
- Email: email@example.com
- Office: G25
- Office Hours: 6 pm - 7 pm on Wednesday and 11 am - 12 pm on Friday
This course will cover fundamental topics in database systems including:
association between data elements and data models such as
entity-relationship, relational, and object-relational models; formal
and commercial query languages; introduction to query processing,
transaction management, and concurrency control.
CS375: Design and Analysis of Algorithms or equivalent
No textbook is required; however, the following book will be used as
the primary reference book.
The instruction will be primarily based on the instructor's Lecture Notes that
can be downloaded from Blackboard.
- Database Systems by M. Kifer, A. Bernstein, and P. M. Lewis,
There are many database textbooks available and any of them can be used
as supplementary reading.
- Fundamentals of Database Systems (6th edition), by R. Elmasri, and S. Navathe
- Oracle10g Programming – A Primer by R. underraman
- Database Systems: An Application-Oriented Approach (2nd edition) by M. Kifer, A. Bernstein, P. Lewis
- Principles of Database and Knowledge-base Systems (Volume I and II), J. Ullman
- Database System Concepts, H. Korth and A. Silberschatz
- Database: Principles, Programming, Performance, O'Neil and O'Neil
- A First Course in Database Systems, Ullman and Widom
The topics are arranged according to the lecture notes, not according to the textbook.
- Chapter 1: Introduction
- Chapter 2: ER Model
- Chapter 3: Relational Model
- Chapter 4: Transform ER Schema to Relational Schema
- Chapter 5: Table Normalization
- Chapter 6: Relational Algebra
- Chapter 7: SQL
- Chapter 8: PL/SQL
- Chapter 9: ORDB
- Chapter 10: Index Structures and Index Creation
- Chapter 11: Query Processing
- Chapter 12: Transaction Management
- Chapter 13: Concurreny Control
Three projects will be assigned during the semester.
Some knowledge of Java programming language is required for the second project.
- Project 1: You will write SQL queries in Oracle.
- Project 2: You will develop an application program using SQL,
PL/SQL, and Java.
- Six Homework Assignments: 24%
- Midterm: 20% (7th or 8th week)
- Projects: 31%
- Final: 25%
- All late homeworks and projects will be penalized 5% per day (including
weekends and holidays) and no assignment will be accepted if it is
more than 3 days late unless compelling reasons can be presented.
Sometimes no late assignment will be accepted.
- If regrading is requested, the entire homework, project,
or exam will be regraded. As a result, it is possible for your
grade to decrease, increase, or stay the same. Even if the
grade decreases, it is final. Also, no regrading request
will be accepted after two weeks since the grade is assigned.
Expected Weekly Effort
- Classroom Instruction: 3 hours
- Outside classroom effort (reading/working on homeworks and projects): approximately 10 hours.
Academic honesty and integrity are expected of every student. Dishonesty
and cheating in all academic work reldated to this course, when
discovered, will be severely punished. Please read the Student
Academic Honesty Code available here.
Attendance and Other Classroom Policies
- Attendance of every class is required and will be checked on a
random basis. Each unexcused absence will result in a two-point penalty
from the final overall score. An absence is counted if a student is not
in the classroom when the attendance is checked. If you have six or more
additional unexcused absences, you automatically fail the course.
Certain absences may be excused with prior consent from the instructor.
Please inform the instructor of any expected absence in advance.
- A laptop, tablet, or cell phone cannot be used in class.
- ACM Transactions on Database Systems (ACM TODS)
- IEEE Transactions on Knowledge and Data Engineering (IEEE TKDE)
- International Conference on Very Large Data Bases (VLDB)
- International Conference on the Management of Data (ACM SIGMOD)
- IEEE International Conference on Data Engineering (ICDE)