CS 340 DATABASE MANAGEMENT SYSTEMS I
Fall Semester 2001
Professor Allan M. Hart
Office WB 240 Phone 3891615 Email
Web site http://krypton.mankato.msus.edu/~harta1/welcome.html
Office Hours
M 1-2
T,W,H,F 10 – 11
W,F 2 - 3
3 - 4 T,H, by appointment
Course Time/Location
Section 1 Lecture: 9 - 9:50 a.m. T,H,F WH 286
Section 1 Lab: 9 - 9:50 a.m. W WH 119
Section 2 Lecture: 1 - 1:50 p.m. T,H,F WH 288A
Section 2 Lab: 1 - 1:50 p.m. W WH 119
Course Goal
The goal of this course is to introduce the student to current database topics and
terminology associated with the design, development, and implementation of
database systems. Topics include: the concept of database systems, database
models, database management systems, file organization, design of databases
using data modeling and normalization, conversion of data models into network
and hierarchical data models, extensive coverage of SQL and implementation of
an application using a relational database in a team environment.
Course Objectives
Via the use of lectures, readings, demonstrations, assignments and a project,
students will achieve an understanding of the following:
1. Data modeling utilizing
· entity relationship diagrams
· the relational model
· normal forms through 4th normal form
2. Query Processing using
· relational algebra
· relational calculus
· Structure Query Language (SQL)
3. JDBC
4. Servlets, HTML
5. B++ trees
Prerequisites:
In order to register for COMS 340, students must first complete COMS 111. Students will be asked to show proof (by bringing a valid transcript to class) that they have satisfied these prerequisites on the first day of class. Any student who has not satisfied these prerequisites will be administratively dropped from the course.
Note!
Any student who misses the first 2 days of class will be administratively dropped
from the course.
Email:
During the course of the semester, students will not only have the opportunity to contact me by email, but will be encouraged to do so. However, students must use their .mnsu address and not their hotmail (or some other) address as their return address.
Course Structure
Course Sessions
Sessions will consist of lectures, discussions and demonstrations. You are
responsible for all materials discussed and assignments given during the class
sessions whether you are present or not.
Attendance
In a college level course, it should not be necessary to take role. However, since
this course incorporates a group project, it is imperative that every member of a
group is in class every day. I will take role on a regular basis. The purpose of
this is twofold. First: I want to learn your names! Second: I want to have a
record of attendance so that when I assign grades, I’ll have some idea why
students did well and others did not.
Semester Project
During the course of the semester, students will work together on a group project.
The project involves the analysis, design, and implementation of an information
system.
The project will consist of phases. The phases will roughly correspond to lecture
and lab sessions. Each phase will be submitted to the instructor, along with
previous phases, in a three-ring binder. Each phase will be identified in the
binder by dividers.
Groups will earn a single grade for their work on the project.
From time to time, team detailed progress reports will also become due. The team
report will be submitted by the team leader. No points will be awarded for these
reports but a lack of submission will result in a loss of points by the entire team.
Group Membership
Pick your group wisely. Talk to a variety of class members. Determine who has
a schedule similar to your own. Identify students from other classes who have a
work ethic similar to yours. Assess who is prompt and responsible.
Materials for the course
These books should be available in the bookstore
Greg Riccardi (2001)
Principles of Database Sytems with Internet and Java Applications
Addison Wesley
Bowman, Judith S., Emerson, Sandra L., Darnovsky Marcy. (4th edition)
The Practical SQL Handbook Reading, MA: Addison Wesley.
Important Course Dates:
8/31/01…………………………Last day for refund on dropped full-term classes
11/14/01………………………..Last day to drop a class
11/22/00……………………….Thanksgiving recess begins
12/10/01 – 12/14/01…………… Final Exam week
Evaluation
Point Breakdown (450 total points)
Examination I 100 pts
Examination II 100 pts
Final Exam 100 pts
Project 100 pts
Homework 50 pts
Examinations missed without prior clearance from the instructor are forfeited. There are no MAKE-UP EXAMS! No incomplete grades will be given except as stated in University policy.
Grading
The percentages shown below will be calculated in the total points accumulated from the examinations, projects and homework. If you are taking this course for Pass/No credit, you must obtain at least 70% of the total points to earn a passing grade. The instructor reserves the right to lower these percentages.
Total points will be used in assigning a course grade.
90 – 100% A
80 – 89% B
70 – 79% C
60 – 69% D
0 - 59% F
Course Requirements
All assignments and tests must be completed before a passing grade will be considered by the instructor. You may turn in an assignment after it is due but with the following penalty:
· up to 24 hours past due, ten percent off
· up to 48 hours past due, twenty percent off
· over 48 hours past due, not accepted
Course Outline
The (very) tentative course outline shown below may require updating throughout the semester. Any changes will be announced in class.
Week Topic Readings
1: 8/27 – 8/31 Introduction to course Ch 1 Riccardi
9/3 Labor Day
2: 9/4 – 9/7 Data Models Ch 2 Riccardi
Introduction to project
3. 9/10 – 9/14 E-R diagramming Ch 2 Riccardi
Ch. 1 – 3 Bowman
4. 9/17 – 9/21 Advanced Data Models Ch 3 Riccardi
Ch. 1 – 3 Bowman
5. 9/24 – 9/28 The Relational Data Model Ch 4 Riccardi
Ch. 1 – 3 Bowman
6. 10/1 – 10/5 Review and Exam I
7. 10/8 – 10/12 Functional Dependencies Ch. 5 Riccardi
Ch. 1 – 3 Bowman
8. 10/15 – 10/19 Normal Forms Ch 5 Riccardi
Ch. 1 – 3Bowman
9. 10/22 – 10/26 Relational Algebra Ch. 6 Riccardi
Relational Calculus
SQL Ch. 4 Bowman
10. 10/29 – 11/2 Structured Query Language Ch. 7 Riccardi
SQL Ch. 5 Bowman
11. 11/12 – 11/16 JDBC Ch. 8 Riccardi
SQL Ch. 6, 7 Bowman
12. 11/19 – 11/21 HTML, Servlets Ch. 9 Riccardi
SQL Ch. 8 Bowman
13. 11/22 – 11/23 Thanksgiving Break
14. 11/26 – 11/30 Indexes, B++ trees Ch. 12 Riccardi
SQL Ch. 9 Bowman
15. 12/3 – 12/7 Review, Presentations
14. 12/10 – 12/14 Final Exam Week
Plagiarism, cheating or collusion
None of these will be tolerated! Read the section on Academic Honesty on page 48 of the Student Handbook so that you are aware of your rights and responsibilities. Cheating will result in your receiving a grade of F for the course and, possibly, expulsion from the university.
Students with disabilities
Every attempt will be made to accommodate qualified students with disabilities. If you are a student with a documented disability, please see me as early in the semester as possible to discuss the necessary accommodations, and/or contact the Disability Services Office at (507) – 389 – 2825 or 1- (800) – 627 – 3529.