Course Number: CSCI 273

Course Name: Database Management (3 units)

Satisfies Graduate Area: Data and File Structures

Prerequisite: CSCI 15B (Programming and Algorithms II) or faculty permission

Instructor: Dr. Melody Stapleton

Office Hours: TuTh 11-noon, W 10-11 am and 3-5 pm in OCNL 208

Faculty Phone: 530.898.5617

Message Phone: 530.898.6442

FAX: 530.898.5995

E-mail address: mjstapleton@csuchico.edu

Web page: www.ecst.csuchico.edu/~melody/ (look for Fall 2004 - CSCI 273)

Textbook: Fundamentals of Database Systems, Fourth Edition by Elmasri and Navathe, Addison Wesley, 2004 (Required) ISBN 0-321-12226-7

Course Description: The course will cover the basic concepts in database management. These include the levels of architecture of a DBMS; database design (including object-oriented analysis and design techniques); relational and object-oriented databases; query languages; transaction processing; recovery and concurrency and modern database architectures. Students will work in teams to complete a database course project.

Evaluation Procedures: Course Project – Design and Implementation of a Database

Project Phases:

Proposal Phase – 15 points (CR/NC) + 5 points for your written individual evaluation– due Tuesday, September 28, in class

Phase 1 – Design Phase – 40 points + 5 points for your written individual evaluation – due Tuesday, November 9 (may be resubmitted with corrections once)

Phase 2 – Implementation Phase – 25 points + 5 points for your individual written evaluation – due at final exam

Project Description: See Dr. Stapleton’s web pages for the details. You will be grouped into teams to complete a group project.  Each team will complete each of the Project Phases: proposal, design, and implementation as a group effort. The Design (Phase 1) and Implementation Phase (Phase 2) are briefly discussed below. See details of the Proposal, Phase 1 and Phase 2 on the relevant web pages.

Phase 1 – Design: Complete a logical design of a database for a hypothetical (or real) application. The product of this phase will be a formal report which summarizes your design and includes Use Cases, an Object Model and Entity-Relationship Model, a Dynamic Model including scenarios and state transition diagrams, a Data Dictionary, and the User-Views as Forms and Reports. There are a number of student example projects posted within the course web pages. The detailed assignment specs are also on Dr. Stapleton’s web page. You will turn in your Phase 1 before taking your midterm exam. You will receive feedback and a score for your initial submission for Phase 1. You can correct any problems with your Phase 1 (only once) and then turn in both the corrected and uncorrected (initially graded) versions by the end of the course to receive a potential increase in your score on this phase.

Phase 2 – Implementation: Implement the database designed in Phase 1 using an existing DBMS that you have access to. You may use Access, Oracle, DB2 or any other relational database package that you have access to. The product of this phase will be screen dumps, etc., which demonstrate the various user views and the output of each variety of report or query. The details of the deliverables from Phase 2 are described on certain web pages and there are examples of Phase 2 deliverables from other student projects on relevant web pages.  Dr. Stapleton may also have you demo your database functionality.

First Assignment: Read Chapters 1 and 2 of your text.