CIS 761. Database Management Systems

Spring 2004 Syllabus

Course Home page

http://www.cis.ksu.edu/~tamtoft/761S04/index.html.

There also is a mailing list with the address cis761 at cis.ksu.edu for questions and issues of general interest.

Where, When, Who?

Classes

122 Nichols Hall, MWF 11:30AM-12:20PM.

Instructor

Torben Amtoft, tamtoft at cis.ksu.edu, www.cis.ksu.edu/~tamtoft, 216 Nichols Hall, ph. 532-6350.
Office hours are Mondays and Wednesdays 4pm-5pm, and by appointment.

Teaching assistant

Vivek Subramaniam, viveks at cis.ksu.edu, www.cis.ksu.edu/~viveks/home.html, 19K Nichols Hall.
Office hours are Mondays 2:30pm-4:30pm, and by appointment.

Text

Abraham Silberschatz and Henry F. Korth and S. Sudarshan, Database System Concepts. McGraw-Hill. ISBN 0-07-228363-7. This text is available in the KSU Union Bookstore. The book has a web page at http://www.cs.yale.edu/homes/avi/db-book/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 and data warehousing environments.

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. If you do not meet this requirement, you should see the instructor immediately.

Tentative Course Outline

Database System Concepts and Architecture
Chapter 1 (< 1 week)
The Entity-Relationship Model
Chapter 2 (< 1 week)
The Relational Data Model and Relational Algebra
Chapter 3 (2 weeks)
SQL
Chapter 4 (1 week)
Deductive Databases and Active Databases
Chapters 5&6 (1 week)
Database Design Theory and Methodology
Chapter 7 (1-2 weeks)
Indexing and Hashing
Chapters 11&12 (1 week)
Query Processing and Optimization
Chapters 13&14 (1-2 weeks)
Transaction Management
Chapters 15&16&17 (1-2 weeks)
Distributed Databases
Chapters 18&19 (1 week)
Data Warehousing and Data Mining
Chapter 22 (1-2 weeks)

Grading and Exams

Homework
There will be assignments due for most weeks, usually minor but there might also be a few more substantial projects.
Exams
In addition to the final, there will be a midterm.
Grades
The final counts 40%, the midterm counts 30%, and the assignments count 30%.

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