The Fitness Zone Database CSCI 6838 Team 1

The Fitness Zone Database CSCI 6838 Team #1 April 10 th, Spring 2007 Hala Annab Mark B. Jones Wei (Lawrence) Liu Jacqueline M. Matekwa Mbata

Team Information Team Members l l Hala Annab Mark B. Jones Wei (Lawrence) Liu Jacqueline M. Matekwa Mbata Mentor l Ms. Denise B. Cazes Professor l 2 Dr. Kwok-Bun Yue halaannab@yahoo. com Mark. B. Jones@uth. tmc. edu lawrence_liu@hotmail. com Matekwa. Mbata. J 2428@uhcl. edu

Customer Information UHCL Student Life Fitness Zone l l 3 Denise Cazes, Fitness Zone Coordinator 2700 Bay Area Blvd. Houston, TX 77058 www. uhcl. edu/fitnesszone Front Desk: 281 -283 -2410 Coordinator: 281 -283 -3328 E-mail: cazes@uhcl. edu

Table of Contents l l l 4 Introduction Problem Analysis. . . Lawrence Design. . . . . Jacqueline Implementation. . . . Hala Project Management. . . . Mark References

Problem Analysis l l l 5 Project Abstract Problem Specification Constraints and Limitations

Project Abstract l The application needs to track: – – – l l Designing a three tier Web application The application needs to be: – – 6 facility usage program participation use of services. Easy to support Scalable

Problem Specification l The UHCL Fitness Center runs several programs and services – – – l l 7 Fitness Zone membership 100 Mile Club locker rental FZ needs an application to track facility usage, program participation, and use of services. Needs to be scaleable to support future programs and direct access by members.

Problem Specification l Problem of current system – – l Show Stopper – – l Crystal reports will not run User has to type the data into MS Excel instead Conclusion from end user – 8 Some modules are not executing Data is not saved to a centralized database Look and feel is not user-friendly Documentation and user guide are not sufficient Project was not complete

Constraints and Limitations l Network – l Database – l Cannot access the system off campus MS Access is sufficient but not an enterprise solution System – Needed from UCT l l Project Scope – – – 9 Install IIS Upgrade to. NET framework 2. 0 Grant administrator access Fulfill user’s requirements and set up a good architecture Leave space for future improvement Not enough time or resources to elaborate and resolve all issues

Design l l l 10 Three tier Web application architecture Will run locally in the Fitness Zone Client access via UHCL network

System Architecture 11

Use Case Diagram 12

Use Case Diagram 13

Database Design 14

Database Schema - 1 l Persons – l person. ID, … , type. ID Person. Type – type. ID, description l Some person type descriptions: – Employees – Student Employee – Students – Alumni – Dependants – Guests 15

Database Schema - 2 l Programs – l Member. Programs – – 16 program. Index, program. Name, start. Date, end. Date, … program. Index, person. Index start. Date, end. Date, progress fee, goals

Database Schema - 3 l Membership – – l Sessions – l date, time. In, time. Out Rentals – 17 locker. ID, join. Date, end. Date membership. Status, term. Index, medical. Condition tuition. Payment. Status, membership. Fee. Payment, … rental. Index, term. Index, membership. Index, locker. Index, fee

Implementation l Three Tier Web Application – – – 18 Microsoft IIS Web Server Presentation layer (ASP. NET) Web. Chart for creating graphical reports Business logic (C#) Database (MS Access)

Implementation Issues l Problems Encountered: – – – l Old Version of. NET Framework (1. 1) IIS was not installed Needed a solution for developing graphical reports Solutions: Worked with Mentor and UCT to: Update the. NET Framework to version 2. 0 – Install the IIS Web Server. We found a third party tool for developing graphical reports with ASP. NET. – 19

Previous Application 20

User Interface 21

User Interface 22

User Interface 23

Project Screenshots 24

Prototype Evaluation l More intuitive and User Friendly – l l l 25 Employee work flow and repetitive tasks were considered in UI design Scaleable / easy to maintain All features are not yet complete Complete features are independent, useful, and immediately useable

Vision for the Future l l l Move to a public Web server Members will access the system directly Reduce the work load for the manager and staff Add services and convenience for members. Migrate to a more robust database – l The system is designed with the future in mind – – 26 MS SQL Server, Oracle, or My. SQL. The application will scale as usage increases Additional functionality can be added easily

Project Management l Development Team – – – l 27 Roles Major Tasks Project Plan Conclusions

Development Team (Roles) l l l 28 Team Leader (Mark) – organize team efforts – ensure that the team is satisfying all course requirements. Webmaster (Mark, Jacqueline) – maintain the Project Web site. DBA (Jacqueline, Hala) – design, document, implement, and maintain the project database. Lead Programmer (Lawrence, Hala) – design the structure of the application modules – guide the coding efforts of other team members. System Administrator (Hala, Lawrence) – evaluating the computers in the Fitness center & install software. Technical Writer (Mark, Hala) – edit the documents produced by the team.

Development Team (Major Tasks) l l l 29 Determine Requirements Evaluate existing application Choose Technologies for Implementation Design and Implement Prototype Create complete and detailed documentation Install system and train Fitness Zone staff

Development Team (Project Plan) 30

Conclusions l The project has been successful – – – 31 Detailed Requirements were documented Database design is vastly improved User Interface is more intuitive Available features are fully functional System architecture is more flexible, scalable, and maintainable System documentation is improved

Suggested Next Steps l Complete the Program management features – – – l Complete the group email report – l 32 Create a new program Create participation report Automated email messages to participants Send mail to “locker renters” or “expiring members” Streamline the User Interface

References l l l 33 Project Requirement -- Original Project Description Group 3, Summer 2006 -- Previous Project Website User’s Website -- UHCL Fitness Zone Home Page Reporting tool -- ASP. NET control – Web. Chart Program Standard -- C# Coding Standards