CSCI460: Database Design

I. Course prefix and number CSCI 460
II. Number of semesters hours 3
III. Pre-requisites CSCI 250 (Data Structures)
IV. Location of classroom and time course meets Wubben 147 TH 11:00AM 12:15PM
V. Instructor name
Office location
Phone
Email address
Web page
Dr. Warren MacEvoy
Wubben 151
248-1070
[email protected]
http://www.mesastate.edu/~wmacevoy
VI. Office hours See my home page
VII. Course Description

Database design and implementation. Topics will include design, normalization, SQL and security.

VIII. Textbook and materials Database Systems by Connolly and Begg.
IX. Course Objectives See course description.

X. Methods

Lecture, exams, individual and group projects.

XI. Policy on absences and tardies

Make up exams will only be given with advanced notification or very unusual circumstances. You are responsible for material given in class, including changes of schedule for exams.

XII. Policy on late work

Late projects cost two letter grades per day.

XIII. Policy on academic dishonesty

Cheating will result in the instructor's withdrawl of the student with a "fail" grade.

XIV. Disability Arrangements

If you wish to have accomodations made for some disability, you must inform Eduational Access Services at 248-1826 and the instructor in advance.

XV. Evaluation and grading

Your grade will be reflected in three parts, each of equal weight. One part will be on the operating system concepts from the textbook. One part will come from smaller projects during the course, and a final part will be from a self-directed in-depth final project.

Projects will be graded on an A, B, or F basis:

  • A: Well written and documented, with more bells and whistles than required for the project. Testing procedures must be included with the project.
  • B: Works correctly. Reasonably written. Reasonably documented. Reasonably tested.
  • F: Fails to work. Poorly written, documented, or tested.

You must propose your final project content. At most two people can work on a given project, and the grade will reflect individual contributions to the project. The final project will include a written and oral presentation.

XVI. Major Assignments

See below.

XVII. Course Outline We will generally follow the textbook on topic areas, although will spend time on OpenOffice Base and MySQL.

Notes


MySQL 5.1 Reference Manual
Open Office Base
Microsoft SQL Server
Microsoft Access
HW 7.2 (a-g) due 20-Mar-2008
HW 13.16 due 3-Apr-2008