1 / 29

Eau Claire Jazz Fest Registration Database

Eau Claire Jazz Fest Registration Database. Presented by: Mark Forgette Patrick Fritz-Morkin Riley Schiefelbein. Eau Claire Jazz, Inc – Registration Database. Project Plan. Recap Eau Claire Jazz Inc. Non-profit organization to promote Jazz in the Chippewa Valley

Download Presentation

Eau Claire Jazz Fest Registration Database

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. Eau Claire Jazz Fest Registration Database Presented by: Mark Forgette Patrick Fritz-Morkin Riley Schiefelbein

  2. Eau Claire Jazz, Inc – Registration Database Project Plan

  3. Recap Eau Claire Jazz Inc. • Non-profit organization to promote Jazz in the Chippewa Valley • Run primarily by student volunteers • New organization with many IT needs

  4. Organizational Problem • Too much paper usage during festival • 20 reams (10,000 sheets) • Information spread over several locations • Unnecessary Repetition • Difficult to produce reports

  5. IT Objective Integrate a reliable registration database to house school information and produce required reports to aid in the success of the Jazz Festival.

  6. Stakeholders • Project team • Executive Director • Future volunteers • IT • System Users

  7. CASE Tools • MS Visio • MS Access • MS Project

  8. Overview Gantt / WBS

  9. Gantt / WBS

  10. Gantt / WBS cont.

  11. System Design

  12. Use Case

  13. DFD

  14. Web Registration Form

  15. Sequence

  16. Sample ERD

  17. ERD

  18. Sample Report

  19. Implementation Plan

  20. Testing • Alpha • Enter test data to ensure from functionality • Create reports based on queries we’ve written • Test cases • Invalid data • Duplication • Beta • Select a few users to test system usability

  21. Implementation • Cut-over installation • Not a very complex system from user standpoint • Remove duplication of data in two systems • Database run from a server share on campus • Organization has access to several computers

  22. Training • Will train executive director and a few volunteers • Find IS majors that will want to volunteer for ECJ • Documentation • Project website • User manual

  23. Deployment Plan

  24. Site • This slide describes the equipment and facilities

  25. Network Specs • This slide describes the servers etc…

  26. Security • Database stored on server that only allows ECJ users. • Database permissions set to only allow certain ECJ users. • Files backed up nightly as part of university procedure. • Possibility of third backup method

  27. Conclusion & Review • Where are we currently… • Questions

More Related