1 / 20

Habitat for Humanity

Habitat for Humanity. National Database Design Review. National Database Team. Immanuel Alexander John Horst Anna Kretz Jeff Ross Noah Solomon. Rev. 01 Fall 2004. Problem Statement. Problems for HFHI

nedaa
Download Presentation

Habitat for Humanity

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Habitat for Humanity National Database Design Review PURDUE UNIVERSITY

  2. National Database Team Immanuel Alexander John Horst Anna Kretz Jeff Ross Noah Solomon PURDUE UNIVERSITY Rev. 01 Fall 2004

  3. Problem Statement • Problems for HFHI • No centralized survey administration and data collection system. Some local affiliates do their own surveying, but data is not shared. • There is no concrete quantitative data, currently, to show the benefits of the Habitat program to the community, both locally and nationally. • Homeowner information and responses must be securely collected, transferred, and analyzed to be in line with Habitat’s organizational mission. PURDUE UNIVERSITY

  4. Methodology • Proposed Solution • Having a centralized secure server database for survey information and homeowner responses • Homeowner ID’s will be requested from the server but will be kept in paper records as to ensure the security of the information being recorded. • The web-based program will consist of three main parts: • A Survey Generator • Homeowner Response Collection\Input • Statistical Analysis PURDUE UNIVERSITY

  5. Technical Solution • The current program relies on a single centralized database to hold the surveys, responses, and a list of questions and answers. It also relies on a web application to act as the front end to the database. • HFHI standards are to use Microsoft products. We have adhered to HFHI standards. We are using ASP.net and MS SQL for this tool. PURDUE UNIVERSITY

  6. Design Review • Technical Challenges • Skip patterns: How to represent and implement • New tools and Languages: Visual Studio .net, C#, ASP.net, T-SQL • Efficient automatically generated design documents • Other Challenges • Communication PURDUE UNIVERSITY

  7. PURDUE UNIVERSITY

  8. Login • Functionality is defined by the type of user logging in. • National User: HFHI employee • Local User: HFH local affiliate PURDUE UNIVERSITY

  9. Demo • Enter The Site PURDUE UNIVERSITY

  10. National Level: Users • 3 Options: Create, Edit, Delete • Stored User Information: • Affiliate Code • Email • Location • Login (Username) • Password (Hash) PURDUE UNIVERSITY

  11. Demo PURDUE UNIVERSITY

  12. National Level: Surveys • 4 Options: Create, Edit, Freeze, Decommission • Stored Survey Information: • Name • Questions • Response Types • Survey Status PURDUE UNIVERSITY

  13. Demo PURDUE UNIVERSITY

  14. National Level: Data • 2 Options: View, Download • Key Issues • Downloading text responses • Quantifying text responses PURDUE UNIVERSITY

  15. Local Level • 4 Options • Print Survey • Enter Responses • View Data • Edit Profile • Customer name is not stored by the local affiliate • Provides protection of personal information PURDUE UNIVERSITY

  16. Automatic Documentation Generation • For our C# code we are using a combination of XML tags and NDoc 1.3, free software. (example) • For our database we are still looking for a solution due to the large price tag on automatic documentation software. (example) • Apex SQL Doc ~ $200 • SQL Help ~ $75 • Others Even more expensive PURDUE UNIVERSITY

  17. Communication Status • Habitat For Humanity International • Habitat For Humanity University • Notre Dame • Butler • Ohio State PURDUE UNIVERSITY

  18. What is left? • Local User • View Survey • Print Survey • Enter Data • Retrieve Data • National • Manage Data • Overall • Documentation PURDUE UNIVERSITY

  19. Any Questions PURDUE UNIVERSITY

  20. Thank you PURDUE UNIVERSITY

More Related