Health Sports Center was established in year 2001 to provide customers with excellent sports facilities. It first started its business by providing gym facility. In year 2004, they expanded its service by adding more facilities including indoor and outdoor sports.
The company's current system has problems of cost and time management. The staffs receive phone calls from the customers for booking. The customers have to contact the center for available facilities, timing and reservation. Therefore, there is a problem of time management. The costs of the company exceeded the benefits of the company.
By introducing this system, it can provide 24 hours booking service where they can find all the required information.
Since the company's establishment, the staffs and the customers of the company are not much satisfied with the service outcome. Now, their objective is to introduce this online booking system is to welcome more number of customers and provide excellent service for members and staff satisfaction.
Therefore, for better management system, better customer service and staff satisfaction the company wants to introduce an online reservation system which will offer booking for 24 hours.
After the online booking system is introduced in the company, the staff is responsible for checking the bookings made by members. The customers must be a member first. It also allows non-members to sign up online. The staffs can update the facilities online instead of giving notice to the customers of the added facilities. The customers can add, view and delete bookings made.
Code & Unit Testing
Operations & Maintenance
The waterfall model is a process used in Software Development Life Cycle (SDLC) which follows a particular life cycle in order to ensure success in process of software development. As shown in the diagram, it has 5 phases.
Requirement Analysis: In this phase, all possible requirements of the system to be developed are gathered from the user who will be using the system.
Design: The requirement specifications from first phase are studied in this phase and system design is prepared. This phase helps in identifying hardware and system requirements and overall system architecture.
Code and Unit Testing: In this phase the work is divided into units and actual coding is started. The system is first developed in small programs called units and each unit is tested for its functionality, which is referred to as unit testing.
System Testing: The units are integrated into a complete system and tested to check if all units are functioning well according to the specifications.
Operations and Maintenance: In this phase, the problems which arise time to time are solved and the system is maintained.
Identifying and Managing changes:
A change order form is provided online for the staff feedback during the development of the system which will be submitted to the Project Manager.
The Change Request Form allows the company team to raise a formal request for a change to a project.
The Change Request Form will help us to:
Identify all changes before they occur
Implement a formal change approval process
Control the extent to which changes are approved
Monitor the effects of change implemented
Without proper change control, projects typically experience slippage, cost overruns and substantial delays. But by implementing this Change Request Form, we can monitor and control the effects of change on the project, substantially increasing our chances of success.
Procedures to fill request form:
Print the change request form. Fill the details and feedback and fax or drop the form in the center's reception.
CHANGE REQUEST FORM
Contact No: ____________________ E-mail Address:___________________________________
TYPE OF REQUEST
Add Change Remove
CHANGE REQUEST DETAILS
Impact if not implemented:
Expand Reduce Clarify
Expand Reduce Clarify
Increased Functionality Reduced Functionality
APPROVED BY: DATE:
Software to be used:
The software application to be used is web-based.
PHP version 5.0: PHP stands for PHP: Hypertext Preprocessor. It is a server-side scripting language for creating dynamic and interactive websites. It is open source software (OSS), widely used, free to download and use, and perfectly suited for Web development and can be embedded directly into the HTML code. It runs on different platforms such as Windows, Linux, UNIX, etc.
MySQL server 5.0: MySQL is a multithreaded, multi-user SQL database management system which provides multi-user access to the number of databases. It is ideal for both small and large applications, supports standard SQL, complies on a number of platforms, and is free to download and use.
Macromedia Flash 8: It is a set of multimedia technologies commonly used create adding animation, advertisements, and to develop rich internet applications. It can manipulate vector and raster graphics, and contains a scripting language called ActionScript.
The current system has the record of facilities data and member records in the database but for the facility reservation, staffs have to record manually into the database. So, for staffs searching the member records and entering reservation data is troublesome. In addition, the customers are not able to check their status data. The company has to implement new database system to be hosted to server's database so that members can access online.
Online facility reservation system
The customers have to register as a member and the information will be recorded into the database. Each member will have their own login account where they can view available facilities with reservation timing, and Help. If the facility is available they can make reservation. They will be able to view and delete reservation, change password, and make payment.
The company administration staffs will have the authority to access Facility and Reservation table where they can Add, View, Update, Delete service facilities and booking. They will not be authorized to access Staff table.
An Administrator has an authority to access all the tables in the database.
Database server requirements:
Operating system such as Linux or Windows 2000 Professional or XP Professional
Web Database server such as Apache, Xitami 2.5 of Microsoft IIS Server
PHP and MySQL or Microsoft .NET Framework and Microsoft SQL server
Large bandwidth limit
Medium to large SQL disk space
Medium to large Hard disk space
Hardware failure: The Company can apply different techniques to manage hardware failures. The techniques include frequent backup process, using UPS (Uninterruptible Power Supply) device which maintains a continuous supply of electric power to the connected equipment by supplying power from a different source when utility power is not available.
PHP is easy to implement and use with the today's technology.
Risks: Firewall and anti-virus software must be used to protect the system from external threats and information security.
The management is satisfied in using PHP scripting language as it is freeware software.
The system only provide member to make reservation. It does not provide a system to make payment online.
As this system is introduced for a better customer service the benefit is not directly targeted to the revenue. Therefore, outcome is uncertain. Meanwhile, the assumption taken is excellent customer service welcomes more customer.
This system is designed according to customer needs and service. This system will have easy navigation, user interface suited for any age group.
Estimates and plans
WBS (Task and time estimates):
Dell XPS 420 Desktop Computer
Linksys WRT544 Wireless - G Router
Linksys CM100 Cable Modem with USB ans Ethernet connections
Hewlett Packard ProLiant DL580 (418038 - 001) Server
Microsoft Windows Server 2003
Macromedia Dreamweaver 8
Macromedia Flash 8
MySQL server version 5.0
PHP version 5
Resources estimates : (System requirements; Software, hardware and manpower)
PHP version 5.0
MySQL server 5.0
Macromedia Flash 8