January 2009

CS440
Database

Class Description

This is a senior Computer Science course database course. Relational database theory (including normal forms), SQL, the entity-relationship model are studied. Several different database systems will be used.

This course is required in both the Computer Science and the Somputer Information System majors. It does NOT satisfy any University Studies requirement.

This has a lab component. Students will spend considerable time outside class working on various projects and assignments. If you need any test-taking, notetaking or other accommodation, please see the instructor during the first week.

Identification:
CS440, 3 credit hours

Prerequisites: CS300 with grade of C or better. Proficiency in C++ is assumed.

Information About The Instructor

Dr. David R. Naugler
Department of Computer Science
Office DH021H local 2787
Email address dnaugler@semo.edu
URL: http://dnaugler.cs.semo.edu

Class Schedule

Monday, Wednesday, Friday

09:00 - 09:50 CS331-01 Applications Programming (DH024)
11:00 - 11:50 CS300-01 Discrete Structures II (DH024)
14:30 - 16:20 CS440-01 Database Lab (DH026) - Monday Only.

Tuesday, Thursday

14:00 - 15:15 CS440-01 Database (DH024)

Office Hours

F: 12:00 - 12:50 and TR 11:00 - 11:50 and by appointment. To be arranged
Note: Office hours may change without notice.

Please do NOT try to see me during the 10 minutes before each of my classes.

Class Materials and Supplies

Rental Text Modern Database Management, 8th Edition Jeffery A. Hoffer, Mary B. Prescott, Fred R. McFadden, Prentice Hall, 2007

Class Policies and Procedures

This class abides by university policies in general, and in particular regarding attendance and academic honesty. According to these "Students are expected to attend all classes and to complete all assignments ... " and "students are responsible for upholding the principles of academic honesty in accordance with the 'University Statement of Student Rights' found in the STUDENT HANDBOOK."

You are expected to pass in assignments on time at the beginning of the class period. Programming assignments need not be accepted late. Assignments accepted late will lose up to 30% of the possible points for each day they are late and normally be accepted only until the beginning of the next class after they are due unless otherwise is clearly indicated by the instructor. Work submitted as your own MUST be your own work. A grade of -1 may be given for work not passed in. Group group work must clearly contain the names and contributions of each member of the group.

Do not enter a classroom before the previous class is over (usually indicated by the professor leaving) and leave the room promptly after a class to allow for the next class. Leave promptly if a professor is waiting - some instructors like to enter the classroom in the period between classes to setup for their class and to talk to students.

Labs are to be used responsibly. Unless otherwise indicated by your instructor, your work is not to be left on lab computers. The teaching lab is NOT for personal use - no use of the internet and no checking of email is permitted in the teaching lab without the instructor's permission. When using the teaching lab, students are NOT to enter the lab until the previous class is over (usually indicated by the professor leaving the lab) and are to finish up promptly at the end of the lab period and leave the lab.

University rules require that final examinations be given during finals' week (unless there are extenuating circumstances); the final examinination will be COMPREHENSIVE.

Late drops are strongly discouraged in the College of Science and Technology by order of the Dean. Incompletes can be given after the drop date ONLY to passing students who are in exceptional circumstances - see the rules in the University Bulletin.

Students are expected regularly check their Southeast email account. Your email address is considered public. The names and email addresses of each student in the class may be posted on our class web page - you must inform me in writing (email does not count) during the first two weeks of classes if you do not want your name listed and you must give (non-frivolous) reasons.

Changes or official re-interpretations of University, college, or departmental rules or regulations may supercede or cause the immediate revision of any provision in this or other handouts with no advance notice.


Notes:

  1. The Computer Science Department will gather materials from classes this semester as part of our preparation for an accreditation attempt. Copies of some of your work may be used without notification. Sometimes work might be returned to a class later than usual to allow for appropriate copying. See the Department Chair if you have further questions

  2. Eight week grades must be submitted this semester. These grades are not (supposed to be) part of your permanent record and are not appealable. I will use the information I have at the appropriate time to determine the grade submitted. Such factors as attendance and submission of completed work will be used in addition to assignment, quiz and test grades. In upper level classes eight week grades are not usually very useful and are often not a good predictor of course outcomes, but a poor grade indicates that something needs attention.

  3. Electronic devices such as cell phones, pagers, PDA's etc are not to be used unless the instructor specifically permits. In particular devices that are, or may be, disruptive to a lecture may not be used - turn your cell phone or pager off during class. Access to such electronic devices during tests or exams is not allowed and calculator usage is not permitted without the instructor's permission.

    Laptop computers are not to be used during class without the specific permission of the instructor.

  4. Students may not leave the room during a test or exam unless they are finished and pass in their paper - please use the washroom before the test or exam. The instructor may permit exceptions for medical reasons but must be informed of problems before the test or exam begins.


Grading (tentative)

Assignments and project(s) 30%
Midterm(s), tests 20%
Participation 15%
Final Examination 35%

Participation

The participation grade uses a number of factors including serious attempts at quizzes, tests, and exams, timely submission of assignments, attendance, and so on. Participation basically is as measure of the students serious attempt to do the course work by doing their part as a student, in the estimation of the instructor. A student who is honestly trying but doing poorly in the tests or assignments may nonetheless get a good participation grade and a student doing well in tests and assignments may get a poor participation grade.

A final score of 90% or greater is an A; of 80% or better but less than 90% is a B; of 70% or better but less than 80% is a C; of 60% or better but less than 70% is a D; of less than 60% is an F. There will be exercises and various assignments. Assignments must be in the format and form indicated by the instructor. There will be many exercises. Some exercises may be collected and graded (with advanced notice). Assignments must be passed in at the beginning of class on the date due. Late assignments may not be accepted. Late assignments must be passed in by the beginning of the next class and may not be accepted after that. The instructor reserves the right to make exceptions to the above rules where appropriate. Assignments are not accepted by email although in unusual circumstances an emailed version might be allowed to determine the "lateness" of an assignment if a paper/diskette identical version is submitted as soon as is feasible.

Class Calendar

The following schedule is entirely tentative. The topics will be somewhat interleaved. Tests will be given about week six and week twelve. Quizzes and short tests will be given as needed. Quizzes may be unannounced.

Week 1.
Introduction.
Week 2.
Fundamentals of SQL
Week 3.
SQL statements
Week 4, 5, 6.
Relational Database model and normal forms
Week 7.
More SQL
Week 8, 9.
Entity Relationship Model
Week 10, 11, 12.
Database Design
Week 13, 14, 15.
Topics
Note: All provisions in this handout are tentative and subject to change. Where reasonable, changes will be discussed and/or notification given to the class. The teacher reserves the right to modify the grading scheme without notice if such changes will not lower any student's grade. The teacher reserves the right to cover fewer, more or different topics than those indicated above with or without prior notification.
Version 0.99 Created 01/8/2009. Last modified Thursday January 22 2009
This syllabus is subject to change