Web Application Development: A Case Study of an Online Shoe Store

Desklib provides solved assignments and past papers to help students succeed.

Unit35: Web Application
Development

Contents
Introduction................................................................................................................................3
LO1: The concept of web application development..................................................................4
P1.1 Critically evaluate the functions and advantages of web applications..........................4
P1.2 Critically compare different types of server-side and client-side scripting languages.. 5
P1.3 Examine web security and make recommendations for security improvements...........6
LO2: Be able to design web applications...................................................................................7
P2.1 Design a web application to meet requirements given in the case study.......................7
P2.2 Synthesise client-side and server-side functionality in a web application...................11
P2.3 Apply a database design for the given scenario...........................................................13
P2.4 Evaluate alternative designs and solutions to meet the given requirement as explained
in the case study...................................................................................................................14
LO3: Be able to implement web applications..........................................................................16
P3.1 Implement a web application to a prepared design using client-side and server-side
scripting languages...............................................................................................................16
P3.2 Implement a web-enabled database management system to store, retrieve and
manipulate data in a web application...................................................................................17
LO4: Be able to test web applications......................................................................................22
P4.1 Critically review and test a web application using a web-enabled database
management system.............................................................................................................22
P4.2 Analyse actual test results against expected results to identify discrepancies.............25
P4.3 Critically evaluates independent feedback on a developed web application and make
recommendations for improvements....................................................................................25
P4.4 Creates user documentation for a developed multipage website.................................27
Conclusion................................................................................................................................28
References................................................................................................................................29
1

List of Figures
Figure 1:Home page...................................................................................................................7
Figure 2:Login............................................................................................................................7
Figure 3:Register........................................................................................................................8
Figure 4:Kidswear......................................................................................................................8
Figure 5:Womenswear...............................................................................................................9
Figure 6:Men's wear...................................................................................................................9
Figure 7:Cart............................................................................................................................10
Figure 8:3 tier architecture.......................................................................................................12
Figure 9: ER diagram...............................................................................................................13
Figure 10:Wordpress................................................................................................................14
Figure 11:Wix..........................................................................................................................15
Figure 12:Square Space............................................................................................................15
Figure 13:All tables..................................................................................................................17
Figure 14:Cart table..................................................................................................................18
Figure 15:Category...................................................................................................................18
Figure 16:order.........................................................................................................................19
Figure 17:Query.......................................................................................................................19
Figure 18:Register....................................................................................................................20
Figure 19:Shoes........................................................................................................................20
2

Introduction
In the assessment, there is a way to create a website and to manage the database. Therefore,
there is a connection between the database and the website. The website is built in the
scripting language that is HTML ad the CSS for styling the website. The website is all about
the footwear for kid’s women and men. There is a different section for this one can easily
move to that and see their favourite footwear’s. There is a simple method for ordering the
products.
The website contains the home page, login page, register page, contact us page, kid’s wear
page, women’s wear page and the men’s wear page. To implement the website, there was the
dummy server called the xampp was used.to understand in a more simple way go through the
entire file and also screenshots are there which will help to understand to in details.
3

LO1: The concept of web application development
P1.1 Critically evaluate the functions and advantages of web applications
The web application usually interacts with the request and respond to the users. In this the
report there is the shoe store which helps to buy the shoes for kids, women, and men. The
information is stored already with the price and the description of the products. With the help
of the website one can take advantage of the site: As today the online platform is used by
everyone to buy of to sell any types of products there for one can search any type of product
to buy it, they can pay by online payments methods, they can track the orders in the easiest
way. This business can be helpful for the retailers ,they can give the image of the product of
their store and then they can give to the website stakeholder to display that image to their
website and can take the order from that website and then if the order is placed by any
customer then the store will deliver to that customer if the customer is from same placed and
therefore the customer will get the order very easily and fast therefore the service is
becoming faster and the customer will easily able to take the product and track their orders.
Therefore, the website and the retailers are both in profit. The online business has made the
people more comfortable that they don’t need the time for these things wherever they find
themselves free they can see the product to them. This platform provides the free service of
returning the order and also replacing the orders. The applications of web help to update the
customer about the fashion going in the world, also this helps the vital role in the enterprises
because the customer can easily contact with their customers to call the delivery boy if they
find their product is not on time or so, they can also put their customer on the website in
contact us page for any kings of complain or so.
4

P1.2 Critically compare different types of server-side and client-side scripting
languages.
For any website there is the need of the languages which should be scripting language and the
server, there is the Server side can and also the Client side, In the website the language is
used is the HTML and the CSS, the dummy is there which is xampp and the client will run on
the browser and the server will process all the things.
The scripting language includes PHP, Java, Ruby, C++, C#, Python and many more. These
all languages are from the server - side, the languages such as the HTML, CSS, JavaScript
languages are used. Now let's discuss in detail about the language.
HTML: HTML is the hypertext mark-up languages which have tags in them, there is the
block for the programming languages, this describes the content on the website and
arrangement of the frames in the website, in terms of frames it is one of the strong languages
Python: This is one of the fastest server-side scripting languages, with the best benefit of the
small code which can be easily debugged, this language is easy to understand, to read and
with the simplest code, almost no complexities are there. This language is the most wanted
language nowadays in the market, the company such as Google, YouTube, all are working on
this platform, the language is object-oriented one with effective and powerful language.
CSS: The CSS stands for the Cascading, Style Sheet. This makes the website more attractive
because this helps to design the website the catchy one. All the effects colour are design by
this. Basically, it helps to decorate the website in the best effective way.
PHP: This language is basically for the connecting the website, this is the server side
language, this language is the used in many more site which is live too, namely the website
names are Facebook this was the first to design the website using PHP. This helps to work in
the field of database which manipulates the things if needed. In website, this work is in the
backend part.
Therefore, this was the little description of the languages using on the server side and the
client side. Both the server has to me co-ordinately work to make the best website (Docket, J.,
2011).
5

