the fitness zone database csci 6838 team #1 march 1 st, spring 2007 hala annab mark b. jones wei...
TRANSCRIPT
![Page 1: The Fitness Zone Database CSCI 6838 Team #1 March 1 st, Spring 2007 Hala Annab Mark B. Jones Wei (Lawrence) Liu Jacqueline M. Matekwa Mbata](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e875503460f94b8b7cf/html5/thumbnails/1.jpg)
The Fitness Zone DatabaseCSCI 6838 Team #1
March 1st, Spring 2007
Hala AnnabMark B. JonesWei (Lawrence) LiuJacqueline M. Matekwa Mbata
![Page 2: The Fitness Zone Database CSCI 6838 Team #1 March 1 st, Spring 2007 Hala Annab Mark B. Jones Wei (Lawrence) Liu Jacqueline M. Matekwa Mbata](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e875503460f94b8b7cf/html5/thumbnails/2.jpg)
Team Information
Team Members Hala Annab [email protected] Mark B. Jones [email protected] Wei (Lawrence) Liu [email protected] Jacqueline M. Matekwa Mbata [email protected]
Mentor Ms. Denise B. Cazes
Professor Dr. Kwok-Bun Yue
![Page 3: The Fitness Zone Database CSCI 6838 Team #1 March 1 st, Spring 2007 Hala Annab Mark B. Jones Wei (Lawrence) Liu Jacqueline M. Matekwa Mbata](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e875503460f94b8b7cf/html5/thumbnails/3.jpg)
Customer Information
UHCL Student Life Fitness Zone Denise Cazes, Fitness Zone Coordinator
2700 Bay Area Blvd.Houston, TX 77058
www.uhcl.edu/fitnesszoneFront Desk: 281-283-2410Coordinator: 281-283-3328E-mail: [email protected]
![Page 4: The Fitness Zone Database CSCI 6838 Team #1 March 1 st, Spring 2007 Hala Annab Mark B. Jones Wei (Lawrence) Liu Jacqueline M. Matekwa Mbata](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e875503460f94b8b7cf/html5/thumbnails/4.jpg)
Table of Contents
Introduction Problem Analysis........................ Lawrence Design .......................................
Jacqueline Implementation........................... Hala Project Management ................. Mark References
![Page 5: The Fitness Zone Database CSCI 6838 Team #1 March 1 st, Spring 2007 Hala Annab Mark B. Jones Wei (Lawrence) Liu Jacqueline M. Matekwa Mbata](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e875503460f94b8b7cf/html5/thumbnails/5.jpg)
Problem Analysis
Project Abstract Problem Specification Constraints and Limitations
![Page 6: The Fitness Zone Database CSCI 6838 Team #1 March 1 st, Spring 2007 Hala Annab Mark B. Jones Wei (Lawrence) Liu Jacqueline M. Matekwa Mbata](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e875503460f94b8b7cf/html5/thumbnails/6.jpg)
Project Abstract
The UHCL Fitness Center needs an application to track facility usage, program participation, and use of services.
Designing a three tier Web application The application will be
– Easy to support– Scalable
![Page 7: The Fitness Zone Database CSCI 6838 Team #1 March 1 st, Spring 2007 Hala Annab Mark B. Jones Wei (Lawrence) Liu Jacqueline M. Matekwa Mbata](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e875503460f94b8b7cf/html5/thumbnails/7.jpg)
Problem Specification
The UHCL Fitness Center runs several programs and services– Fitness Zone membership– 100 Mile Club– locker rental– for students, faculty, staff, alumni, and family of faculty and staff.
FZ needs an application to track facility usage, program participation, and use of services.
This application will be supported by a Computer Science Student Assistant
needs to be scaleable to support future programs and direct access by members.
![Page 8: The Fitness Zone Database CSCI 6838 Team #1 March 1 st, Spring 2007 Hala Annab Mark B. Jones Wei (Lawrence) Liu Jacqueline M. Matekwa Mbata](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e875503460f94b8b7cf/html5/thumbnails/8.jpg)
Problem Specification
Problem of current system– Some modules are not executing– Data are not saved to a centralized database– Look and feel is not user-friendly– Documentation and user guide are not sufficient
Show Stopper– Crystal report shots exception and cannot run– User has to punch the data into MS Excel instead
Conclusion from end user– Project was not complete
![Page 9: The Fitness Zone Database CSCI 6838 Team #1 March 1 st, Spring 2007 Hala Annab Mark B. Jones Wei (Lawrence) Liu Jacqueline M. Matekwa Mbata](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e875503460f94b8b7cf/html5/thumbnails/9.jpg)
Constraints and Limitations
Network – Cannot access the system off campus
Database– Access is not optimal choice but have to use
System– Need UCT to set up IIS – Need to migrate from .NET framework 1.1 to 2.0– Need UCT to grant administrator access
Project Scope– 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
![Page 10: The Fitness Zone Database CSCI 6838 Team #1 March 1 st, Spring 2007 Hala Annab Mark B. Jones Wei (Lawrence) Liu Jacqueline M. Matekwa Mbata](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e875503460f94b8b7cf/html5/thumbnails/10.jpg)
Design
Three tier Web application architecture Will run locally in the Fitness Zone Client access via UHCL network
![Page 11: The Fitness Zone Database CSCI 6838 Team #1 March 1 st, Spring 2007 Hala Annab Mark B. Jones Wei (Lawrence) Liu Jacqueline M. Matekwa Mbata](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e875503460f94b8b7cf/html5/thumbnails/11.jpg)
System Architecture
`
Database
intranet
Application Server
DataBase
![Page 12: The Fitness Zone Database CSCI 6838 Team #1 March 1 st, Spring 2007 Hala Annab Mark B. Jones Wei (Lawrence) Liu Jacqueline M. Matekwa Mbata](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e875503460f94b8b7cf/html5/thumbnails/12.jpg)
Use Case Diagram
Administrator
Update a Password
Add a New Program
Update an Existing Program
Assign a Role
Revoke a Role
Manager
Generate a Report
![Page 13: The Fitness Zone Database CSCI 6838 Team #1 March 1 st, Spring 2007 Hala Annab Mark B. Jones Wei (Lawrence) Liu Jacqueline M. Matekwa Mbata](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e875503460f94b8b7cf/html5/thumbnails/13.jpg)
Use Case Diagram
Check Member In
Update Activity Log
Check Member Out
Add a Session
Search for Member
Register a Member
Update a Membership
View a Report
Operator
Update 100 Mile Club Log
![Page 14: The Fitness Zone Database CSCI 6838 Team #1 March 1 st, Spring 2007 Hala Annab Mark B. Jones Wei (Lawrence) Liu Jacqueline M. Matekwa Mbata](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e875503460f94b8b7cf/html5/thumbnails/14.jpg)
Abstract Class Diagram
Person
Student Faculty Staff Alumni
Dependant
None UHCL Person
Non-UHCL person is a
Primary Member
UHCL Person
1
UHCL person is a
Yoga100 Mile Club Rentals
Program ServicesMember
1..*0..* 1..*0..* 0..*0..* 0..*0..*
1
guests or dependants of UHCL persons
persons with a UHCL ID
0..n1
![Page 15: The Fitness Zone Database CSCI 6838 Team #1 March 1 st, Spring 2007 Hala Annab Mark B. Jones Wei (Lawrence) Liu Jacqueline M. Matekwa Mbata](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e875503460f94b8b7cf/html5/thumbnails/15.jpg)
Database Schema - 1
Persons (personID, firstName, lastName, addressID, birthDate, gender, username, password, driverLicence, uhclID, typeID)
PersonType (typeID, description) Employees (employeeID, personID, departmentName,
category, addressID) StudentEmployee (studentEmpID, personID, employeeID,
departmentName, category, addressID ) Students (studentIndex, personID, major, addressID) Alumni (alumniID, employerName, personID, addressID) Dependants (dependantID, personID, uhclID) Guests (guestID, checkInDate, personID, relationship,
programID, timeIn, timeOut )
![Page 16: The Fitness Zone Database CSCI 6838 Team #1 March 1 st, Spring 2007 Hala Annab Mark B. Jones Wei (Lawrence) Liu Jacqueline M. Matekwa Mbata](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e875503460f94b8b7cf/html5/thumbnails/16.jpg)
Database Schema - 2
Programs (programID, programName, description, offered, fee) Services (serviceID, serviceName, description, offered, fee) MemberPrograms (programID, memberID, startDate, endDate,
progress) MemberServices (serviceID, memberID, startDate, endDate,
progress) Membership (memberID, lockerID, joinDate, endDate,
membershipStatus, personID, membershipTypeID, medicalCondition, tuitionPaymentStatus, membershipFeePayment)
MembershipType (membershipTypeID, description)
![Page 17: The Fitness Zone Database CSCI 6838 Team #1 March 1 st, Spring 2007 Hala Annab Mark B. Jones Wei (Lawrence) Liu Jacqueline M. Matekwa Mbata](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e875503460f94b8b7cf/html5/thumbnails/17.jpg)
Database Schema - 3
Addresses (addressID, street, city, state, zipCode, country) Phonebook (phonebookID, workPhone, mobilePhone,
faxNumber, emailAddress, pager, personID) EmergencyContacts (contactID, firstName, lastName, email,
phoneNumber, personID) Lockers (lockerID, number, rented) Sessions (sessionID, personID, date, timeIn, timeOut) Rentals (rentalID, rentalType, memberID, lockerID, fee) RentalTypes (rentalTypeID, description) MedicalCondition (medicalConditionID, memberID, description) MemberMedicalCondition (medicalConditionID, memberID)
![Page 18: The Fitness Zone Database CSCI 6838 Team #1 March 1 st, Spring 2007 Hala Annab Mark B. Jones Wei (Lawrence) Liu Jacqueline M. Matekwa Mbata](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e875503460f94b8b7cf/html5/thumbnails/18.jpg)
Implementation
Three Tier Web Application– Microsoft IIS Web Server– Presentation layer (ASP.NET)– WebControl for creating charts (WebChart)– Business logic (C#)– Database (MS Access)
![Page 19: The Fitness Zone Database CSCI 6838 Team #1 March 1 st, Spring 2007 Hala Annab Mark B. Jones Wei (Lawrence) Liu Jacqueline M. Matekwa Mbata](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e875503460f94b8b7cf/html5/thumbnails/19.jpg)
Implementation Issues
Problems Encountered:– Old Version of .NetFramework (1.1)– IIS is not installed– Using Charts is not direct. The need to come with a solution to
develop a webchart.
Techniques used to overcome: Ask Mentor and the UCT to do the following:
– Update the .NetFrameWork to version 2.– Install the IIS Web Server.We found a solution to develop a webchart with ASP.NET. We have tried a small application to make sure it works.
![Page 20: The Fitness Zone Database CSCI 6838 Team #1 March 1 st, Spring 2007 Hala Annab Mark B. Jones Wei (Lawrence) Liu Jacqueline M. Matekwa Mbata](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e875503460f94b8b7cf/html5/thumbnails/20.jpg)
Mockup Examples
![Page 21: The Fitness Zone Database CSCI 6838 Team #1 March 1 st, Spring 2007 Hala Annab Mark B. Jones Wei (Lawrence) Liu Jacqueline M. Matekwa Mbata](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e875503460f94b8b7cf/html5/thumbnails/21.jpg)
Mockup Examples
![Page 22: The Fitness Zone Database CSCI 6838 Team #1 March 1 st, Spring 2007 Hala Annab Mark B. Jones Wei (Lawrence) Liu Jacqueline M. Matekwa Mbata](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e875503460f94b8b7cf/html5/thumbnails/22.jpg)
Future Directions
The vision for the future– move to a public Web server– members will access the system directly.
This should reduce the work load for the manager and staff Add services and convenience for members. As the system grows it may also be necessary to migrate to a
more robust database such as MS SQL Server, Oracle, or MySQL.
The system will be designed with the future in mind– application will scale as usage increases– additional functionality can be added easily.
![Page 23: The Fitness Zone Database CSCI 6838 Team #1 March 1 st, Spring 2007 Hala Annab Mark B. Jones Wei (Lawrence) Liu Jacqueline M. Matekwa Mbata](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e875503460f94b8b7cf/html5/thumbnails/23.jpg)
Project Management
Development Team– Roles– Major Tasks– Project Plan
Conclusions
![Page 24: The Fitness Zone Database CSCI 6838 Team #1 March 1 st, Spring 2007 Hala Annab Mark B. Jones Wei (Lawrence) Liu Jacqueline M. Matekwa Mbata](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e875503460f94b8b7cf/html5/thumbnails/24.jpg)
Development Team (Roles)
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.
![Page 25: The Fitness Zone Database CSCI 6838 Team #1 March 1 st, Spring 2007 Hala Annab Mark B. Jones Wei (Lawrence) Liu Jacqueline M. Matekwa Mbata](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e875503460f94b8b7cf/html5/thumbnails/25.jpg)
Development Team (Major Tasks)
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
![Page 26: The Fitness Zone Database CSCI 6838 Team #1 March 1 st, Spring 2007 Hala Annab Mark B. Jones Wei (Lawrence) Liu Jacqueline M. Matekwa Mbata](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e875503460f94b8b7cf/html5/thumbnails/26.jpg)
Development Team (Project Plan)
![Page 27: The Fitness Zone Database CSCI 6838 Team #1 March 1 st, Spring 2007 Hala Annab Mark B. Jones Wei (Lawrence) Liu Jacqueline M. Matekwa Mbata](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e875503460f94b8b7cf/html5/thumbnails/27.jpg)
Conclusions
The project is going according to schedule The Requirements Analysis Phase is complete and
the Design Phase is well underway Implementation constraints encountered have been
resolved by consulting with our client, UCT officials and our advisor.
With MS IIS, ASP .NET with C#, and Access database, the team expects to develop an application that fully meets the user requirements.
The database may be migrated to a more robust system such as the SQL Server in the future
![Page 28: The Fitness Zone Database CSCI 6838 Team #1 March 1 st, Spring 2007 Hala Annab Mark B. Jones Wei (Lawrence) Liu Jacqueline M. Matekwa Mbata](https://reader035.vdocuments.us/reader035/viewer/2022062322/56649e875503460f94b8b7cf/html5/thumbnails/28.jpg)
References
Project Requirement -- Original Project Description Group 3, Summer 2006 -- Previous Project Website User’s Website -- UHCL Fitness Zone Home Page Future reporting tool -- Third Party ASP.Net
controls – WebChart Program Standard -- C# Coding Standards