AUTOMATED SPORTS CLUB BOOKING AND ENQUIRY SYSTem

Aim

The Ellesmere Sports and Leisure Club (“the club”) provides cricket, tennis, squash, bowls, and croquet facilities to its members.  In addition, there is a function room which is available to hire by anyone, and a bar / restaurant .Main forms of analysis were performed in order to determine problems with current systems – the first being interviews with members of staff.  A transcript of the interviews is included in appendix C.  The “Object Oriented Analysis and Design” module provided useful guidance when performing the analysis.

USER REQUIREMENTS

          This chapter outlines the user requirements and objectives of the system and relates them to the minimum requirements for the project.  

          After performing the preliminary analysis, it was ascertained that there are four different categories of people that will use the system.  Within these categories, people will have varying amounts of computer experience.

INTRODUCTION

             As a regular user of the University of Leeds Sports Centre it has come to my attention that there is room for improvement in the current procedures for booking sports facilities. Presently, sports users make bookings in person and sports centre staff record them by hand. It is felt that there would be benefits to both sports users and staff from automating this process.

As a sports user, I would prefer to be able to book facilities without the inconvenience of doing so in person. Discussion with friends found them to be in agreement. Perhaps of greater significance are the advantages an automated system would provide to staff members at a sports centre. Relieving them of any involvement in the booking process will save them time. Although making a single booking is not particularly time consuming, the procedure is repeated many times a day.

Although development costs are not an issue for this project, it is clear that the system would otherwise pay for itself within a few years. Therefore, it can be concluded that undertaking such a project is a feasible proposition.

An automated booking system could be of use to many sports centers, not just the one at the University. In many ways, a university sports centre is a special case as membership is limited to students for whom details are already known and there are issues relating to the priority usage of facilities for sports clubs, societies and Intra-mural activities. For this reason, the focus of this project will be on the development a generic solution that is suitable for a variety of sports centers.

System Analysis

Existing System

·        This is manual maintenance system.

·        Here some spread sheet is maintained for listing all the members and facilities.

·        Bookings are also maintained in the spread sheet.

·        Annual bills are provided by linking word processor using mail merge.

The current system:

Booking process           

At present, facilities must be booked in person during term time. Sports centre staff use a printed timetable to locate available timeslots for bookings. If payment is necessary, this is made with the booking and the sports centre user receives a numbered ticket as a receipt. This ticket is then shown when arriving to use the facilities and the booking is ticked off on the timetable sheet.

Issues

·          Staff currently spends a considerable amount of time administrating the booking of sports centre facilities. Their time could be spent more productively on other tasks or staffing could be reduced.

·          Users of the sports centre must book facilities in person. This can be a great inconvenience for those who do not live in the immediate vicinity of the sports centre.

·          There is currently no way for users to check what bookings they have outstanding without contacting sports centre staff. This can lead to more unnecessary use of staff time or users missing bookings.

·          Weekly booking records are kept on sheets of paper. If the sheets are lost or damaged there is no other method for staff to check what bookings have been made. Archived booking record sheets are also at risk of loss or damage to the only available copy.

Modules

Admin Module

          This module is for Administrator who organizes, schedules tasks and maintains the system.

Booking Schedule

          In this module users can access and can book sports club tasks. Board member can access and can book stadium

Club Promoters

          In this module different club promoters can see various tasks and organize them.

Maintenance Module

          In this module different maintenance tasks can be scheduled and maintained.

Categories of user  

1)  Non-member

2)  Member

3)  Club staff

4)  Administrative staff

  HARDWARE AND SOFTWARE REQUIREMENTS

HARDWARE REQUIREMENTS                              

PROCESSOR    :  Intel 2.0 GHz or above

HARD DISK     :  80 GB

RAM                 :    512 MB RAM.

   SOFTWARE REQUIREMENTS

OPERATING SYSTEM                     : WINDOWS XP with SP2. 

LANGUAGE (FRONT END)   : JAVA (JDK1.5/1.6)

SERVER                                     : APACHE TOMCAT 5.5/6.0

WEB TECHNOLOGY              : HTML, JAVASCRIPT, CSS.

DATABASE (BACK END)        : ORACLE 10G.

ARCHITECTURE                      : 3-TIER ARCHITECTURE.