Synopsis on

E-Commerce Website
By
Tahir Saifi

BCA III (SEM V - TRACK - I)

Roll No: 2105942158
Academic Year 2021-2024

Guide Name:
M

Project Coordinator:

MCE Society’s
Allana Institute of Management Sciences,
Pune

Submission Date: th December 2023.

 Project Description

Title: E-commerce Website

Brief write-up of project

An E-Commerce website which will allow the merchant to to advertise and sell their
goods on the internet. This will enable the merchant to access the vast user database on
the world wide web

Name of Project/Title:
E-commerce Website

Objectives of Project:
The objective of this project is to create an e-commerce web portal with a content
management system which would allow product information to be updated securely using
a mobile device.
The web portal will have an online interface in the form of an e-commerce website that
will allow users to buy goods from the merchants.

The e-commerce portal will have the following key features:

● An online shop that will allow online shoppers to buy wares from formal and
informal merchants.
● A search engine on the website to allow customers to find specific types of
merchandise.
● A secure online transaction system that will allow shoppers to purchase goods
safely using their credit cards.
● A database of merchandise with photos, product descriptions and stock
information. This database will also contain all relevant merchant and customer
information.
● A data security system that will ensure that all data that is transmitted between the
various system
Number of modules and their names with brief
description

This project will be divided into following separate components:

● The content management system (CMS)
● The e-commerce website/portal
● The product, merchant and customer database
● Reporting of the sales, orders, shipments etc
● The online transaction security system
● The data security system

Scope and functionality of each module

1.1 Content Management System (CMS)
The CMS will be responsible for managing the product, merchant and customer database
(MySQL). The CMS will also handle any changes that must be made to the database as a
result of
transactions on the e-commerce website. This information would be processed and the
database would be updated accordingly using SQL queries.

1.2 The E-Commerce Website/Portal

The e-commerce website/portal will provide merchants with a medium through which
they will be able to sell their merchandise. It will provide online shoppers with an
interface through which they will be able to purchase merchandise from formal and
informal merchants. This e-commerce website component will be written in PHP with
Laravel, which is a very popular and versatile e-commerce programming language. The
website will provide shoppers with information about the various products that are for
sale. The information will include prices, product descriptions, stock availability as well
as photographs of the products.

1.3 Product, Merchant and Customer Database

The product, merchant and customer database will store all information about the products
that will be sold on the e-commerce portal (prices, product descriptions, photos of
products). It will also store merchant information (names, banking details, contact details)
as well as customer details (credit card information, shipping address). This database will
use the MySQL architecture and will be manipulated using SQL queries via the content
management system.

1.4 Report Module:-

This module generates various reports to higher authorities of the system. As weknow that
this system has additional functionality to act as a important for thewebsite and also for
which may help in future.
1.5 Online Transaction Module:-
In this module, the customer will payment in different mode like demand draft, orby credit
card. all selected item could be purchased by the customer. And will payment by DD. the
customer demand for the product and payment for that productand after that the customer
will contact with the product tracking module.

1.6 Security Module:-

Security module is concerned with security of the system. As this system is publicwebsite
but it has provided security to the admin module only because this modulecan update
information of the system so to make sure that no any unauthorizeduser could change
information. This module has various mechanisms to check thevalidity of the user.
Database Design:
A database design is a collection of stored data organized in such a way that the
datarequirements are satisfied by the database. The general objective is to make
informationaccess easy, quick, inexpensive and flexible for the user. There are also some
specificobjectives like controlled redundancy from failure, privacy, security and
performance.A collection of relative records make up a table. To design and store data to
the needed formsdatabase tables are prepared. Two essential settings for a database are:

Primary key
•The field that is unique for all the record occurrences.

Foreign key:
•The field used to set relation between tables. Normalization is atechnique to avoid
redundancy in the tables
Testing:

Software testing is the process used to measure the qualityof developed computer
software. Usually, quality is constrained to such topics as correctness, completeness,
security, but canalso include more technical requirements as described under the
ISOstandard ISO 9126, suchas capability,reliability, efficiency, portability,
maintainability, compatibility, and usability. Testing is a process of technical
investigation, performed on behalf of stakeholders, that isintended to reveal quality-
related information about the product with respect to the context inwhich it is intended to
operate.

