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 10 - 11:30 am, W 1-2 pm and 3-4 pm

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 2003 - 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 – 5 points (CR/NC) – due Thursday, September 18

Phase 1 – Design Phase – 45 pointis – due Thursday, October 23

Phase 2 – Implementation Phase – 25 points – due at final exam

Project Description: See Course Notes and Dr. Stapleton’s web page 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 web page or in Appendix H of the Course Manual.

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, the User-Views as Forms and Reports, and the Functional Model of your application as a set of Minispecs (if relevant). There is a separate appendix, Appendix H, of your course manual that contains details of what is expected as well as a number of student e.g. projects in other Appendices. 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 provided in Appendix H and there are e.g.s of Phase 2 deliverables from other student projects in various Appendices in your course manual.  Dr. Stapleton will also have you demo your database functionality.

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