CPTR 319 Project Ideas

First of all there is more than one kind of project. You can:

  1. Write a program to do just about anything.
  2. Research and present (along with some simple examples) a new or emerging technology for programming databases.

  3. You could do a real-world data analysis project using emerging analysis techniques (BusinessIntelligence, OnlineAnalyticalProcessing, DataWarehousing ...)

Writing a program

If you are a CS major this is for you. The requirements include the following:

  1. The program must be written in C# as a windows program
  2. The database must be Oracle or Microsoft SQL
    1. There must be at least 6 tables involved in the application
    2. You need to include VIEWs and at least one Stored procedure or trigger.

In the past students have created:

  1. In the past, several students created a movie database that included the ability to launch movies, search by genre, actor/actress, period, and many others. IMDB is a good place to look for ideas about what should be in the database.
  2. Spatial Applications. Track locations and map them on Google Earth. The heart of any spatial application is finding a suitable subset of data to collect. I had one student enter data on Mines (as in old west mines) complete with video, pictures, and functionality to find the mines on google earth. Also we have ArcGIS available that can be programmed. If there is anyone interested in writing software to create polygons out of existing data for ArcGIS let me know.

  3. Database tools - http://www.red-gate.com/ has a bunch of tools that could use opens source equivalents.

  4. Just about any hobby includes data that you could write an application for.

Research Programming Tools