Database Design

CSCI 320, Section 01
Spring Semester 2007

Instructor

Course Description

Required for B. S. degree in computer science.
An introduction to the logical and physical structures of computer database systems. Topics include data models, query languages, relational database design, database constraints, and file structure. Students will be required to complete a project involving database design and implementation.

Prerequisites: CSCI 202 or CSCI 216

Learning Outcomes

Upon successful completion of this course, a student will

• Understand the conceptual, logical, and physical models of relational databases
• Understand the concepts of keys, foreign keys, and referential integrity
• Be able to write SQL statements to create, query, and update a relational database
• Understand normalization and its role in database design
• Have experience in the design and implementation of relational databases
• Understand the concept of a transaction

Textbook

David Kroenke, Database Processing: Fundamentals, Design, and Implementation, (Tenth Edition), Prentice Hall, 2005.

Also:  Course Notes and Handouts

Class Schedule

MWF, 8:00-8:50 a.m., Thompson Hall 216.

Grading

The final grade for the course is based on 6 grades as follows:

• Three assigned in-class tests. Each test counts as a separate grade.
• Daily quizzes and other assignments– collectively count as 1 grade. (Lowest two quiz grades will be dropped.)
• Database project – counts as 1 grade.
• Final Exam – counts as 2 grades.
• Lowest grade from above 7 grades will be dropped. If the lowest grade is the final exam, only one of the two associated grades will be dropped.

Miscellaneous Grading Policies

1. Students are required to work individually on all work done outside of class. Joint work is forbidden. Assistance from anyone other than the instructor, a librarian, or the writing center staff is also forbidden.
    
2. The database project is due before you leave on spring break. Late projects, for whatever reason, will have their grade lowered by one letter, and no project will not be accepted after April 11.
    
3. Daily quizzes will come directly from the material covered in the previous day's class.
    
4. Homework will be assigned but not collected; however, daily quizzes will often be based on homework assignments.
    
5. Class attendance and participation can influence borderline grades.
    
6. A total of six absences will result in a course grade of F. With respect to this policy, three lates count as an absence. In addition, if you are late by 15 minutes or more, you will be considered absent.
    
7. Incomplete grades are given only in unusual circumstances. Consult the catalog for policy on incomplete work.

Office Hours

Other times by appointment

Important Dates

Expectations

1. Do not miss the assigned tests without a valid excuse! Missing an assigned test without a valid excuse will result in a grade of zero for that test. The instructor gets to determine whether or not an excuse is valid. In particular, guard duty is not an acceptable excuse for missing an assigned test. When possible, students should notify the instructor in advance if they will be unable to take an assigned test. All make-up tests will be given outside of normal class time. Once a test has been given in class, any subsequent make-up tests may differ significantly.
    
2. Show up for class on time and prepared. That means that you have read the appropriate sections from the book plus any handouts, and you have worked all assigned homework. If a test has been assigned, you should be prepared to take the test. If you were late to class or absent from the previous class meeting, you are responsible for getting class notes and assignments from another student in the class or from the instructor.
    
3. If you are late to class, it is possible that you have already been marked absent by the time you arrive. It is your responsibility to notify the instructor after class that you were late rather than absent.
    
4. Take care of any personal needs outside of class time. Except for emergencies, you should not need to go to the bathroom, get a drink of water, etc. If you need to leave the room at any time while class is in session, you should ask for permission.
    
5. There should be no personal conversations or moving around during class without explicit permission. These actions are disturbing to other students and to the instructor. Be courteous and respect the rights of others.
    
6. You should respect the property of your college. No eating, drinking (other than water), smoking, dipping, chewing tobacco, etc. in the classrooms. Also, no writing or carving on the desks, chairs, podium, etc. Any willful vandalism or destruction of Citadel property will be dealt with severely.

Daily Schedule