CS532 Database Systems Syllabus
Fall 2009
Department of Computer Science
T.J. Watson School of Engineering
State University of New York at Binghamton
Instructor
Name: KD Kang
Office: T16, Engineering Building
Office Hours: 11:30am - 12:30pm, Tuesday and Thursday or by appointment
Telephone: 777-4368
Fax: 777-4729
Email: kang@binghamton.edu
Web: http://www.cs.binghamton.edu/~kang
TA
Name: Reza T. Hemayati
Email: reza.hemayati@gmail.com
Office Hours: 5:30pm-6:30pm Monday and Noon-1pm Wednesday in N1
Course Description
Database systems are a backbone for information systems. Many information systems such as financial/banking systems, web servers, and e-commerce systems rely on database
systems. This course will cover fundamental topics in database systems: (1) association between data elements and data models, (2) entity-relationship, relational, and
object-relational database design techniques, (3) formal and commercial query languages, and (4) introduction to query processing, transaction management, and concurrency
control.
Class Time and Place
Time: 10:05 am - 11:30 am Tuesday and Thursday
Classroom: Appalachian Collegiate Center G015
Prerequisite
CS333 or equivalent
Textbook
No textbook is required but the following books will be used as the primary reference books.
- Fundamentals of Database Systems by R. Elmasri, and S. Navathe, 5th edition (Theory)
- Oracle10g Programming - A Primer by R. Sunderraman (SQL Programming in Oracle)
The instruction will be primarily based on the Lecture Notes for CS532.
Planned topics
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 Features
- Chapter 10: Index Structures and Index Creation
- Chapter 11: Query Processing
- Chapter 12: Transaction Management
- Chapter 13: Concurreny Control
Projects
Two 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 using Oracle's SQL*Plus.
- Project 2: You will write an application program using PL/SQL and JDBC.
Grading policy
- Homework: 25%
- Midterm: 20% (in the 8th week)
- Projects: 30%
- Final: 25%
All late homeworks and projects will be penalized 10% per day (including weekends and holidays) and no assignment will be accepted, if it is more than 3 days late unless
compelling reasons are presented.
Academic Honesty
Academic honesty and integrity are expected of every student. Dishonesty and cheating in all academic work related to this course, when discovered, will be severely
punished. Please read the Student Academic Honesty Code at http://watson.binghamton.edu/Watson_Academic_Honesty_Policy.pdf.
Attendance and Other Classroom Policies
- Attendance is mandatory. Please inform the instructor of any expected absence.
- No cell phone usage is allowed except emergency.
- No laptop usage is allowed.
Additional Readings
The following are some of the leading database journals and conferences:
- 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)