P1.3 Examine web security and make recommendations for security
improvements.
To enhance the sale of the product the web application is the best platform which helps to
increase the sale of the store. This also provides the security of the data and also provide the
information of the enterprises. The data might get hacked because the cyber-crimes are also
increasing data by day to prevent this the measure should be put forward so that the retailer
will be assured that their data will not go anywhere the access can be of the authorised person
only. To avoid the hacking or the trap of cybercrime the following, some steps can be taken:
Cross Site Scripting: In this when the user will input the file there is the error in the website
which can’t be executed. The coder usually makes the common mistake which gives the error
on the website. When the page runs, the script runs like it wants cookies which may be the
attacker's idea to grab the cookies and then take the data by not authorised. The attacker
usually attacks very blindly on the website, once the attack is successful the website data is
not safe, from the web application the email may go to the customer who placed the order,
the money which they are giving may not go to the original person, or the right person who
the customer has to give. The coders have to take care of these types of measures.
To prevent this, the HTML tags should not return to be clients. To avoid this, the defences
against the HTML injection should be there to avoid these types of attacks.
Insecure Direct Object References: When any customer buys the product they fill the
payment information the trust on the website that website is secure enough for the online
transactions. By name online one can understand that it is the internal object which has file,
database within it. The hacker can provide information on the website to other hackers, and
all of them may use in the worst ways. The hacker usually has a keen interest to break the
authorization and access the data from the web applications.
To prevent the problem of the Insecure Direct Object References The parameter CGI of the
client passes the internal data to avoid relying on the URL for the attackers (Carmona et al.,
2012).
6

LO2: Be able to design web applications
P2.1 Design a web application to meet requirements given in the case study.
Figure 1:Home page
Home Page:
This page is the home page which shows the home page of the website. This will help
customer to view the website, attract the customers to the website.
7

Figure 2:Login
Login:
This page will help the customer to log in with some details and provide the customer to
order the products, to log in there will be the email followed by the password.
Figure 3:Register
Register:
To get the update and order the product one should register themselves for the website and
can log in once they become a member of the web site and can order the products.
8

Figure 4:Kidswear
Kid’s wear page:
The shoe for the kids is available on this page. The shoes can be of both the boys and the
girls. The available stock is shown one can choose and order with the payment of the goods
and can enjoy the best sole of the shoes
Figure 5:Womenswear
Women’s Wear
The shoe for the women is available on this page. The shoes can be various type of footwear
of the girls. The available stock is shown one can choose and order with the payment of the
goods and can enjoy the best sole of the shoes.
9

Figure 6:Men's wear
Men’s wear
The shoe for the men is available on this page. The footwear can be of different types for the
boys the available stock is shown one can choose and order with the payment of the goods
and can enjoy the best sole of the shoes.
Figure 7:Cart
Cart:
The cart consists of the products ready for the order. It also consists of the page to upgrade
and continue the shopping can also the cart give the total of the products
10

P2.2 Synthesise client-side and server-side functionality in a web application.
The client and the server make the website by the coordination of each other, in this the
scripting language is used, there is the visual server also called as the dummy server, that is
the map server, when the client will visit the browser the client will request to the server for
anything then the server will respond to the requests and with some notification, to display
the proper result to the clients. The server-side scripting language will help the user to request
and response to the clients.
The work on which the server-side scripting language is used, there is languages such as
Ruby, PHP, Java, Python and many more languages are there. Now let me tell you that what
is a server, it is just the platform for the code, which is used for running on the computer,
which response to request of the HTTP. Server side does not tell about something which the
users can see if there is something wrong in the web application or the response to the client.
The URL is the only access for the HTTP they don’t give a response on all the URL only
selected one can respond to that URL. The user can see the pages.
The code of the client cans be performed on languages called the CSS or styling and the
HTML for coding and also the JavaScript, the information is stored does not save anywhere
whenever the user refreshes it they will disappear from everywhere.
The desktop app is mimicked which is for both the web application, the web application is
run by a combination of the client side and the server side. The homepage is the one who
saves the message and the loaded data that can have a simple browser. The GUI is on the
client site which handles the code of it. The GUI gives all the reaction to the input to the user.
The explanation of the three-tier architecture:
Data Tier: This is independent of the application and business logic.
Application Tier: The function which is processed by the application is seen by this layer and
this layer is called the middle layer and also the business logic and the logic tier.
Presentation Tier: The information’s are displays here and this is the topmost layer of the
application, this layer also communicates with the other layer to work over it (Bhardwaj, et
al., 2016, March).
11