CPSC-110 Computers, Information and Society
Project Description
Professor Heidi Ellis

Overview:

The overall focus of the project is to design and implement a small database in the domain of your choosing. The database will contain sufficient complexity and a sufficient volume of data for you to understand how databases are used within your domain. The major steps of the project are:
  1. Select a domain and identify data sources for your database.
  2. Create the database schema for your tables, populate the tables with data downloaded from the web and run queries on the database.
  3. Create and run a series of stored procedures on the database. These stored procedures will be actions that are typically taken to retrieve or update data in the database.
The project is to be completed in teams of three or four students per team. Each team member is to clearly identify the portions of the project for which they were responsible and a team assessment mechanism will be used to determine contribution for grading purposes.

Data Sources

Deliverables:

Assignment Description Due Date Mutual Evaluation
Part 1: Provide a description of the domain in which your project will be centered as well as a description of the data to be used. 5:00 p.m. Friday February 27, 2009
Word document and Mutual Evaluation via email. 		Mutual Evaluation for Part 1
Part 2: Implement your database, import data, and execute queries against it. 5:00 p.m. Tuesday March 31, 2009
Word document of Queries and Evaluation via email.		 Mutual Evaluation for Part 2
Part 3: Design and implement stored procedures for your database, implement security for your database. 5:00 p.m. Wednesday, April 22, 2009
Word document of stored procedure descriptions and PPT or Acrobat version of slides via email. 		Mutual Evaluation for Part 3


Copyright © Heidi J. C. Ellis