CPSC340A
Database Systems

Project

For the final project you will develop a program to help Healthy Roanoke Valley store and analyize data from community health surveys. The software will be used to help assess the health needs of people in the Roanoke valley to better collect and deploy resources. This will help with Healthy Roanoke Valley’s goal of improving the health of people in the Roanoke Valley.

Description

The program should be a native application, i.e. not a web application, that stores the database on the local file system. The program can be written in any langauge, using any graphical user interface library, and any non-server database implementation. The program should:

  1. Read the SurveyMonkey survey csv files.
  2. Generate reports based on survey data.
  3. Use data mining techniques to explore relationships in the data.

Evaluation

Your programs will be evaluated according to the following requirements:

  1. Read the SurveyMonkey survey csv files.

    1. Read the provided SurveyMonkey survey csv file.

    2. Read and utilize multiple additional SurveyMonkey survey csv files that are the for the same survey as the provided SurveyMonkey survey csv file.

    3. Read and utilize multiple additional SurveyMonkey survey csv files that are for different, unknown surveys.

  2. Generate reports based on survey data.

    1. Provide the user with statistics that summarize the data in meaningful ways.

    2. Provide the user with visualizations of the statistics.

    3. Allow the user to specify which questions to use in reports.

    4. Allow the user to specify conditions for grouping subsets of the data to use in reports.

  3. Use data mining techniques to explore relationships in the data

    1. Use a data mining technique to display information about the data.

    2. Provide a visualization of the data mining technique’s output.

    3. Allow the user to control the input to the data mining technique to assist exploring the data.

  4. Have an efficient and logical design and readable source code.

    1. Have source code that is easy to read and well documented.

    2. Have code that is efficient and logically balances memory and processor usage.

    3. Have a database design that is logical and efficient.

  5. Have an intuitive, easy to use user interface.

  6. Meets or exceeds the desires of the client.

Submission

Submit your program source code on the course Inquire page before class on Friday, April 29th.

You will present your programs during class on Friday April 29th.