Goodland activities center management system
Download
1 / 18

Goodland Activities Center Management System - PowerPoint PPT Presentation


  • 67 Views
  • Uploaded on

Goodland Activities Center Management System. Senior Exit Project Richard Bauman. Outline. General Information about GAC GAC Needs Current Application Front End Future Application Front End General Information on Back End Current Application Back End Future Application Back End. About.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Goodland Activities Center Management System' - winda


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Goodland activities center management system

Goodland Activities Center Management System

Senior Exit Project

Richard Bauman


Outline
Outline

  • General Information about GAC

  • GAC Needs

  • Current Application Front End

  • Future Application Front End

  • General Information on Back End

  • Current Application Back End

  • Future Application Back End


About
About

  • Located in Goodland, Kansas – roughly 4,300 residents

  • Serves as the local gymnastics and sports center

  • Uses

    • Personal (leisure)

    • Competitions (community activities)

    • Education (mixed martial arts)

  • Anybody can become a member with a monthly fee

  • One of the few hot spots in Goodland


Needs
Needs

  • Better management system for:

    • Members

    • Events

    • Payments

    • Communication

  • Faster and more efficient use of looking up vital data

  • Back up business data

  • Simple software that is easy to use


Current application
Current Application

  • Online application

  • Simple user interface

  • Manages members, staff, and other contacts

  • Has flexible forms for quick lookups

  • Calculates when member payments are due






Future application
Future Application

  • Have more predefined forms that are often used

  • Make use of an online text editor

  • Send mass emails to specific groups of members

  • Entirely automate calculating monthly bills

    • Send bill via email or prepare postal mail to be printed

  • Integrate a calendar system to keep track of events

  • Install an SMS (Short Message Service)


The back end
The Back End

  • Technologies that were used:

    • Netbeans IDE – Powerful development environment

    • Apache 2.2 Server – Provide dynamic web pages

    • PHP – All web pages

    • JavaScript – Handle client side interactions

    • CSS – Design page layout and formatting

    • AJAX – Use of asynchronous data transfer

    • MySQL – Easy to use, Powerful database software

    • PHPMyAdmin – Easy to use, Powerful database manager



Current database design
Current Database Design

  • Database contains 4 tables:

    • Contacts

    • Membership

    • Emergency

    • Medical

  • Database contains 1 view:

    • Form

  • Primary key for each table is id.


Future database design
Future Database Design

  • Database will contain more tables to allow more complex relationships such as:

    • Business – 1 to many relationship

    • Activities – 1 to many relationship

    • Family – 1 to many relationship

    • Payment – 1 to many relationships


Future improvements
Future Improvements

  • Make the software more industrial strength

    • Have more error checking of input data

    • Associate related input fields and place constraints on the input where needed

    • Create a self-installer


Experiences gained
Experiences Gained

  • Worked with a real company

  • Technologies improved on:

    • CSS

    • PHP

    • AJAX

    • PHPMyAdmin



Sources
Sources

  • www.w3schools.com

  • https://developer.mozilla.org/en/AJAX

  • http://us.php.net/manual/en/index.php

  • http://www.comptechdoc.org/independent/web/cgi/javamanual

  • www.w3.org

  • http://bytes.com

  • www.tizag.com

  • www.webmasterworld.com

  • http://www.experts-exchange.com


ad