Course Number: CSCI 273M

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: TBA

Faculty Phone: 530.898.5617

Message Phone: 530.898.6442

FAX: 530.898.5995

E-mail address: melody@ecst.csuchico.edu

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

Required Materials: Database Management Systems with Object-Oriented Analysis and Design Videotapes , produced by California State University, Chico

Textbook: Database System Concepts, Third Edition by Silberschatz, Korth, and Sudarshan, McGraw Hill, 1997 (Required) ISBN 007044756X

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 are encouraged to form teams if possible to complete a database course project. Single person projects are perfectly acceptable.

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

Project Phases:

Proposal Phase – 5 points (CR/NC) – due 1 month in from start

Phase 1 – Design Phase – 45 pointis – due 3 months in

Phase 2 – Implementation Phase – 25 points – due course end

Project Description: See Course Notes and Dr. Stapleton’s web page for the details. If others at your company are currently taking this videotaped database course, you may group together with up to 5 individuals to form a project team. 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 you 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 should turn in your Phase 1 after 3 months into the course (half-way). You should 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. Whenever possible, Dr. Stapleton would like to be able to have you demo your database functionality.

First Assignment: Read Chapters 1 and 2 of your text. Send email to melody@ecst.csuchico.edu right away and give your name, computer science courses you have taken to date, your background in the computing area, including the languages and applications you know, your interest in this course, your job interests, and whether or not you have a team to work with. If you do have a team, please include your team members names.