CSC 310 - Database Management

Course Details

Textbook

Database Management Systems, Third Edition by Raghu Ramakrishnan and Johannes Gehrke, 2003 ISBN: 978-0072465631 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.

Extra Credit

Extra credit for this course can be earned by participating in the Centenary Math Problem of the Week (POTW). Each reasonable submission will be worth an additional 0.5% toward your final grade, CC me with your submission for credit. Also, attendence at the Shreveport .NET User Group will count for extra credit.

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 be covering pieces of the textbook, Chapters 1-7, 8, 12, 16, 19-21. 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. Course notes can be found on PicasaWeb

• August 25th: Chapters 1 and 7 (Skip XML discussion)
• September 3rd: Chapter 2

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.

Project

The purpose of this project is to implement a large web-based database application, using an SQL database in combination with a web front-end, as a service project for some aspect of the college community. The goal is to have these projects ready to incorporate into the college internal webpages by the end of the semester.

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 two.

Task	Due
Choose Teams and Task	Aug 28th
Client Report: Requirements	Sep 10th
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 one exam, worth 20% of your final grade.

• Final: November Thursday 19th

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% Final 20%

---

© Mark Goadrich, Centenary College of Louisiana