180 likes | 272 Views
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.
E N D
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 • 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 • 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 • 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 • 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 • 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 • Database contains 4 tables: • Contacts • Membership • Emergency • Medical • Database contains 1 view: • Form • Primary key for each table is id.
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 • 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 • Worked with a real company • Technologies improved on: • CSS • PHP • AJAX • PHPMyAdmin
Goodland Activities Center Management System • Questions?
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