CSci 6441.BA2: Database Management Systems

Department of Computer Science
The George Washington University, Spring 2011
CRN 15165

Term Project

Overview: In order to gain further experience with the material we will cover in class, you are to complete a term project. The main component of the project is to work in a team to develop a moderately complicated database application.

  1. Form a team of 3 (or 4) class members and notify the instructor
  2. Select a business problem to solve from a domain with which you are familiar.
  3. Write a high-level proposal describing your business problem and, in very general terms, your proposed solution using database technology
  4. Receive approval for your proposal from the instructor
  5. Select a DBMS implementation to use: You may use PostgreSQL, MySQL, SQLite, SQL Server, or Oracle without prior approval. If you wish to use a different DBMS, you must discuss the reasons with the instructor and receive approval.
  6. Determine your data needs and produce an initial schema
  7. Critique (as a team) the schemas (from other teams) assigned to you
  8. Revise your schema based on the critiques
  9. Generate your database schema, create the database, and populate it with sample data
  10. Write and execute queries against your database to solve the business problem you presented in your proposal
  11. Demonstrate your solution to the class

Deliverables: Due dates are indicated on the class schedule. Late work will not be accepted without prior arrangements. Each project deliverable shall include a statement describing each team member's contribution to the deliverable. Except where otherwise indicated, work should be submitted using the team repository which the instructor will create for you.

Grading Weights for Project Deliverables:

DB Schema35%
Schema Critique10%
Modified: Tue Jan 11 14:06:46 EDT 2011