Database Design

CSCI 320, Section 01
Spring Semester 2017

 

Instructor

John I. Moore, Jr. Phone:  843-953-7883
Office:  Thompson Hall 209       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

Carlos Coronel and Steven Morris, Database Systems: Design, Implementation, and Management (12th Edition), Cengage Learning, 2016. (ISBN: 978-1305627482)

Also:  Course Notes and Handouts

 

Class Schedule

MWF, 11:00-11: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 students, and both 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 not permitted. 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 not permitted.
     
  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 10:00-11:00 a.m., 1:00-2:30 p.m.
Wednesday  10:00-11:00 a.m., 1:00-2:30 p.m.
Friday  8:30-9:00 a.m., 10:00-11:00 a.m.

Other times by appointment

 

Important Dates

Jan. 16 Martin Luther King, Jr. Holiday (no classes)
Feb. 8 Test #1 (Chapters 1-4)
Mar. 8 Test #2 (Chapters 5-7)
Mar. 15 Last day to withdraw with a grade of “W”
Mar. 17 Leadership Day (no classes)
Mar. 27-31 Spring Break (Work on course project during break!)
Apr. 14 Test #3 (Chapters 8, 9, 16)
Apr. 19-21 Project Presentations
Apr. 27 (Thursday) Final Exam 1:00-4:00 p.m.

 

Expectations

  1. Do not miss an assigned test 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. Personal conversations are disturbing to other students and to the instructor. Please 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 handled appropriately.
     

 

Daily Schedule

Dates Topics Covered
Jan. 11 Chapter 1: Database Systems
Jan. 13 Chapter 1: Database Systems
 
Jan. 16 Martin Luther King, Jr. Holiday (no classes)
Jan. 18 Chapter 2: Data Models
Jan. 20 Chapter 2: Data Models
 
Jan. 23 Chapter 3: The Relational Database Model
Jan. 25 Chapter 3: The Relational Database Model
Jan. 27 Chapter 3: The Relational Database Model
 
Jan. 30 Chapter 4: Entity Relationship (ER) Modeling
Feb. 1 Chapter 4: Entity Relationship (ER) Modeling
Feb. 3 Chapter 4: Entity Relationship (ER) Modeling
 
Feb. 6 Review (Chapters 1-4)
Feb. 8 Test #1 (Chapters 1-4)
Feb. 10 Installing/Using MySQL
 
Feb. 13 Chapter 5: Advanced Data Modeling (selected sections)
Feb. 15 Chapter 5: Advanced Data Modeling (selected sections)
Feb. 17 Chapter 6: Normalization of Database Tables
 
Feb. 20 Chapter 6: Normalization of Database Tables
Feb. 22 Chapter 6: Normalization of Database Tables
Feb. 24 Chapter 7: Introduction to SQL
 
Feb. 27 Chapter 7: Introduction to SQL
Mar. 1 Chapter 7: Introduction to SQL
Mar. 3 Chapter 7: Introduction to SQL
 
Mar. 6 Review (Chapters 5-7)
Mar. 8 Test #2 (Chapters 5-7)
Mar. 10 Chapter 8: Advanced SQL
 
Mar. 13 Chapter 8: Advanced SQL
Mar. 15 Chapter 8: Advanced SQL
Mar. 17 Leadership Day (no classes)
 
Mar. 20 Chapter 8: Advanced SQL
Mar. 22 Chapter 9: Database Design
Mar. 24 Chapter 9: Database Design
 
Mar. 27-31 Spring Break (Work on course project during break!)
 
Apr. 3 Chapter 9: Database Design
Apr. 5 Chapter 16: Database Administration and Security
Apr. 7 Chapter 16: Database Administration and Security
 
Apr. 10 Chapter 16: Database Administration and Security
Apr. 12 Review (Chapters 8, 9, 16)
Apr. 14 Test #3 (Chapters 8, 9, 16)
 
Apr. 17 Section 14-3: NoSQL
Apr. 19 Project Presentations/Demonstrations
Apr. 21 Project Presentations/Demonstrations
 
Apr. 24 Review
 
Apr. 27 (Thursday) Final Exam 1:00-4:00 p.m.