CIS 761. Database Management Systems

Spring 2006 Syllabus

Course Home page

http://www.cis.ksu.edu/~tamtoft/CIS761/S06/index.html.

There also is a mailing list with the address cis761-l HAT listserv dot ksu dot edu for questions and issues of general interest.

Where, When, Who?

Classes

127 Nichols Hall, MWF 2:30-3:20PM.

Instructor

Torben Amtoft, tamtoft HAT cis dot ksu dot edu, www.cis.ksu.edu/~tamtoft, 219C Nichols Hall, ph. 532-6350.
Office hours are Tuesdays and Thursdays 1pm-2pm, and by appointment.

Teaching assistant

Chaitanya Kurada, kurada HAT ksu dot edu, www.cis.ksu.edu/~kurada, N19 (TA room) in Nichols Hall.
Office hours are Monday/Wednesday/Friday, 11am-noon, and by appointment.

Text

Abraham Silberschatz and Henry F. Korth and S. Sudarshan, Database System Concepts, 5th edition, McGraw-Hill. ISBN 0-07-295886-3. This text is available in the KSU Union Bookstore. The book has a web page at http://codex.cs.yale.edu/avi/db-book/db5/index.html

Course objectives

At the conclusion of the course, students should have a good understanding of many advanced concepts necessary for designing, using, and implementing database systems.

Prerequisites

In principle, you should have taken CIS 560, but it is enough that you have a bit of familiarity with databases, in particular know basic SQL. Also, you should have a bit of mathematical background, in particular be familiar with reasoning about sets. If you do not meet these requirement, you should see the instructor immediately.

Tentative Course Outline

Introduction
Chapter 1 (1 class)
The Relational Model
Chapter 2 (3 classes)
SQL
Chapters 3 & 4 (4 classes)
Other Relational Languages
Chapter 5 (3 classes)
Design and the ER model
Chapter 6 (3 classes)
Relational Database Design
Chapter 7 (6 classes)
Application Design
Chapter 8 (2 classes)
Data Mining and Information Retrieval
Chapters 18 & 19 (4 classes)
Indexing and Hashing
Chapters 11&12 (3 classes)
Query Processing and Optimization
Chapters 13&14 (4 classes)
Transaction Management
Chapters 15&16 (&17) (4 classes)
Database-System Architectures
Chapter 20 (1 class)

Grading and Exams

Homework
There will be assignments due for most weeks, usually minor but there might also be one or more substantial projects.
Exams
In addition to the final, there will be a midterm (probably with a take-home part).
Grades
The final counts 35%, the midterm counts 35%, the assignments counts 20%, class participation counts 10%.

Policies on Academic Conduct

All students are expected to do their own work on the homeworks and exams. Cooperation on the project should not go beyond a discussion of the problem. Please refer to the KSU Campus Phone book which contains the Student Life Handbook. You are governed by these guidelines and procedures.

Acknowledgment and notice of copyright

This syllabus, and much of the material used in the course, is adapted from the one taught by Maria Zamfir Bleyberg. During this course students are prohibited from selling notes to or being paid for taking notes by any person or commercial firm without the express written permission of the professor teaching this course.

Torben Amtoft