5.3.1 Black box testing: It treats the software as a black-box without any understanding
as to how the internals behave. Thus, the tester inputs data and only sees the output from
the test object. Thislevel of testing usually requires thorough test cases to be provided to
the tester whothen can simply verify that for a given input, the output value (or behavior),
is thesame as the expected value specified in the test case.

5.3.2 White box testing: It is when the tester has access to the internal data structures,
code, and algorithms.For this reason, unit testingand debugging can be classified as white-
box testing and it usually requires writing code, or at a minimum, stepping through it, and
thusrequires more skill than the black-box tester. If the software in test is an interface
orAPI of any sort, white-box testing is almost always required.

5.3.3 Gray box testing: Grey box testing is the combination of black box and white box
testing. Intention ofthis testing is to find out defects related to bad design or bad
implementation of thesystem.it is used for web application.

5.3.4 Unit Testing: The primary goal of unit testing is to take the smallest piece of
testable software in theapplication, isolate it from the remainder of the code, and
determine whether it behaves exactly as you expect. Each unit is tested separately before
integrating theminto modules to test the interfaces between modules. Unit testing has
proven its valuein that a large percentage of defects are identified during its use.

5.3.5 Integration Testing: Integration testing, also known as integration and testing
(I&T), is a softwaredevelopment process which program units are combined and tested as
groups inmultiple ways. In this context, a unit is defined as the smallest testable part of
anapplication. Integration testing can expose problems with the interfaces among program
components before trouble occurs in real-world program execution.Integration testing is a
component of Extreme Programming (XP), a pragmaticmethod of software development
that takes a meticulous approach to building a product by means of continual testing and
revision.There are two major ways of carrying out an integration test, called the bottom-
upmethod and the top-down method.
Technology to be used:
PHP, Java, Springboot
MySQL
Bootstrap,HTML , CSS ,JavaScript, Jquery

REQUIREMENT SPECIFICATION
Hardware Requirement:-
 Processor: Pentium Processor ISA 32 Family
 Secondary Storage: 80 GB HDD
 ROM: 52X CD ROM Drive
 Floppy Drive: 1.44 FDD
 Memory: 1 GB RAM
 Network Adapter: Ethernet Adapter, Wifi
 Others: 17" Color Monitor, Printer, Scanner, Keyboard, Mouse.

Software Requirement:-
 Platform: Windows
 Operating System: Windows 10
 Framework: ASP.NET Framework 2019, Springboot
 Front-End Tool: HTML with BootStrap
 Back- End Tool: MY SQL 8.0, Java
 Editing Tool: Microsoft FrontPage 2016
 Scripting Tool: Java script, XML (style Sheet (.xsl))
 Server: Internet Information Server: (IIS Server), TomCat

Method of Analysis

Limitations of the proposed system

● INTERNET CONNECTION IS ABSOLUTELY REQUIRED.
● BASIC INTERNET KNOWLEDGE IS REQUIRED.
● USER REGISTRATION IS COMPULSORY FOR PARTICIPATION.
Project Place

Are you doing this project for any Industry/Client? Mention Yes/No

NO!

FUTURE SCOPE OF THE PROJECT

Future Works:
More features will be added into this application. For example, payment methods such
ascredit cards will be available on this online store. The future works also enables users
tocustomize features. Providing personalized inbox to the user. Moreover, object-
orientedapproach will be applied throughout the application.
Conclusion:
The project entitled “Online shopping system” was completed successfully.
 The system has been developed with much care and free of errors and at the same time it
is efficient and lesstime consuming. The purpose of this project was to develop a web
application and an androidapplication for purchasing items from a shop.This project
helped us in gaining valuable information and practical knowledge on severaltopics like
designing web pages using HTML & CSS, usage of responsive templates,designing and
management of database using MySQL. The entire system is secured. Also the project
helped us understanding about the development phases of a project and
softwaredevelopment life cycle. We learned how to test different features of a project.This
project has given us great satisfaction in having designed an application which can
beimplemented to any nearby shops or branded shops selling various kinds of products
bysimple modifications.
 Name Addres Phone
s

Address Online Store

Phone S_id
Name

Email User
Has Supplies Phone

User_id Orde
r
Order_dat Suplie
Give e s
s

Order_i Product_i
d d
Product

Order Details
User_id
Price Product_name
ships
has

Category

Courier

Cat_id Cat_name

Courier_i User_id Address

d