Database Design

CSCI 320, Section 01
Fall Semester 2010

 

Instructor

John I. Moore, Jr. Phone:  843-953-7882
Office:  Thompson Hall 230       E-mail:  john.moore@citadel.edu

 

Course Description

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

 

Textbook

Jeffrey A. Hoffer, Mary B. Prescott, and Heikki Topi, Modern Database Management, (Ninth Edition), Prentice Hall, 2009 (ISBN-10: 0136003915, ISBN-13: 97801360003915).

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:

 

Miscellaneous Grading Policies

  1. A database project will be completed by teams of two or three, and all team members will receive the same grade for the project. The complete database project is due on or before the start of class November 19 (before you leave for Spring break). Late projects, for whatever reason, will have their grade lowered by one letter, and no project will be accepted after December 1.
     
  2. With the exception of the database project, students are required to work individually on all work done outside of class that will be turned in for a grade. Unless explicitly authorized, joint work is forbidden. Assistance from anyone other than the instructor, a librarian, a member of the academic support center, or a team member (on the database project only) is also forbidden.
     
  3. Homework will be assigned, but it will not be collected or graded. Unless otherwise noted, daily quizzes will come directly from the material covered in the previous day’s class, often from the homework assignments.
     
  4. Class attendance and participation can influence borderline grades.
     
  5. A total of nine 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.
     
  6. Incomplete grades are given only in unusual circumstances. Consult the college catalog for policy on incomplete work.

 

Office Hours

Monday 1:00-2:30 p.m.
Tuesday 1:00-2:30 p.m.
Wednesday  10:00-12:00 a.m.
Thursday 1:00-2:30 p.m.

Other times by appointment

 

Important Dates

Sep. 6 Labor Day (class will be held)
Sep. 10 Project Phase 0 Due: Select an Organization
Sep. 15 Test #1 (Chapters 1-3)
Sep. 29 Project Phase 1 Due: Design an E-R Model
Oct. 4 Test #2 (Chapters 4-5)
Oct. 22 Project Phase 2 Due: Convert E-R Model to a Relational Data Model
Oct. 25 Last day to withdraw with a grade of “W”
Oct. 25 Test #3 (Chapters 7-8)
Nov. 15 Test #4 (Chapters 6, 13)
Nov. 19 Complete Project Due (on or before the start of class)
Nov. 22-26 Fall Break (Take book home to study during break!)
Dec. 3 Project Presentations
Dec. 13 (Monday) Final Exam 1:00-4:00 p.m.

 

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. Cell phones must be kept in book bags and programmed in a silent or vibrate setting during class.
     
  7. 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

Dates Topics Covered
Aug. 25 The Database Environment (Chapter 1)
Aug. 27 The Database Environment (Chapter 1)
   
Aug. 30 The Database Environment(Chapter 1)
Sep. 1 The Database Development Process: Brief Overview (Chapter 2, selected topics)
Sep. 3 Modeling Data in the Organization (Chapter 3)
   
Sep. 6 Modeling Data in the Organization (Chapter 3)
Sep. 8 Modeling Data in the Organization (Chapter 3)
Sep. 10 Modeling Data in the Organization (Chapter 3)
   
Sep. 13 The Enhanced E-R Model (Chapter 4)
Sep. 15 Test #1 (Chapters 1-3)
Sep. 17 The Enhanced E-R Model (Chapter 4)
   
Sep. 20 The Enhanced E-R Model (Chapter 4)
Sep. 22 Logical Database Design and the Relational Model (Chapter 5)
Sep. 24 Logical Database Design and the Relational Model (Chapter 5)
   
Sep. 27 Logical Database Design and the Relational Model (Chapter 5)
Sep. 29 Logical Database Design and the Relational Model (Chapter 5)
Oct. 1 Introduction to SQL (Chapter 7)
   
Oct. 4 Test #2 (Chapters 4-5)
Oct. 6 Introduction to SQL (Chapter 7)
Oct. 8 Introduction to SQL (Chapter 7)
   
Oct. 11 Introduction to SQL (Chapter 7)
Oct. 13 Introduction to SQL (Chapter 7)
Oct. 15 Advanced SQL (Chapter 8)
   
Oct. 18 Advanced SQL (Chapter 8)
Oct. 20 Advanced SQL (Chapter 8)
Oct. 22 Review (Chapters 7-8)
   
Oct. 25 Test #3 (Chapters 7-8)
Oct. 27 Physical Database Design and Performance (Chapter 6)
Oct. 29 Physical Database Design and Performance (Chapter 6)
   
Nov. 1 Physical Database Design and Performance (Chapter 6)
Nov. 3 Data and Database Administration (Chapter 13)
Nov. 5 Data and Database Administration (Chapter 13)
   
Nov. 8 Data and Database Administration (Chapter 13)
Nov. 10 Data and Database Administration (Chapter 13)
Nov. 12 Review (Chapters 6, 13)
   
Nov. 15 Test #4 (Chapters 6, 13)
Nov. 17 Selected Topics in Database Systems
Nov. 19 Selected Topics in Database Systems, Projects Due!
   
Nov. 22-26 Fall Break (Take book home to study during break!)
   
Nov. 29 Selected Topics in Database Systems
Dec. 1 Selected Topics in Database Systems
Dec. 3 Project Presentations
   
Dec. 6 Review/Course Evaluations
   
Dec. 13 Final Exam 1:00-4:00 p.m. (Monday)