Syllabus/Course Requirements

Course Number: CINS 370

Course Name: Database Management Systems (3 units)

Prerequisite: CSCI 311 with a grade of C- or better

Instructor: Dr. Melody Stapleton

Office Hours: TuTh 1:30-3 pm, and Wed 11-noon, 5-6 pm in OCNL 208

Faculty Phone: 530.898.5617

E-mail address: mjstapleton@csuchico.edu

Web page: www.ecst.csuchico.edu/~melody (look for Fall 2010 - CINS 370)

Textbook: Fundamentals of Database Systems, Sixth Edition by Elmasri and Navathe, Addison Wesley, 2011(Required), ISBN-10: 0-13-608620-9 | ISBN-13: 978-0-13-608620-8 – This is an excellent book!!!

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:

1)Course Project – Design and Implementation of a Database with Web Interface

Project Deliverables:

First Deliverable: Proposal – 20 points (CR/NC) + 5 points for your written individual evaluation– due Thursday, September 16, in VISTA (may be submitted with corrections with your team’s Deliverable 2 – Project Design)

Second Deliverable: Project Design – 40 points + 5 points for your written individual evaluation – due Tuesday, October 26, in VISTA (may be resubmitted with corrections once)

Third Deliverable: Project Implementation – 25 points + 5 points for your individual written evaluation – due at Final Exam

1)Total Project Points = 100 for 40% of Course Grade

2) Midterm Exam for 20% of Course Grade

3) Final Exam for 30% of Course Grade

4) HW and Quizzes – 10% of Course Grade – Project Leaders get automatic 10%

Group Project: Design and Implement a Database

See more links on 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 and Implementation Phase are briefly discussed below. See details of the Proposal Phase, Design Phase and Implementation Phase on the relevant web pages as links off the 370 Course Home Page.

Proposal Phase: This is an initial design document to “get the ball rolling” on the project.  Here you will give a brief written description of the overall project, a first cut at a graphical entity-relationship model, and a first cut at the key business processes in the form of use cases.

Design Phase: Complete a logical design of a database. 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 event traces, a Data Dictionary, and the User-Views as Prototyped Web Pages. There are a number of student example projects posted within the course web pages.  You will turn in your Design Phase before taking your midterm exam. You will receive feedback and a score for your initial submission for the Design Phase. You can correct any problems with your Design Phase (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.

Implementation Phase: Implement the database designed in the Design Phase, above, 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 the web pages (screen shots) which demonstrate the various user views and the output of each variety of report or query. The details of the deliverables from the Implementation Phase are described on a link off of the 370 Course Home Page and there are examples of Implementation Phase deliverables from other student projects on other links off the 370 Course Home Page.  Dr. Stapleton may also have you demo your database functionality.

First Assignment: Read Chapters 1-3 of your text.  Email Dr. Stapleton and let her know of your background with web page development and database programming and let her know if you would like to be a project team leader.