Enhancing Gym Web Application using HTML and SQL

The provided content discusses the application of HTML and SQL in a web-based RTT Gym. It highlights the flexibility and reduced load offered by HTML, making it an effective choice for client-side implementation. Additionally, SQL database design enables easy linking between front-end and back-end, providing better reliability and supporting insert, update, and delete operations.

WEB APPLICATION

TABLE OF CONTENTS
Introduction..........................................................................................................................................4
Task 1....................................................................................................................................................4
1.1 Critically evaluating the functions and advantages of web applications..............................4
1.2 critically comparing different types of server-side and client-side scripting languages.......4
1.3 Examine web security concerns and make recommendations for security improvement....5
Task 2....................................................................................................................................................5
2.1 Designing web application to meet a given requirement......................................................5
2.2 Explaining client-side and server-side functionality in a web application...........................8
2.3 Applying database design for use in a web application.......................................................8
Task 3....................................................................................................................................................9
Implementation...........................................................................................................................9
Task 4....................................................................................................................................................9
Testing of website.......................................................................................................................9
REFERENCES...................................................................................................................................10

ILLUSTRATION INDEX
Illustration 1: Homepage......................................................................................................................6
Illustration 2: Services..........................................................................................................................7
Illustration 3: Login page.....................................................................................................................8

INTRODUCTION
Web application is a client-server program which is stored on the remote server and
transmitted over the Internet through a browser interface. It is necessary for organization to manage
its web based software which help to handle its business activities (Harley and et.al., 2013). RTT
(Reverse time trainer) is Gym which provides personal and specialized training, boot camp and diet
planning in United Kingdom. The present report evaluates advantages and disadvantage of web
based applications. It describes of web based security issues and its recommendations for Gym.
Further, it designs web based application to meet out the given requirement of RTT. In addition to
this, it also represents implementation of web programmes into the server. It introduces various type
of testing to test web applications which help to validate and verify the website.
Task 1
1.1 Critically evaluating the functions and advantages of web applications
As per Sudhendra, Ranganath and Nandan (2016), Generally, Web based application run
through web browser like internet explorer as well as Google chrome etc. In addition to this, main
functions of web pages are interacting with users through requesting and responding with the help
of internet (Sudhendra, Ranganath and Nandan, 2016). According to Hill, Cronk and
Wickramasekera (2013), Web based application contribute effective role for Gym to reduce its
business cost which provide huge reliability to manage its business operations (Hill, Cronk and
Wickramasekera, 2013). On the other side, sometimes, web based application create problem to
access data due to lack of internet speed and limitations of server (Januszewski and Molenda,
2013). As per Brent (2013), it provides better opportunity to store all data on the centralize server
which gives effective data safety to RTT (Brent, 2013). According to Ghimire, and Pimbert (2013),
reduced speed of client-server model creates problems to visit website of company and it generate
issues to open the web pages. In addition to this, it affects the performance and efficiency of RTT
(Ghimire and Pimbert, 2013). As per Wasson (2015), it provides effective compatibility to run
application on various type of platform like Windows, Linux and Mac. This process gives effective
flexibility to management of firm to manage its online operations (Wasson, 2015). On the contrary
note, web based application does not support all web browsers which create problems for many
users to access different data.
1.2 Critically comparing different types of server-side and client-side scripting languages
Comparison of client side and server-side script-language is given in the paragraph stated as below:
According to Thüm and et.al, (2014), client-side script-language is used to run various types
of scripts on the browser. In addition to this, it takes place on the end users and source code of web
based applications is transferred from the web server to the users over the internet. Further, client

side scripting language run directly in the browser of service users (Thüm, T. and et.al., 2014). On
the other side, web based applications needs to be installed and enabled on the client computer
(Ghiani, and et.al., 2016).
Harley and et.al, (2013) says that server-side environment which runs a scripting language in
the web server. Generally, user's request is responded by running a script directly on the web server
which helps to produces dynamic HTML pages. These codes of HTML are sent to the client
browser which provide effective reliability for user to assess its information (Harley and et.al.,
2013). According to Sudhendra, Ranganath and Nandan (2016), server-side script-language is
utilized to give attractive web sites which provides proper interface to databases (Sudhendra,
Ranganath and Nandan, 2016).
1.3 Examine web security concerns and make recommendations for security improvement
There are many Web security concerns such as hacking, cracking as well as phishing which
affect RTT very badly. These threats steal data of company which produces huge loss of its
monetary funds. Generally viruses are other issue for website security because they hang computers
and servers. In addition to this, they affect performance and efficiency of web based application
which also creates bad impact on the RTT (Hill, Cronk and Wickramasekera, 2013). Further,
security updates are main issues which increase threat of inappropriate activities like hacking in the
Gym.
Recommendations
This suggestion can help the management of Gym to improve web based applications. RTT
can use web security protocols like IPV6 and firewalls which can contribute effectively to stop
these illegal activities like hacking and phishing. In addition to this, Gym can use proper anti-virus
and effective security application which can help to remove the viruses and malware. Further, RTT
can use bio-metric security system to stop unauthorized access of unknown people. This process
can effectively help RTT to reduce its stealing of important data from server.
TASK 2
2.1 Designing web application to meet a given requirement
RTT is Gym which provides boot camp, diet planning, personal and specialized training for
the kind of people in United Kingdom. Generally, firm wants to enhance its business and services.
So, this online website can contribute an effective role for firm to expand its online business in the
service sector. As per company’s requirement, this website can help RTT to establish business
which can help to increase its services (Januszewski and Molenda, 2013). It contains various types
of web pages like homepage; contact us, about us and product and services. Developers can
consider can PHP tool as front hand and MY SQL back hand to develop website of RTT.

