Web Application Development: Implementation and Database Integration
VerifiedAdded on 2024/07/01
|40
|5191
|143
Report
AI Summary
This document details the development of a web application, covering server-side and client-side scripting languages, their advantages, and disadvantages. It analyzes web security issues and provides recommendations for improvements, focusing on preventing unauthorized data access. The report outlines a three-tier architecture explaining server-client interaction and database usage. Alternative designs are evaluated for security features, and user documentation is included for project understanding. The e-commerce web application uses a database to store and retrieve information, with descriptions of server and client-side components. The report also covers the implementation of the web application based on the designed mock ups, including database integration, error handling and testing.
Contribute Materials
Your contribution can guide someone’s learning journey. Share your
documents today.
Contents
List of figures......................................................................................................................................... 1
Introduction........................................................................................................................................... 3
LO1. Understand the concepts 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
1.3 Examine web security and make recommendations for security improvements........................7
LO2 Be able to design web applications................................................................................................9
P2.1 Designs a web application to meet the requirements given in the case study..........................9
P2.2 Synthesise client-side and server-side functionality in a web application...............................12
P2.3 Apply a database design for the given scenario.......................................................................13
P2.4 Evaluates 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 Implements a web-enabled database management system to store, retrieve and manipulate
data in a web application.................................................................................................................22
P3.3 Identify and implement opportunities for error handling and reporting for the given case
study................................................................................................................................................ 25
LO4 Be able to test web applications.............................................................................................27
4.1 critically review and test a web application using a web-enabled database management
system 27
4.2 analyze actual test results against expected results to identify discrepancies....................32
4.3 critically evaluate independent feedback on a developed web application and make
recommendations for improvements.............................................................................................. 33
4.4 create user documentation for a developed web application.............................................35
Conclusion...........................................................................................................................................39
References........................................................................................................................................... 40
List of figures
Figure 1 design 1....................................................................................................................................9
Figure 2 design 2..................................................................................................................................10
Figure 3 design 3..................................................................................................................................10
Figure 4 design 4..................................................................................................................................11
Figure 5 use case................................................................................................................................. 11
Figure 6 Server side and client side interaction...................................................................................12
Figure 7 3 tier schema......................................................................................................................... 13
List of figures......................................................................................................................................... 1
Introduction........................................................................................................................................... 3
LO1. Understand the concepts 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
1.3 Examine web security and make recommendations for security improvements........................7
LO2 Be able to design web applications................................................................................................9
P2.1 Designs a web application to meet the requirements given in the case study..........................9
P2.2 Synthesise client-side and server-side functionality in a web application...............................12
P2.3 Apply a database design for the given scenario.......................................................................13
P2.4 Evaluates 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 Implements a web-enabled database management system to store, retrieve and manipulate
data in a web application.................................................................................................................22
P3.3 Identify and implement opportunities for error handling and reporting for the given case
study................................................................................................................................................ 25
LO4 Be able to test web applications.............................................................................................27
4.1 critically review and test a web application using a web-enabled database management
system 27
4.2 analyze actual test results against expected results to identify discrepancies....................32
4.3 critically evaluate independent feedback on a developed web application and make
recommendations for improvements.............................................................................................. 33
4.4 create user documentation for a developed web application.............................................35
Conclusion...........................................................................................................................................39
References........................................................................................................................................... 40
List of figures
Figure 1 design 1....................................................................................................................................9
Figure 2 design 2..................................................................................................................................10
Figure 3 design 3..................................................................................................................................10
Figure 4 design 4..................................................................................................................................11
Figure 5 use case................................................................................................................................. 11
Figure 6 Server side and client side interaction...................................................................................12
Figure 7 3 tier schema......................................................................................................................... 13
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
Figure 8 ER Diagram............................................................................................................................ 13
Figure 9 Use case................................................................................................................................. 14
Figure 10 home.................................................................................................................................... 16
Figure 11 add product......................................................................................................................... 16
Figure 12 login.....................................................................................................................................17
Figure 13 sign up................................................................................................................................. 17
Figure 14 brands.................................................................................................................................. 18
Figure 15 product 1............................................................................................................................. 18
Figure 16 product 2............................................................................................................................. 19
Figure 17 brands.................................................................................................................................. 19
Figure 18 login.....................................................................................................................................20
Figure 19 sign up................................................................................................................................. 21
Figure 20 products............................................................................................................................... 22
Figure 21 database.............................................................................................................................. 23
Figure 22 brands.................................................................................................................................. 23
Figure 23 dell.......................................................................................................................................23
Figure 24 mac...................................................................................................................................... 24
Figure 25 signup.................................................................................................................................. 24
Figure 26 sony..................................................................................................................................... 24
Figure 27 fields empty......................................................................................................................... 25
Figure 28 signup.................................................................................................................................. 26
Figure 29: Test case 1.......................................................................................................................... 28
Figure 30: login test case 1.................................................................................................................. 28
Figure 31: login test case 2.................................................................................................................. 29
Figure 32: Test case 3.......................................................................................................................... 29
Figure 33: Testing the Browser compatibility 1.................................................................................. 30
Figure 34: Testing the Browser compatibility 2.................................................................................. 30
Figure 35: Testing the Browser compatibility 3.................................................................................. 31
Figure 36: Homepage.......................................................................................................................... 35
Figure 37: Dell product........................................................................................................................ 35
Figure 38: MAC product.......................................................................................................................36
Figure 39: sony product....................................................................................................................... 36
Figure 40: Add product........................................................................................................................ 36
Figure 41: Admin login page................................................................................................................37
Figure 42: customer login....................................................................................................................37
Figure 43: customer sing up page........................................................................................................ 37
Figure 44: new brand product............................................................................................................. 38
Figure 9 Use case................................................................................................................................. 14
Figure 10 home.................................................................................................................................... 16
Figure 11 add product......................................................................................................................... 16
Figure 12 login.....................................................................................................................................17
Figure 13 sign up................................................................................................................................. 17
Figure 14 brands.................................................................................................................................. 18
Figure 15 product 1............................................................................................................................. 18
Figure 16 product 2............................................................................................................................. 19
Figure 17 brands.................................................................................................................................. 19
Figure 18 login.....................................................................................................................................20
Figure 19 sign up................................................................................................................................. 21
Figure 20 products............................................................................................................................... 22
Figure 21 database.............................................................................................................................. 23
Figure 22 brands.................................................................................................................................. 23
Figure 23 dell.......................................................................................................................................23
Figure 24 mac...................................................................................................................................... 24
Figure 25 signup.................................................................................................................................. 24
Figure 26 sony..................................................................................................................................... 24
Figure 27 fields empty......................................................................................................................... 25
Figure 28 signup.................................................................................................................................. 26
Figure 29: Test case 1.......................................................................................................................... 28
Figure 30: login test case 1.................................................................................................................. 28
Figure 31: login test case 2.................................................................................................................. 29
Figure 32: Test case 3.......................................................................................................................... 29
Figure 33: Testing the Browser compatibility 1.................................................................................. 30
Figure 34: Testing the Browser compatibility 2.................................................................................. 30
Figure 35: Testing the Browser compatibility 3.................................................................................. 31
Figure 36: Homepage.......................................................................................................................... 35
Figure 37: Dell product........................................................................................................................ 35
Figure 38: MAC product.......................................................................................................................36
Figure 39: sony product....................................................................................................................... 36
Figure 40: Add product........................................................................................................................ 36
Figure 41: Admin login page................................................................................................................37
Figure 42: customer login....................................................................................................................37
Figure 43: customer sing up page........................................................................................................ 37
Figure 44: new brand product............................................................................................................. 38
Introduction
This document is preparing for web application development in which server side and client
side language are described. The report describes scripting languages with their advantages and
disadvantages to determine the security issues and their solution to enhance the performance of
the web-based application. The three-tier architecture explains the interaction between the
server and client side along with the use of the database. The web security issues are also
provided with the recommendations which help in the future to prevent any attacks. The
alternative designs explain their use with security features to identify which is better or not. The
user documentation gives full knowledge of this project and easily understood by the user. The
database is used to store and retrieve information of e-commerce web application for which it is
developed. It provides a description of each server and client-side components which are
required to understand.
This document is preparing for web application development in which server side and client
side language are described. The report describes scripting languages with their advantages and
disadvantages to determine the security issues and their solution to enhance the performance of
the web-based application. The three-tier architecture explains the interaction between the
server and client side along with the use of the database. The web security issues are also
provided with the recommendations which help in the future to prevent any attacks. The
alternative designs explain their use with security features to identify which is better or not. The
user documentation gives full knowledge of this project and easily understood by the user. The
database is used to store and retrieve information of e-commerce web application for which it is
developed. It provides a description of each server and client-side components which are
required to understand.
LO1. Understand the concepts of web application development
P1.1 Critically evaluate the functions and advantages of web applications
Web Application:
A web application is a type of program which is accessible over the network with the help of
some connections like HTTP protocol. The web-based application can run on any browser as it
supports various browsers. The programming of the web application is done by HTML and
CSS which helps in making forms and designing of those forms. It requires a web server which
connects the server and client through the internet. The server-client is used to manage requests
to access the web application by giving a response to the client by the server ( Fitz-Rodríguez,
Kubota, Giacomelli, Tignor, Wilson & McMahon, 2010). The client-side part is done by
HTML and CSS or some other language like JavaScript, PHP, etc. The server-side
development is done by Perl, ASP.NET, PHP, Python, etc.
Web-based application accessibility:
Nowadays, the developer focus on every type of person to make a website accessible by anyone
in some way. The company wants the website to sell their laptops and for this, the developer
needs to focus on customer requirements along with their accessibility. So this website also
supports some special functionaries which help the customer to search laptops of their need.
Users of Web application:
This company is based on e-commerce in which they want to improve financial conditions by
making profits. It can be possible when the interaction of the user will increase towards the web
application. This website is designed by keeping aspects of the public sector and private sector
which enables communication between the customer and company.
Functions:
Account Profile:
This web application provides an option for users to manage their profiles on the company
website. The users can add their personal info which is used in checkout some item such as
username, contact details, email address, etc.
Cart:
The web application provides a shopping cart to the users as this is an e-commerce laptop
company who wants to sell their laptops to enhance performance. The shopping cart helps users
to analyze what they are going to shop.
Product details:
This section is designed in a web application for the employees of Laptop Company in which
they can add details about the product like description, price, images of the product, etc.
Order Processing:
The web application can help users to place their orders and it’ll be received by the company.
But order updates are necessary to analyze the processing. So this field will provide updates
over the places order which is updated through company employees.
P1.1 Critically evaluate the functions and advantages of web applications
Web Application:
A web application is a type of program which is accessible over the network with the help of
some connections like HTTP protocol. The web-based application can run on any browser as it
supports various browsers. The programming of the web application is done by HTML and
CSS which helps in making forms and designing of those forms. It requires a web server which
connects the server and client through the internet. The server-client is used to manage requests
to access the web application by giving a response to the client by the server ( Fitz-Rodríguez,
Kubota, Giacomelli, Tignor, Wilson & McMahon, 2010). The client-side part is done by
HTML and CSS or some other language like JavaScript, PHP, etc. The server-side
development is done by Perl, ASP.NET, PHP, Python, etc.
Web-based application accessibility:
Nowadays, the developer focus on every type of person to make a website accessible by anyone
in some way. The company wants the website to sell their laptops and for this, the developer
needs to focus on customer requirements along with their accessibility. So this website also
supports some special functionaries which help the customer to search laptops of their need.
Users of Web application:
This company is based on e-commerce in which they want to improve financial conditions by
making profits. It can be possible when the interaction of the user will increase towards the web
application. This website is designed by keeping aspects of the public sector and private sector
which enables communication between the customer and company.
Functions:
Account Profile:
This web application provides an option for users to manage their profiles on the company
website. The users can add their personal info which is used in checkout some item such as
username, contact details, email address, etc.
Cart:
The web application provides a shopping cart to the users as this is an e-commerce laptop
company who wants to sell their laptops to enhance performance. The shopping cart helps users
to analyze what they are going to shop.
Product details:
This section is designed in a web application for the employees of Laptop Company in which
they can add details about the product like description, price, images of the product, etc.
Order Processing:
The web application can help users to place their orders and it’ll be received by the company.
But order updates are necessary to analyze the processing. So this field will provide updates
over the places order which is updated through company employees.
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
Features:
The web application supports the recovery of data like it auto-save the cart history.
It provides access to order history by tracking.
It provides different sections for the customer to search product as per their
requirements.
Advantages:
The main advantage of the web application is it designed on one system but accessible
to anyone through the internet.
The web-based application can work remotely as the user can access the website from
anyplace anytime.
It supports interoperability as the cart in a web application which is linked to user
account help to trace the orders.
The installation and maintaining of a web application are easier than desktop
applications.
The security is more in web applications as they follow some protocols which prevent
from attacks (Korte & Farlow, 2013).
P1.2 Critically compare different types of server-side and client-side scripting languages.
Server-side Scripting Languages:
The server side is used for interaction between user and servers through request and response
protocol (Proctor, Yang & Zhao, 2014). The server side works on granting permissions to the
user for accessing the website over the internet. It is developed by some following languages as:
Python:
It requires less line of code to develop a web application. This language follows object-oriented
concepts as it is powerful and oldest language used for server side.
Merits:
It supports various libraries which help to integrate any functionality.
It is a simple and easy language as its code is like normal English words.
Demerits:
Its execution process is slower than others.
Due to restrictions, it doesn’t give runtime errors.
PHP:
It is the most commonly used language which stands for Hypertext Pre-processor. This
language used SQL language to maintain a database for the web application. It is basically
designed to edit the information and pull information from the database.
Merits:
It doesn’t require additional code to develop a web application.
The web application supports the recovery of data like it auto-save the cart history.
It provides access to order history by tracking.
It provides different sections for the customer to search product as per their
requirements.
Advantages:
The main advantage of the web application is it designed on one system but accessible
to anyone through the internet.
The web-based application can work remotely as the user can access the website from
anyplace anytime.
It supports interoperability as the cart in a web application which is linked to user
account help to trace the orders.
The installation and maintaining of a web application are easier than desktop
applications.
The security is more in web applications as they follow some protocols which prevent
from attacks (Korte & Farlow, 2013).
P1.2 Critically compare different types of server-side and client-side scripting languages.
Server-side Scripting Languages:
The server side is used for interaction between user and servers through request and response
protocol (Proctor, Yang & Zhao, 2014). The server side works on granting permissions to the
user for accessing the website over the internet. It is developed by some following languages as:
Python:
It requires less line of code to develop a web application. This language follows object-oriented
concepts as it is powerful and oldest language used for server side.
Merits:
It supports various libraries which help to integrate any functionality.
It is a simple and easy language as its code is like normal English words.
Demerits:
Its execution process is slower than others.
Due to restrictions, it doesn’t give runtime errors.
PHP:
It is the most commonly used language which stands for Hypertext Pre-processor. This
language used SQL language to maintain a database for the web application. It is basically
designed to edit the information and pull information from the database.
Merits:
It doesn’t require additional code to develop a web application.
Thr SQL language works efficiently as database supporter.
Demerits:
The speed and its performance affected due to robust features.
The web application which is designed in PHP isn’t secured.
Ruby:
It is used to develop a web application in which complicated logic is required on the database
side. Ruby language bundles the functionality of database which is required in PHP with SQL
language. Developers need to use ruby on rails framework to develop server-side part of web
application.
Merits:
It doesn’t require database language.
The maintenance is easier and demands high traffic.
Demerits:
The logics are very complex which affect the performance of the web application.
Its runtime speed is slower than others.
Client-side scripting language:
These languages used for designing interface for the users. It only provides interaction between
the application and user by running on any browser directly (Kirda, Jovanovic, Kruegel &
Vigna, 2009).
HTML and CSS:
It is used to develop forms for the web-based application and to make attractive CSS provides
designing features. Both languages used to make structure and designing of structure for the
users on which they interact to access Website of Laptop Company.
Merits:
Easy to develop web forms and designing of forms.
It uses tags to develop pages which are easier than coding.
HTML based web application supported on any browser.
Demerits:
It is very less secure language.
It produces complexity for more lines of code.
Editing of web pages is difficult as it is nit centralized language.
Javascript:
It is used for client-side scripting as it develops an interface with the help of HTML and CSS. It
is different from java language and only used for front-end designing of web applications.
Merits:
Demerits:
The speed and its performance affected due to robust features.
The web application which is designed in PHP isn’t secured.
Ruby:
It is used to develop a web application in which complicated logic is required on the database
side. Ruby language bundles the functionality of database which is required in PHP with SQL
language. Developers need to use ruby on rails framework to develop server-side part of web
application.
Merits:
It doesn’t require database language.
The maintenance is easier and demands high traffic.
Demerits:
The logics are very complex which affect the performance of the web application.
Its runtime speed is slower than others.
Client-side scripting language:
These languages used for designing interface for the users. It only provides interaction between
the application and user by running on any browser directly (Kirda, Jovanovic, Kruegel &
Vigna, 2009).
HTML and CSS:
It is used to develop forms for the web-based application and to make attractive CSS provides
designing features. Both languages used to make structure and designing of structure for the
users on which they interact to access Website of Laptop Company.
Merits:
Easy to develop web forms and designing of forms.
It uses tags to develop pages which are easier than coding.
HTML based web application supported on any browser.
Demerits:
It is very less secure language.
It produces complexity for more lines of code.
Editing of web pages is difficult as it is nit centralized language.
Javascript:
It is used for client-side scripting as it develops an interface with the help of HTML and CSS. It
is different from java language and only used for front-end designing of web applications.
Merits:
The executing speed is faster than others.
It supports interoperability and versatility.
Demerits:
It is a less secure language for scripting at the client side.
Sometimes browser doesn’t support JavaScript which affects the accessibility.
1.3 Examine web security and make recommendations for security improvements.
Web Security:
The security on web application helps to prevent cyber attacks from intruders. Basically, it is
for analyzing the issues and responding them to prevent unauthorized access to the data. The
web security protects data information which is available online over the internet identify the
risks and their solutions to reduce the chances of attacks. It requires security for protecting user
accounts, their personal info, transaction details, etc. by monitoring and revoking the
permissions of intruders (Meier, 2010).
Merits:
It protects systems from viruses which can easily corrupt the data present in the system.
The security can be renewed after a limited period of time.
It manages data transmission over the internet and protects from intruders by the
following cryptography.
Demerits:
Due to more security plugins. It reduces the speed of accessibility.
The cost will increase with the increasing security features.
Some malicious functions break the web security.
Issues in web security:
The intruders attack the web application and break the security protocols through SQL
injection. It corrupts the data files and changes data through some manipulation
operations of the database.
Due to less maintenance, intruders access the data and made some changes which affect
the reputation of the web application.
Intruders can easily attack the client side languages as these scripting languages are less
secure compared to server-side language. The browsers sometimes hacked which
breaks the security protocols.
Recommendations:
The web application should pull the data though getting method under encryption and
decryption methodology which prevents attacks occurred on the client side.
It supports interoperability and versatility.
Demerits:
It is a less secure language for scripting at the client side.
Sometimes browser doesn’t support JavaScript which affects the accessibility.
1.3 Examine web security and make recommendations for security improvements.
Web Security:
The security on web application helps to prevent cyber attacks from intruders. Basically, it is
for analyzing the issues and responding them to prevent unauthorized access to the data. The
web security protects data information which is available online over the internet identify the
risks and their solutions to reduce the chances of attacks. It requires security for protecting user
accounts, their personal info, transaction details, etc. by monitoring and revoking the
permissions of intruders (Meier, 2010).
Merits:
It protects systems from viruses which can easily corrupt the data present in the system.
The security can be renewed after a limited period of time.
It manages data transmission over the internet and protects from intruders by the
following cryptography.
Demerits:
Due to more security plugins. It reduces the speed of accessibility.
The cost will increase with the increasing security features.
Some malicious functions break the web security.
Issues in web security:
The intruders attack the web application and break the security protocols through SQL
injection. It corrupts the data files and changes data through some manipulation
operations of the database.
Due to less maintenance, intruders access the data and made some changes which affect
the reputation of the web application.
Intruders can easily attack the client side languages as these scripting languages are less
secure compared to server-side language. The browsers sometimes hacked which
breaks the security protocols.
Recommendations:
The web application should pull the data though getting method under encryption and
decryption methodology which prevents attacks occurred on the client side.
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
The software which is used in developing web application should be fully updated and
it Maintenence is done on specific time which prevents unauthorized access through
browser or virus.
The developer should prepare statements which can cure the SQL injections by making
template statements. These statements prevent breaking security of web application.
it Maintenence is done on specific time which prevents unauthorized access through
browser or virus.
The developer should prepare statements which can cure the SQL injections by making
template statements. These statements prevent breaking security of web application.
LO2 Be able to design web applications
P2.1 Designs a web application to meet the requirements given in the case study.
The below are the web application designs which will be developed by the developer by
integrating all functionalities. These mockups designs determine the e-commerce web
application for the laptop company.
Figure 1 design 1
P2.1 Designs a web application to meet the requirements given in the case study.
The below are the web application designs which will be developed by the developer by
integrating all functionalities. These mockups designs determine the e-commerce web
application for the laptop company.
Figure 1 design 1
Figure 2 design 2
Figure 3 design 3
Figure 3 design 3
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
Figure 4 design 4
Figure 5 use case
Figure 5 use case
P2.2 Synthesise client-side and server-side functionality in a web application.
Client-side interacts with the server-side:
The web-based application is developed in 3 parts which are required to make fully functional
as client-side, server-side and database which stores data information. The database is designed
through some SQL language or from the bundled operation. Client-side is done through HTML,
CSS and any other language like JavaScript, jQuery which runs on the browser to provide an
interface for interaction by the user side. The server-side scripting is done through PHP along
with database through SQL to support front-end for the users. The server response to the request
generated by the client to access the web application. The below figure determine the
interaction between the client and server side (Lopes, Franz, Kazi, Donaldson, Morris & Bader,
2010).
Figure 6 Server side and client side interaction
It describes how site load on browser then process the request to get a response from the server.
The database called which sends a response to the client over the internet and server-side
process the data to the user which is maintained a database of the server.
Three-tier architecture:
The web-based application works on 3 different layers in which the client tier used for
interaction with the website. The interaction of the web application is rendered by the browser
and provided by the presentation layer which is client tier (Shinn & Walker, 2010).
The logic tier acts as server-side which supports the presentation layer by showing data
information over the internet to the user. The user can access information and use the
functionalities of the system. The database layer or tier stores the product information, user
account details, login details, payment details, etc.
Client-side interacts with the server-side:
The web-based application is developed in 3 parts which are required to make fully functional
as client-side, server-side and database which stores data information. The database is designed
through some SQL language or from the bundled operation. Client-side is done through HTML,
CSS and any other language like JavaScript, jQuery which runs on the browser to provide an
interface for interaction by the user side. The server-side scripting is done through PHP along
with database through SQL to support front-end for the users. The server response to the request
generated by the client to access the web application. The below figure determine the
interaction between the client and server side (Lopes, Franz, Kazi, Donaldson, Morris & Bader,
2010).
Figure 6 Server side and client side interaction
It describes how site load on browser then process the request to get a response from the server.
The database called which sends a response to the client over the internet and server-side
process the data to the user which is maintained a database of the server.
Three-tier architecture:
The web-based application works on 3 different layers in which the client tier used for
interaction with the website. The interaction of the web application is rendered by the browser
and provided by the presentation layer which is client tier (Shinn & Walker, 2010).
The logic tier acts as server-side which supports the presentation layer by showing data
information over the internet to the user. The user can access information and use the
functionalities of the system. The database layer or tier stores the product information, user
account details, login details, payment details, etc.
Figure 7 3 tier schema
P2.3 Apply a database design for the given scenario.
ER Diagram:
The below diagram represents an entity relationship for the given web application. In this
diagram, it shows the primary key elements for each entity group with their other attributes (Al-
Masree, 2015).
Figure 8 ER Diagram
P2.3 Apply a database design for the given scenario.
ER Diagram:
The below diagram represents an entity relationship for the given web application. In this
diagram, it shows the primary key elements for each entity group with their other attributes (Al-
Masree, 2015).
Figure 8 ER Diagram
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Figure 9 Use case
P2.4 Evaluates alternative designs and solutions to meet the given requirement as
explained in the case study.
This e-commerce web application can be designed through WordPress and Joomla which
fulfills the requirement of Laptop Company.
Joomla:
It is used for the development of web-based application as it is freely available CMS tool.
Basically, it is used for publishing content after the WordPress.
Merits:
It provides high functionality with a large number of extensions.
It is a very light framework used by the PHP to develop command applications.
It provides high resolution to the user which help in easily understanding of all features.
It supports more than 70 translation packs used for managing content.
Demerits:
It is not easier like WordPress.
Its maintenance is difficult.
It requires more plugins to make it attractable.
WordPress:
P2.4 Evaluates alternative designs and solutions to meet the given requirement as
explained in the case study.
This e-commerce web application can be designed through WordPress and Joomla which
fulfills the requirement of Laptop Company.
Joomla:
It is used for the development of web-based application as it is freely available CMS tool.
Basically, it is used for publishing content after the WordPress.
Merits:
It provides high functionality with a large number of extensions.
It is a very light framework used by the PHP to develop command applications.
It provides high resolution to the user which help in easily understanding of all features.
It supports more than 70 translation packs used for managing content.
Demerits:
It is not easier like WordPress.
Its maintenance is difficult.
It requires more plugins to make it attractable.
WordPress:
It is also freely available CMS tool used to develop web applications. It is based on PHP
framework along with MYSQL to maintain the database.
Merits:
It is a user-friendly CMS tool for the development of the web-based application.
It provides various plugins free to integrate into the web application.
It is open source and provides SEO optimization.
Demerits:
Their updates reduce the performance of the web application.
It is less secure in which an intruder can hack websites easily.
To make web application attractive, more planning is required to make it creative.
framework along with MYSQL to maintain the database.
Merits:
It is a user-friendly CMS tool for the development of the web-based application.
It provides various plugins free to integrate into the web application.
It is open source and provides SEO optimization.
Demerits:
Their updates reduce the performance of the web application.
It is less secure in which an intruder can hack websites easily.
To make web application attractive, more planning is required to make it creative.
LO3. Be able to implement web applications
P3.1 Implement a web application to a prepared design using client-side and server-side
scripting languages.
Client-side designs:
The below are the screen designs which is developed for client interaction over the internet.
Figure 10 home
Figure 11 add product
P3.1 Implement a web application to a prepared design using client-side and server-side
scripting languages.
Client-side designs:
The below are the screen designs which is developed for client interaction over the internet.
Figure 10 home
Figure 11 add product
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
Figure 12 login
Figure 13 sign up
Figure 13 sign up
Figure 14 brands
Figure 15 product 1
Figure 15 product 1
Figure 16 product 2
Server side:
These are the server side programming which supports front end interfaces.
Figure 17 brands
Server side:
These are the server side programming which supports front end interfaces.
Figure 17 brands
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Figure 18 login
Figure 19 sign up
Figure 20 products
P3.2 Implements a web-enabled database management system to store, retrieve and
manipulate data in a web application.
The below figure determines the database system for the web application (Elmasri & Navathe,
2010).
P3.2 Implements a web-enabled database management system to store, retrieve and
manipulate data in a web application.
The below figure determines the database system for the web application (Elmasri & Navathe,
2010).
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
Figure 21 database
Figure 22 brands
Figure 23 dell
Figure 22 brands
Figure 23 dell
Figure 24 mac
Figure 25 signup
Figure 26 sony
Figure 25 signup
Figure 26 sony
P3.3 Identify and implement opportunities for error handling and reporting for the given
case study.
This web application identifies some error handling methods which enhance the performance
of Laptop Company providing an effective solution.
Error Handling:
Error handling determines issues occurred in the web application by identifying, detecting
errors, interactivity issue, etc. The errors can be handled by using some commands like die,
error_reporting (), and some triggering of errors.
Reporting of errors:
error_reporting () functions report the error to some level which helps the developer to rectify
them (Carmichael, 2009).
In the below figure, the user needs to fill out all the fields for successful login into the system to
access its features.
Figure 27 fields empty
In the below figure, the user needs to sign-up by filling all required details in the field given in page.
In this, email should contain one @ to sign-up and password should contain 1 lowercase, uppercase,
special character to maintain security reasons.
case study.
This web application identifies some error handling methods which enhance the performance
of Laptop Company providing an effective solution.
Error Handling:
Error handling determines issues occurred in the web application by identifying, detecting
errors, interactivity issue, etc. The errors can be handled by using some commands like die,
error_reporting (), and some triggering of errors.
Reporting of errors:
error_reporting () functions report the error to some level which helps the developer to rectify
them (Carmichael, 2009).
In the below figure, the user needs to fill out all the fields for successful login into the system to
access its features.
Figure 27 fields empty
In the below figure, the user needs to sign-up by filling all required details in the field given in page.
In this, email should contain one @ to sign-up and password should contain 1 lowercase, uppercase,
special character to maintain security reasons.
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Figure 28 signup
LO4 Be able to test web applications
4.1 critically review and test a web application using a web-enabled database
management system
There is a designed an e-commerce website for Laptop4U organization which provide hardware
component of the system such RAM, printer, monitor, CPU, processor, keyboard, mouse, and so-on.
Here, I have tested the designed website according to user and system requirement. There is check
the website fulfill the user requirement such as browser compatibility, form, login process,
navigation between website page. There is designed a table for test plan which checks website
different type of level such as
S. No. Test Case
Description
Expected Outcome Actual Outcome Remark
1 Design of form:
any filed of the
form blank
There will be shown an
error message to fill the
data
Error message to
fill the form data
Performed
successfully
2 Login process:
user enters the
wrong password
or email id
There will be shown the
error message to enter
right email or password
Error message to
enter right login
details
Performed
successfully
3 Add cart
function: the
user is able to
save the product
in the cart
The product will be saved
into the cart
Product saved
into the cart
Performed
successfully
4 Testing the
Browser
compatibility
The website will be an
open different browser
such as chrome, firefox,
internet explorer
Website open
different type of
browser such as
chrome, firefox,
internet explorer
Performed
successfully
(Swain,
Mohapatra &
Mall, 2010)
Below image showed the test result of the website such as
4.1 critically review and test a web application using a web-enabled database
management system
There is a designed an e-commerce website for Laptop4U organization which provide hardware
component of the system such RAM, printer, monitor, CPU, processor, keyboard, mouse, and so-on.
Here, I have tested the designed website according to user and system requirement. There is check
the website fulfill the user requirement such as browser compatibility, form, login process,
navigation between website page. There is designed a table for test plan which checks website
different type of level such as
S. No. Test Case
Description
Expected Outcome Actual Outcome Remark
1 Design of form:
any filed of the
form blank
There will be shown an
error message to fill the
data
Error message to
fill the form data
Performed
successfully
2 Login process:
user enters the
wrong password
or email id
There will be shown the
error message to enter
right email or password
Error message to
enter right login
details
Performed
successfully
3 Add cart
function: the
user is able to
save the product
in the cart
The product will be saved
into the cart
Product saved
into the cart
Performed
successfully
4 Testing the
Browser
compatibility
The website will be an
open different browser
such as chrome, firefox,
internet explorer
Website open
different type of
browser such as
chrome, firefox,
internet explorer
Performed
successfully
(Swain,
Mohapatra &
Mall, 2010)
Below image showed the test result of the website such as
Figure 29: Test case 1
Figure 30: login test case 1
Figure 30: login test case 1
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
Figure 31: login test case 2
Figure 32: Test case 3
Figure 32: Test case 3
Figure 33: Testing the Browser compatibility 1
Figure 34: Testing the Browser compatibility 2
Figure 34: Testing the Browser compatibility 2
Figure 35: Testing the Browser compatibility 3
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
4.2 analyze actual test results against expected results to identify discrepancies
A web developer faced a number of issues during the website testing process. Here, I have defined
those condition of website testing which is failed some reason such as
Developer faced the issue during website functions. He checks that functions are working
correctly or not.
Test the website different level such as testing the Browser compatibility, Design of form,
Login process and so many. Some test processes are not managed by the developer’s hand.
These tests are depended on the customer feedback.
There is design a strong relationship with a web developer. For the website, there is needed an
experienced web developer who easily created the website according to user requirements
Test website under time restraints: the developer needs the time to perform a task such as for
resolve the errors, documentation, feedbacks, and implementation of the website with user
feedback.
This upstairs progress is identifying in Laptop4U organization are such as
There are added new computer system components on the website according to user
requirements and need.
There is designed a payment gateway for Laptop4U websites such as PayPal, Visa, Paytm and
MasterCard.
Laptop4U website needed a sign-up and login process to buy any product for the website.
Website developer makes sure that all function of the website works properly. They also
manage the product categories and product list
There are needed to introduce the product order cancellation policy according to user
requirements.
A web developer faced a number of issues during the website testing process. Here, I have defined
those condition of website testing which is failed some reason such as
Developer faced the issue during website functions. He checks that functions are working
correctly or not.
Test the website different level such as testing the Browser compatibility, Design of form,
Login process and so many. Some test processes are not managed by the developer’s hand.
These tests are depended on the customer feedback.
There is design a strong relationship with a web developer. For the website, there is needed an
experienced web developer who easily created the website according to user requirements
Test website under time restraints: the developer needs the time to perform a task such as for
resolve the errors, documentation, feedbacks, and implementation of the website with user
feedback.
This upstairs progress is identifying in Laptop4U organization are such as
There are added new computer system components on the website according to user
requirements and need.
There is designed a payment gateway for Laptop4U websites such as PayPal, Visa, Paytm and
MasterCard.
Laptop4U website needed a sign-up and login process to buy any product for the website.
Website developer makes sure that all function of the website works properly. They also
manage the product categories and product list
There are needed to introduce the product order cancellation policy according to user
requirements.
4.3 critically evaluate independent feedback on a developed web application
and make recommendations for improvements
The website is a collection of number pages which are properly connected each other through the
navigation process. If the user wants to develop a website for the first time, then it may be a
difficult process form developer side. After the launching Laptop4U website, users access the
website different platform. They give positive and negative feedback on the website. It helps to
improve the website quality. Here, I have created the feedback table with 5 users such as
User one feedback
Table 1: User one feedback question table
S.no. Feedback question User one
1 Is the website providing the secure payment gateway? Yes
2 Is the website user-friendly? Yes
3 Is the website used the high-quality image? No
User two feedbacks
Table 2: User two feedback question table
S.no. Feedback question User one
1 Is the website providing social media linking? No
2 Is the website user-friendly? No
3 Is the website contained the chat-boat? No
User three feedbacks
Table 3: User three feedback question table
S.no. Feedback question User one
1 Is the website contained proper navigation? Yes
2 Is the website browser compatibility? Yes
3 Is the website used the high-quality image? No
User four feedbacks
Table 4: User four feedback question table
S.no. Feedback question User one
1 Is the website providing contact form? yes
2 Is the website contained login and sing –up process? Yes
3 Is the website used the high-quality image? No
User five feedbacks
Table 5: User five feedback question table
S.no. Feedback question User one
1 Is the website adding cart function? Yes
and make recommendations for improvements
The website is a collection of number pages which are properly connected each other through the
navigation process. If the user wants to develop a website for the first time, then it may be a
difficult process form developer side. After the launching Laptop4U website, users access the
website different platform. They give positive and negative feedback on the website. It helps to
improve the website quality. Here, I have created the feedback table with 5 users such as
User one feedback
Table 1: User one feedback question table
S.no. Feedback question User one
1 Is the website providing the secure payment gateway? Yes
2 Is the website user-friendly? Yes
3 Is the website used the high-quality image? No
User two feedbacks
Table 2: User two feedback question table
S.no. Feedback question User one
1 Is the website providing social media linking? No
2 Is the website user-friendly? No
3 Is the website contained the chat-boat? No
User three feedbacks
Table 3: User three feedback question table
S.no. Feedback question User one
1 Is the website contained proper navigation? Yes
2 Is the website browser compatibility? Yes
3 Is the website used the high-quality image? No
User four feedbacks
Table 4: User four feedback question table
S.no. Feedback question User one
1 Is the website providing contact form? yes
2 Is the website contained login and sing –up process? Yes
3 Is the website used the high-quality image? No
User five feedbacks
Table 5: User five feedback question table
S.no. Feedback question User one
1 Is the website adding cart function? Yes
2 Is the website user-friendly? No
3 Is the website providing the product list and categories? No
Recommendation Laptop4U website:
Here, I have defined the Recommendation for Laptop4U website that improves the website quality
such as
There is needed to improve the GUI of the website and also work the website navigation
process.
There will be needed to improve the payment gateway of the Laptop4U website. The user
does not feel safe with a current payment gateway.
There will be needed to improve the product quality and quantity according to the user
reviews and requirement.
There will be implemented the chat-boat which provide the direct communication with
website customer through the chatting process. It is also user feedback.
There will be implemented the social media linking on the website which improved the market
value of the website.
3 Is the website providing the product list and categories? No
Recommendation Laptop4U website:
Here, I have defined the Recommendation for Laptop4U website that improves the website quality
such as
There is needed to improve the GUI of the website and also work the website navigation
process.
There will be needed to improve the payment gateway of the Laptop4U website. The user
does not feel safe with a current payment gateway.
There will be needed to improve the product quality and quantity according to the user
reviews and requirement.
There will be implemented the chat-boat which provide the direct communication with
website customer through the chatting process. It is also user feedback.
There will be implemented the social media linking on the website which improved the market
value of the website.
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
4.4 create user documentation for a developed web application.
User documentation: it is a documented process that is created for the system, device, software, and
application to user guides. It contained an image and writing part. Documentation contained image
for human interfaced. User documentation designed by the software developer, Supervisor, Service
desk operator, System administrator and Data entry clerk. It contained a number of advantage such
as
User document saves time and effort of the user to understand the website.
It helps to improve the market value of the organization and their service.
It works as an info collector that gathered the data or fact from various source.
Here, I have created the user documentation for website different pages that help the user to
understand the working easily.
Figure 36: Homepage
Figure 37: Dell product
User documentation: it is a documented process that is created for the system, device, software, and
application to user guides. It contained an image and writing part. Documentation contained image
for human interfaced. User documentation designed by the software developer, Supervisor, Service
desk operator, System administrator and Data entry clerk. It contained a number of advantage such
as
User document saves time and effort of the user to understand the website.
It helps to improve the market value of the organization and their service.
It works as an info collector that gathered the data or fact from various source.
Here, I have created the user documentation for website different pages that help the user to
understand the working easily.
Figure 36: Homepage
Figure 37: Dell product
Figure 38: MAC product
Figure 39: sony product
Figure 40: Add product
Figure 39: sony product
Figure 40: Add product
Figure 41: Admin login page
Figure 42: customer login
Figure 43: customer sing up page
Figure 42: customer login
Figure 43: customer sing up page
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Figure 44: new brand product
Conclusion
This report concludes that the web-based application is developed for the laptop company by
keeping all the requirements on priority. It produces effective results which determined all the
server side and client side scripting languages along with their advantages and disadvantages. It
helps to identify the weaknesses and strengths of web application and how can maintain its
security to improve the overall performance of the system. The user documentation gives an
idea of the whole application which is designed for e-commerce business of laptops. It also
describes various web security issues with their recommendations to improve in future aspect.
This report also provides 3 tier schema to understand how the client interacts with the server
side through the internet. The database is also the main part in this which keeps information and
provide to the user whenever it is required. The web designs and use case diagrams to help the
developer to develop a web application for the laptop company on behalf of screen designs.
Hence, the report fulfills user requirements with a detailed explanation to understand properly.
This report concludes that the web-based application is developed for the laptop company by
keeping all the requirements on priority. It produces effective results which determined all the
server side and client side scripting languages along with their advantages and disadvantages. It
helps to identify the weaknesses and strengths of web application and how can maintain its
security to improve the overall performance of the system. The user documentation gives an
idea of the whole application which is designed for e-commerce business of laptops. It also
describes various web security issues with their recommendations to improve in future aspect.
This report also provides 3 tier schema to understand how the client interacts with the server
side through the internet. The database is also the main part in this which keeps information and
provide to the user whenever it is required. The web designs and use case diagrams to help the
developer to develop a web application for the laptop company on behalf of screen designs.
Hence, the report fulfills user requirements with a detailed explanation to understand properly.
References
Meier, J.D., Microsoft Corp, 2010. Web application security frame. U.S. Patent
7,818,788.
Fitz-Rodríguez, E., Kubota, C., Giacomelli, G.A., Tignor, M.E., Wilson, S.B. and
McMahon, M., 2010. Dynamic modeling and simulation of greenhouse environments
under several scenarios: A web-based application. Computers and electronics in
agriculture, 70(1), pp.105-116.
Korte, A. and Farlow, A., 2013. The advantages and limitations of trait analysis with
GWAS: a review. Plant methods, 9(1), p.29.
Proctor, I.A.R., Yang, M. and Zhao, H., Facebook Inc, 2014. Executing server side
script code specified using PHP on a server to generate dynamic web pages. U.S. Patent
8,707,161.
Kirda, E., Jovanovic, N., Kruegel, C. and Vigna, G., 2009. Client-side cross-site
scripting protection. computers & security, 28(7), pp.592-604.
Lopes, C.T., Franz, M., Kazi, F., Donaldson, S.L., Morris, Q. and Bader, G.D., 2010.
Cytoscape Web: an interactive web-based network browser. Bioinformatics, 26(18),
pp.2347-2348.
Shinn, M.R. and Walker, H.M. eds., 2010. Interventions for achievement and behavior
problems in a three-tier model including RTI. National Association of School
Psychologists.
Al-Masree, H.K., 2015. Extracting Entity Relationship Diagram (ERD) from relational
database schema. International Journal of Database Theory and Application, 8(3),
pp.15-26.
Swain, S.K., Mohapatra, D.P. and Mall, R., 2010. Test case generation based on use
case and sequence diagram. International Journal of Software Engineering, 3(2),
pp.21-52.
Elmasri, R. and Navathe, S., 2010. Fundamentals of database systems. Addison-
Wesley Publishing Company.
Carmichael, R.D., Intel Corp, 2009. Mechanism for error handling of corrupted
repeating primitives during frame reception. U.S. Patent 7,619,984.
Meier, J.D., Microsoft Corp, 2010. Web application security frame. U.S. Patent
7,818,788.
Fitz-Rodríguez, E., Kubota, C., Giacomelli, G.A., Tignor, M.E., Wilson, S.B. and
McMahon, M., 2010. Dynamic modeling and simulation of greenhouse environments
under several scenarios: A web-based application. Computers and electronics in
agriculture, 70(1), pp.105-116.
Korte, A. and Farlow, A., 2013. The advantages and limitations of trait analysis with
GWAS: a review. Plant methods, 9(1), p.29.
Proctor, I.A.R., Yang, M. and Zhao, H., Facebook Inc, 2014. Executing server side
script code specified using PHP on a server to generate dynamic web pages. U.S. Patent
8,707,161.
Kirda, E., Jovanovic, N., Kruegel, C. and Vigna, G., 2009. Client-side cross-site
scripting protection. computers & security, 28(7), pp.592-604.
Lopes, C.T., Franz, M., Kazi, F., Donaldson, S.L., Morris, Q. and Bader, G.D., 2010.
Cytoscape Web: an interactive web-based network browser. Bioinformatics, 26(18),
pp.2347-2348.
Shinn, M.R. and Walker, H.M. eds., 2010. Interventions for achievement and behavior
problems in a three-tier model including RTI. National Association of School
Psychologists.
Al-Masree, H.K., 2015. Extracting Entity Relationship Diagram (ERD) from relational
database schema. International Journal of Database Theory and Application, 8(3),
pp.15-26.
Swain, S.K., Mohapatra, D.P. and Mall, R., 2010. Test case generation based on use
case and sequence diagram. International Journal of Software Engineering, 3(2),
pp.21-52.
Elmasri, R. and Navathe, S., 2010. Fundamentals of database systems. Addison-
Wesley Publishing Company.
Carmichael, R.D., Intel Corp, 2009. Mechanism for error handling of corrupted
repeating primitives during frame reception. U.S. Patent 7,619,984.
1 out of 40
Related Documents
Your All-in-One AI-Powered Toolkit for Academic Success.
+13062052269
info@desklib.com
Available 24*7 on WhatsApp / Email
![[object Object]](/_next/static/media/star-bottom.7253800d.svg)
Unlock your academic potential
© 2024 | Zucol Services PVT LTD | All rights reserved.