Ecommerce Website Development Project: QAC020C153A

Desklib provides past papers and solved assignments for students. This project details the creation of an e-commerce website.

WEB DEVELOPMENT
QAC020C153A

Table of Contents
List of Figure...................................................................................................................................2
List of Table.....................................................................................................................................2
Introduction......................................................................................................................................3
Design Documentation....................................................................................................................4
Web Page Design.........................................................................................................................4
Database Design........................................................................................................................10
Development..................................................................................................................................12
Testing & Validation.....................................................................................................................13
Screenshot..................................................................................................................................13
References......................................................................................................................................15
List of Figure
Figure 1: Home Page.......................................................................................................................4
Figure 2: Login & Sign Up..............................................................................................................5
Figure 3: Product Page 1..................................................................................................................6
Figure 4: Product Page 2..................................................................................................................7
Figure 5: Cart Page..........................................................................................................................8
Figure 6: Profile Update Page..........................................................................................................9
Figure 7: Profile Page......................................................................................................................9
Figure 8: Database Design.............................................................................................................10
Figure 9: ERD................................................................................................................................11
Figure 10: Test Case 1...................................................................................................................13
Figure 11: Test Case 2...................................................................................................................14
Figure 12: Test Case 3...................................................................................................................14
List of Table
Table 1: Testing Table...................................................................................................................13

Introduction
This is an ecommerce website which is widely used for the selling & buying products online at
anywhere, anytime and anything. In this assignment, I have created one ecommerce website for
shoes. It is having mainly three categorization inside this, these are boys, girls and kids wear.
With these it is having adding them into cart option & visibility of their product into profile as
well as cart also. For the front end development I have used HTML, CSS & Java Script for
getting better user experience & user interface. For database connectivity named as back end
development I have used PHP as server side scripting language & MySQL database.

Design Documentation
Web Page Design
Home Page
This page is having main front details of website which are having header section at the top used
for navigating from one web page to another web page. After that, it is having some offer on the
website. At second last it is having three categorization for shoes that are boys, girls and kids.
Such that we can see the product. At last it is having footer section which is containing the
information related to organization like about us, contact info and other most visited product list
with their snip shot also.
Figure 1: Home Page

Login & Sign Up
This page is having personal details for authentication & verification for providing the security to
the products & maintaining the secretly. After this, session will checked that it is working
properly or not, however if user is already logged in then it is redirected to home page and if not
then user is already member then login by using credentials like email & password & if not then
please register yourself and use these entered credentials. It is having header section at the top
used for navigating from one web page to another web page and at last footer section which has
information related to company.
Figure 2: Login & Sign Up
Product Page

This page is having the details of products respectively with their different categorization which
are boys, girls and kids. This will provide flexibility for selecting product separately such that we
can easily select the product. It is having header section at the top used for navigating from one
web page to another web page and at last footer section which has information related to
company.
Figure 3: Product Page 1

Figure 4: Product Page 2
Cart Page
This page is having the details of products which are added into cart or selected by user. These
information is containing the product id, product name with price of product. And, you can
remove the product from cart if you want. It is having header section at the top used for

navigating from one web page to another web page and at last footer section which has
information related to company.
Figure 5: Cart Page
Profile Page
This page is having all the information related to user like their name, password, email id, mobile
number and other data which are inserted at the time of registration. Here, it is having the other
functionality of changing or updating the information related to user respectively.

Figure 6: Profile Update Page
Figure 7: Profile Page

Database Design
For this I have used database named as ecomm using MySQL database, by the table having name
as cart, category, details, product, query, sales and users.
Figure 8: Database Design
Here, below is ERD diagram which is explaining that users table is connected with cart & sales
table via foreign key and product is connected with category & sales table is connected with
details table with the help of foreign key or referential integrity constraint.

Figure 9: ERD

Development
Here, for the development I have used front end development as HTML, CSS & Java Script
language for getting better user experience & user interface. For database connectivity named as
back end development I have used PHP as server side scripting language & MySQL database.
HTML
HTML is standing for the Hyper Text Mark up Language which is a markup language used for
development of the website worked as cross platform for mobile support. It is used for
development & designing of API (Application Programming Interface) for the complex website.
It is also supporting the DOM (Document Object Model) for dealing with the API (Blansit,
2008).
CSS
CSS is standing for the Cascading Style Sheet which is used for designing of the website such
that the website will have the better user interface as well as user interaction with experience and
the website is more presentable with better understanding. It is implemented by three methods
which are inline CSS, written in attribute or property tags of HTML, external CSS, imported in
HTML page and script written in .CSS file extension and internal CSS, script written in <head>
section (Lim, 2015).
Java Script
Java script is he interpreted programming language which high level used for providing or
adding extra featurabiltiy regards the dynamicity. It is also used for providing the network
centric focused to the website.
PHP
PHP is worked as server side scripting language used for providing the dynamicity to the website
following by OOPs concept that is object oriented programming language. It is working on the
all platform like LINUX, UNIX or Windows for getting flexibility. We can embed more than
one page into single page of PHP by using include () or require () function (Raza, 2017) .