CMSI 486: Database Project Page

Project Basics

You will be responsible for designing, documenting, and implementing a database of your own this semester. The idea is for you to get hands-on experience with the process of actually going through the entire process. To that end you must do the following:

Schedule of Deliverables

The following deliverables will be due on the dates indicated:

  1. Preliminary Database Design document: October 17 [section 1] and October 18 [section 2]
  2. Detailed Database Design document: November 7 [section 1] and November 8 [section 2]
    Includes the Data Dictionary as appropriate
  3. Database Demonstration: November 26 & 28 [section 1] and November 27 & 29 [section 2]

Document Section Descriptions

Preliminary Database Design

You must have the following as part of your preliminary design:

Detailed Database Design

You must have the following as part of your detailed design:

Preliminary Database Demonstration

You will demonstrate your database in class, showing that the queries from section 1.3 of your document all work and will return the data you expect. I may also ask you to execute a query on the spur-of-the-moment.

Some Suggestions for Possible Implementations

The following list contains some ideas for you to consider. They are all fairly involved, and will be challenging for you to work with and get good experience with designing and building your project. If you have another idea that you want to do, that's fine, as long as it is reasonably comprehensive.

  1. Hospital or Doctor's Office
  2. School or University
  3. Library
  4. Car Repair Shop
  5. Stock Market
  6. Sports Teams
  7. Horse Racing
  8. Music CD Catalog
  9. Video Catalog
  10. Product Inventory
  11. Social Network Connections
  12. Movie Database
  13. Asset Location
  14. Human Resources/Personnel