Transcript Final Presentation

The Fitness Zone Database
CSCI 6838 Team #1
April 10th, Spring 2007
Hala Annab
Mark B. Jones
Wei (Lawrence) Liu
Jacqueline M. Matekwa Mbata
Team Information
Team Members




Hala Annab
Mark B. Jones
Wei (Lawrence) Liu
Jacqueline M. Matekwa Mbata
Mentor

Ms. Denise B. Cazes
Professor

2
Dr. Kwok-Bun Yue
[email protected]
[email protected]
[email protected]
[email protected]
Customer Information
UHCL Student Life Fitness Zone
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: [email protected]
Table of Contents






4
Introduction
Problem Analysis........................ Lawrence
Design ....................................... Jacqueline
Implementation........................... Hala
Project Management ................. Mark
References
Problem Analysis



5
Project Abstract
Problem Specification
Constraints and Limitations
Project Abstract

The application needs to track:
–
–
–


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

The UHCL Fitness Center runs several programs
and services
–
–
–


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

Problem of current system
–
–
–
–

Show Stopper
–
–

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

Network
–

Database
–

Cannot access the system off campus
MS Access is sufficient but not an enterprise solution
System
–
Needed from UCT




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



10
Three tier Web application architecture
Will run locally in the Fitness Zone
Client access via UHCL network
System Architecture
intranet
`
Application Server
Database
11
DataBase
Use Case Diagram
Update a Password
Add a New Program
Update an Existing Program
Administrator
Manager
Assign a Role
Revoke a Role
Generate a Report
12
Use Case Diagram
Search for Member
Check Member In
Update Activity Log
Add a Session
Check Member Out
Register a Member
Operator
Update a Membership
View a Report
Update 100 Mile Club Log
13
Database Design
14
Database Schema - 1

Persons
–

personID, … , typeID
PersonType
–
typeID, description

Some person type descriptions:
–
–
–
–
–
–
15
Employees
Student Employee
Students
Alumni
Dependants
Guests
Database Schema - 2

Programs
–

MemberPrograms
–
–
–
–
16
programIndex, programName, startDate, endDate, …
programIndex, personIndex
startDate, endDate, progress
fee,
goals
Database Schema - 3

Membership
–
–
–
–

Sessions
–

date, timeIn, timeOut
Rentals
–
17
lockerID, joinDate, endDate
membershipStatus, termIndex,
medicalCondition
tuitionPaymentStatus, membershipFeePayment, …
rentalIndex, termIndex, membershipIndex, lockerIndex, fee
Implementation

Three Tier Web Application
–
–
–
–
–
18
Microsoft IIS Web Server
Presentation layer (ASP.NET)
WebChart for creating graphical reports
Business logic (C#)
Database (MS Access)
Implementation Issues

Problems Encountered:
–
–
–

19
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.
Previous Application
20
User Interface
21
User Interface
22
User Interface
23
Project Screenshots
24
Prototype Evaluation

More intuitive and User Friendly
–



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





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
–

The system is designed with the future in mind
–
–
26
MS SQL Server, Oracle, or MySQL.
The application will scale as usage increases
Additional functionality can be added easily
Project Management

Development Team
–
–
–

27
Roles
Major Tasks
Project Plan
Conclusions
Development Team (Roles)






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)






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

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

Complete the Program management features
–
–
–

Complete the group email report
–

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





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 – WebChart
Program Standard -- C# Coding Standards