CSC 310 - Database Management

Course Details

Textbook

Relational Database Design and Implementation, Third Edition by Jan L. Harrington, 2009 ISBN: 978-012374730-3 Find this book at Amazon

Overview

Real examples of database applications give students an opportunity to experience the entire database life cycle. Topics include the context, analysis, logical and physical design, and the implementation of a database management system. A database project will be required.

Prerequisites

CSC 234 or permission of instructor.

Quizzes and Participation

You are encouraged to attend class and participate in discussions. Active participation in class discussions and short quizzes will comprise 5% of your final grade.

Disabilities

Centenary assures students with disabilities equal opportunity to reach the same level of achievement as other students. Strict confidentiality will be maintained on students with disabilities. Services for students with disabilities are available through the Counseling Center, located on the ground floor of Rotary Residence Hall, phone (318) 869-5424.

Honor Code

All students are bound by the Honor System. The Honor System is applicable to all academic work. See the Centenary College Handbook for the complete Honor Code.

Extensions

Extensions for labs, projects, exams and quizzes are only given when circumstances beyond your control (e.g. being sick, choir or sports travel) prevent you from completing a project on time. You must notify me either by email or phone of your circumstances well in advance of the due date.

Syllabus

We will also be using additional supplemental material such as relevant web-pages and background material. Additional readings will be assigned before material will be covered in class. You are expected to review the material and come to class prepared. As readings are assigned, they will be posted here.

• August 22th: Chapter 1
• August 27th: Chapter 2
• Sep 5th: Chapter 4
• Sep 10th: Chapter 5
• Sep 2nd: CodeAcademy HTML CSS and Javascript

Homework

You will have semi-weekly Homeworks in this course, for a total of 20% of your final grade. These homeworks will cover concepts we have discussed in class, and will be due approximately one week after they are assigned.

• Lab 1

Project

The purpose of this project is to implement a large database application, using an SQL database in combination with an Android application and a web front-end, as a service project for a nonprofit organization of the Shreveport community.

This project is worth 55% of your final grade, and throughout the semester you will be developing this website and portfolio of progress. Deadlines and Tasks will be posted as necessary. You will be working in a team of three.

Task	Due
Choose Teams and Task	Aug 27th
Client Report: Requirements	Sep 10th
App/Web Mockup	Sep 24th
Database Schema	Oct 1st
Client Report: Revision	Oct 8th
Implementation Demonstration	Oct 29th
Client Report: Final Feedback	Nov 12th
Class Presentation	Week of Dec 14th

Exams

There will be two exams, each worth 10% of your final grade.

• Exam 1: September 28th
• Exam 2: November 9th

Grading

Your final grade for this course will be based on the Homework, Project, Exams and Participation described above.

Grading Scale 90-100 A 80-89 B 70-79 C 60-69 D 0-59 F

Weights Homework 20% Project 55% Participation 5% Exams 20%

---

© Mark Goadrich, Centenary College of Louisiana