Web pages: RTT contains various types of web pages which are described below in the points.
Home page: Homepage of RTT helps the online users to navigate all websites. In addition to this, it
also represents Menu, home, contact, packages, trainer, Gallery, services, results, legal and
downloads and login on Home pages of Gym.
Packages: RTT Gym shows yearly, half yearly, quarterly and monthly packages to consumers at the
webpage.
Trainers: It describes about the name of general and personal trainers at the website which provides
help to consumers.
Gallery: It explains the picture and videos of different types of exercises like swimming, boot camp
and running at the web page.
Services: It shows main services of Gym in the United Kingdom. RTT represents different types of
Gym services and services like running, boxing and swimming, diet planning, personal training and
Boot camp at the workplace.
Illustration 1: Homepage

Results: It represents the results of customers before and after joining RTT Gym. In addition to this,
it helps to analyze the results of them in an appropriate manner.
Legal: It introduced about the website disclaimer and its terms and conditions. It also helps the
consumers to ensure that whether website is genuine or not.
Download: It provides online booklets of services and activities which support the service users to
do physical exercise.
Contact: It describes about the address and contact numbers of Gym in London.
Address of company: World trade building, London, UK
Contact No. 0986- 3456474
Email- [e-mail]
About us: This web page provides brief information about Gym which helps the online users to
know about RTT Company.
Log In: This is one of the most important features of this website which provides authority to
individuals to create their own account. Here, a person can set their own login account where all
services can be selected by her/him. No other can access their personal account. It provides access
to the consumers and trainers to show physical reports through entering user name and password at
the website. In addition to this, it provides authority to update changes.
Illustration 2: Services

2.2 Explaining client-side and server-side functionality in a web application
Generally, RTT can use various types of languages to develop appropriate Gym web site.
Firm can use HTML at the client side and PHP at the server side to make web site. Further, PHP
provides effective reliability to developers of Gym to run the website the on the any platform like
windows, Linux and Mac. In addition to this, systems such as Memcache, MongoDB as well as
Pusher provide effective integration which reduces many complexities of developers regarding
integration of web site. By using PHP sever side; it gives effective reliability to fix the web
application related issues (Taei, 2013). In addition to this, by using HTML at client side, it provides
huge flexibility for client to assess the data very fast. Further, it produces less load as comparison
other web based language which provide effective help to manage server of RTT in a appropriate
manner. Most development tools highly support the HTML which gives effective compatibility to
run Gym web site of RTT at the client side (Brent, 2013).
2.3 Applying database design for use in a web application
RTT Gym can use SQL language to design appropriate database of web application. Further,
this process can help the developers to link the front end and back end very easily. In addition to
this, it can provide better reliability to access the database of RTT. SQL database design can help
the Gym to Insert, Update as well as Delete operations on the website (Wasson, 2015). These
activities are represented below in the paragraph.
Insert operation can help RTT to insert any type of data into database. For example,
INSERT INTO Consumer (Consumer Name, Contact Number, Address, City, Country)
VALUES ('Cardinal','John Niight','788769756',' 40009','London','United Kingdom');
Update operation can help the RTT to update any data into database. For example,

UPDATE Consumers
SET ContactName='Rosamund pike', City='Newyork'
WHERE Consumer Name='Rosamund pike';
Delete operations can be used to delete any type of information from data base. For example,
DELETE FROM Consumers
WHERE ConsumerName='Tom Knight' AND City='London';
TASK 3
Implementation
TASK 4
Testing of website

REFERENCES
Books and Journals
Brent, R. P., 2013. Algorithms for minimization without derivatives. Courier Corporation.
Ghiani, G. and et.al., 2016. An environment for End-User Development of Web mashups.
International Journal of Human-Computer Studies. 87. pp.38-64.
Ghimire, K. B. and Pimbert, M. P., 2013. Social change and conservation. Routledge.'
Harley, L. and et.al., 2013. Human-Computer Interaction. Users and Contexts of Use. pp. 285-294.
Hill, C. W., Cronk, T. and Wickramasekera, R., 2013. Global business today. McGraw-Hill
Education (Australia).
Januszewski, A. and Molenda, M. eds., 2013. Educational technology: A definition with
commentary. Routledge.'
Sudhendra, A. S., Ranganath, C. P. and Nandan, G. T., 2016. Web Based Application for Cashew
Industry on Cloud. Imperial Journal of Interdisciplinary Research. 2(4).
Thüm, T. and et.al., 2014. FeatureIDE: An extensible framework for feature-oriented software
development. Science of Computer Programming. 79. pp.70-85.
Wasson, C. S., 2015. System Engineering Analysis, Design, and Development: Concepts,
Principles, and Practices. John Wiley & Sons.
Online
Taei, P. J., 2013. Advantages of PHP. [Online]. Available through:
<http://www.webnethosting.net/10-advantages-of-php-over-other-languages/>. [Accessed on
17th March 2016].