Database Systems

CS-377: Spring 2004

Home
Syllabus
Schedule
Projects
Contact Information

Course Details at a Glance

Lectures: Mon., Tues., Wed., Fri., 12:30 - 1:20 p.m., Olin 220
Instructor: Thomas C. Bressoud, Olin 207, 587-5630, bressoud@denison.edu
Handouts: Hardcopies: In-class or at my office
Exam Code E, Thursday, May 6th, 2:00 - 4:00 p.m.

Description

A study of the design, implementation and application of database management systems. Topics include the relational data model, physical implementation issues, database design and normalization, query processing and concurrency.

Textbooks

The following textbook is required for the course:

bulletAbraham Silberschatz, Henry F. Korth, and S. Sudarshan.  Database System Concepts, 4th Edition, McGraw Hill Publishers, Inc, 1998.  ISBN 1-55860-428-6.

Course Web Page

A web page will be maintained for this course.  The web page will include reading, homework, and project assignments, scheduling of events (including midterms) and other useful information.  Please check it regularly:

http://www.denison.edu/~bressoud/cs377-s04

Prerequisite

CS-281 (Computer Organization) is a prerequisite for this course.

Final Grade Determination

Homework: 25%
Midterm Exams: 20% (10% each)
Project 30%
Final Exam: 20%
Class Participation: 5%

Course Work

Homework:
There will be regular homework assignments, probably every week or two.  The purpose of the homework is generally intended to reinforce the conceptual material from the book and will cover a wide variety of topics.  Many questions will be of the variety that could also appear on exams.  Homeworks are due in class on the date specified.  I will accept late homeworks, but with a 50% penalty enforced from the moment the homework is overdue.

You may discuss how to solve homework problems with other students in the class, but written work must be your own.  You may not get help on homework from students outside the class. Of course, you are always welcome to come see me for help.

Homework solutions must be typed in a word processor of your choice.  I would recommend that you learn and use LaTeX, a markup based typesetting program that is widely used in the research community.  Let me know if you need help getting started.

Exams:

There will be two midterm exams.  Each midterm will cover its respective section of the course material. Note that this means the second midterm exam is not cumulative, and is weighted equally with the first exam.  All exams will be closed book, closed notes.  Tentative dates for the midterms are given in the class schedule, but these may change (later or earlier), depending on our rate of progress.  The final exam is cumulative and will also be closed-book, closed-note.

Project:

A significant portion of your grade will consist of your performance on a semester-long database project.  Within the project, you will choose a database application area; define and refine the entities that comprise the area; design the user interaction; design and normalize a relational database; create the database and populate it with a significant amount of data; and demonstrate your finished product.

An integral part of the database project will be the maintenance of the project notebook, which will have a prescribed format and contents.  The project will be turned in the last day of class, and the last two class sessions will consist of demonstrations.  These will be individual projects.

Class Participation:

For this class to be successful, students must be engaged in the material by first doing the readings ahead of time, and second by participating in class. You will be expected to actively participate by asking questions, joining in our discussions, etc. Note that there is a significant portion of your grade attributed to class participation.

Student Responsibilities

Attendance:
Your attendance is expected at each class meeting. Per the class participation portion of the grade, I will reduce your grade for absences.  Up to 3 excused absences will be tolerated without affecting your grade.
Readings:
You are responsible for the content of reading assignments, lectures and handouts, as well as announcements and schedule changes made in class, whether or not you are present. If you must miss a class, you are responsible to get what you missed. Exams will be given in class on the day scheduled and may not be made up.
Out-of-class Time:
Material in any class is not learned or mastered simply by attending class.  The student needs to spend the time outside of class doing the readings, discussing the issues with fellow students, and discussing topics with the professor.  In many respects, out of class time is, in fact, more important than lecture time.  A good rule of thumb is that you should be spending 12-14 hours of quality time outside of class per week on a 4 credit hour course.

Other Issues

Disability Accommodation:
Any student who thinks he or she may need an accommodation based on the impact of a disability should contact me privately as soon as possible to discuss your specific needs. I rely on the Office of Academic Support in Doane 104 to verify the need for accommodation based on documentation on file in their office.
Academic Integrity:
Do your own individual homeworks and projects. Do NOT copy from another person. There should be no reason for two nearly identical assignments. Usually a warning will be given first and then an incident of academic fraud will be reported for subsequent incidents.

Course Outline -- for tentative outline, see the Schedule page.

Home | Syllabus | Schedule | Projects | Contact Information

 All rights reserved, Thomas C. Bressoud and Denison University.
For problems or questions regarding this web contact bressoud@denison.edu.
Last updated: 01/30/04.