FINAL Report in Online Grocery Store
FINAL Report in Online Grocery Store
FINAL Report in Online Grocery Store
Submitted to,
Department of Information Technology
U.V. Patel College of Engineering
Ganpat University, Kherva (384 012)
U.V. PATEL COLLEGE
OF
ENGINEERING
28/11/2022
CERTIFICATE
28/11/2022
CERTIFICATE
This Capstone project becomes a reality with the kind support and help of many individuals.
We would like to extend our sincere gratitude and appreciation for all the hard work and
dedication they have given us.
To our Guide Mr. Ritesh Upadhyay, whose valuable guidance has been the ones that helped
us patch this project and make it successful, her suggestions and his instructions has served as
the major contributor towards the completion of the project.
To our families who have helped us with their valuable suggestions and ideas has been helpful
in various phases of the completion of the project.
To our friends and classmates who we have shared our work for the whole session of
completing this project. We are grateful for the constructive cooperation we have had and for
the willingness to compromise that has been show for the purpose of producing a good project.
Thank you for the entire laugh and every stressful day that brighten up our day.
1
ABSTRACT
2
Contents
Acknowledgement ..................................................................................................................... 1
Abstract ...................................................................................................................................... 2
1 Introduction ........................................................................................................................ 7
1.1 Problem Statement ...................................................................................................... 7
1.2 Purpose ........................................................................................................................ 7
1.3 Objective ..................................................................................................................... 8
1.4 Overview ..................................................................................................................... 8
1.5 Scope ........................................................................................................................... 9
1.6 Tools & Technology.................................................................................................... 9
2 Feasibility Study .............................................................................................................. 10
2.1 Operational Feasibility .............................................................................................. 10
2.2 Technical Feasibility ................................................................................................. 10
2.3 Financial Feasibility .................................................................................................. 11
2.4 Economic Feasibility ................................................................................................. 11
2.5 Study of current system ............................................................................................. 11
2.6 Proposed System ....................................................................................................... 12
2.7 Problem and weakness of current system ................................................................. 12
2.8 Feature of new system ............................................................................................... 12
2.9 Literature survey ....................................................................................................... 13
3 Study of the system .......................................................................................................... 14
3.1 Modules ..................................................................................................................... 14
4 Software Requirement Study ........................................................................................... 17
4.1 Product Description ................................................................................................... 17
4.2 User Characteristics .................................................................................................. 17
4.3 Hardware and Software Requirements ...................................................................... 18
4.4 Functional Requirements........................................................................................... 19
4.5 Non-Functional Requirements .................................................................................. 20
4.6 Tools and Technology ............................................................................................... 21
5 System Design ................................................................................................................. 25
5.1 Requirement Analysis ............................................................................................... 25
5.2 System Analysis ........................................................................................................ 26
3
5.3 System Architecture .................................................................................................. 27
5.4 UML Diagram ........................................................................................................... 28
5.5 Data flow Diagram .................................................................................................... 32
6 Database Design............................................................................................................... 36
7 Implementations ............................................................................................................... 38
8 Limitations ....................................................................................................................... 46
9 Testing…………………………………………………………………………………. 47
9.1 Introduction ............................................................................................................... 47
9.2 Level of Testing ........................................................................................................ 47
9.3 Testing Report ........................................................................................................... 48
10 Conclusion ....................................................................................................................... 52
10.1 Future work………………………….…………………………………...……….….52
References ................................................................................................................................ 47
4
List of Figures
Figure 1: System Flowchart ..................................................................................................... 26
Figure 2; System Architecture ................................................................................................. 27
Figure 3; Use Case Diagram .................................................................................................... 28
Figure 4: Class Diagram .......................................................................................................... 29
Figure 5: Activity Diagram ...................................................................................................... 30
Figure 6: Sequence Diagram .................................................................................................... 31
Figure 7: ER Diagram .............................................................................................................. 32
Figure 8: DATA FLOW Diagram (level-0) ............................................................................. 33
Figure 9: DATA FLOW Diagram (level-1) ............................................................................. 34
Figure 10: DATA FLOW Diagram (level-2) ........................................................................... 35
5
List of Tables
Table 1: User Characteristics Table .................................................................................... 17-18
Table 2: Hardware and Software requirement Table ............................................................... 18
Table 3: User login Database Table……………………………………………….………….36
Table 4: Product Details Database table ……………………….…………………………….36
Table 5: Order Details Database Table……………………………………………………….37
Table 6: Cart Details Database table………………………………………………………….37
Table 7: Message/Contact Us Database Table ……………………………………………….37
Table 8: Customer Registration Testing Table ……………………………………………….48
Table 9: Customer Login Testing Table……………………………………………….……..48
Table 10: Admin Login Testing Table……………………………………………………….49
Table 11: Change Password Testing Table…………………………………………………..49
Table 12: Add Product testing Table…………………………………………………...……50
Table 13: Order Testing Table……………………………………………………...………..50
6
1. INTRODUCTION
E-commerce is fast gaining ground as an accepted and used business paradigm. More and more
business houses are implementing web sites providing functionality for performing commercial
transactions over the web. It is reasonable to say that the process of shopping on the web is
becoming commonplace.
The objective of this project is to develop a general-purpose e-commerce store where Grocery
product can be bought from the comfort of home through the Internet. However, for
implementation purposes, this paper will deal with an online shopping for Grocery.
An Online Grocery Store is a virtual store on the Internet where customers can browse the
catalog and select products of interest. The selected items may be collected in a shopping cart.
At checkout time, the items in the shopping cart will be presented as an order. At that time,
more information will be needed to complete the transaction. Usually, the customer will be
asked to fill or select a billing address, a shipping address, a shipping option, and payment
information such as debit/credit card number, UPI etc. An e-mail notification is sent to the
customer as soon as the order is placed.
An Online Grocery Store that will minimize all the effort and time of the customer and to
minimize roaming around as well. Therefore, it allows administrator to track the order of the
customer so that they can prepare for it and deliver if needed. Furthermore, in this study, the
developer shall create the system that is fully computerized, user-friendly, time effective and
well-organized.
1.2 PURPOSE
Online shopping tries to enhance access to care and improve the continuity and efficiency of
services. Depending on the specific setting and locally, case managers are responsible for a
variety of tasks, ranging from linking clients to services to actually providing intensive
shopping and delivery services themselves.
Customers have effortless shopping experience and saving time through shopping online. In
online grocery shopping you can just sit down relax and search for the product while in physical
7
market you have to stand in line at the checkout counter and wait to load all your groceries
packed.
1.3 OBJECTIVE
The objective of this study is to help the consumer of save more to make their ordering more
convenient and easier. For the customer, it can minimize the workload and effort of roaming
around the grocery store. They can search the grocery items that they’re looking for.
The objective of this system is to save time and effort for the consumer. Save time and effort
in terms of driving a car or commuting on a jeepney.
In online grocery shopping you can just sit down relax and search for the product while in
physical market you have to stand in line at the checkout counter and wait to load all your
groceries packed. The proponents proposed an online grocery shopping system to lessen
difficulty to the customer.
Specific Objectives
• To develop an Online Grocery Store
• To make the transaction easier and faster
• The branch manager/administrator can see all the orders to be process
• To display all the updated information
• Customers will choose their products and the corresponding grocery items will
automatically load into their shopping cart.
1.4 OVERVIEW
This system involves its own database to be maintained. As the information or details about
the products are stored in the database (like RDBMS, online databases on a paid basis like
firebase, etc.) for the server-side functionalities. The Server process is for dealing with the
customer’s detail and the items that are shipped to different locations based on the addresses
provided by the customers.
An online grocery store targets at delivering the finest quality grocery things directly to the
doorstep of a consumer at competitive rates.
The application design contains two modules one is for the customers who wish to buy the
products. And another is for the store owners who maintain and updates the information
regarding the products and about the customers. The end-user to use this product are the
common people for whom the website is to be hosted on the web and the admin maintains the
database.
The application that is deployed on the customer’s database like RDBMS, the information
regarding the items is highlighted and forwarded from the database for the customer (front
8
view) based on the choice through the menu list and based on all these searches and transactions
the database of all the products is updated at the end of each transaction.
The entries for products, into the website, can be made through various screens designed for
various levels of users. As soon as, the authorized personnel feeds the relevant data into the
system, several reports are generated based on the security policy used.
1.5 SCOPE
The scope of this work is to design, develop, and test the web website. Some delivery persons
can perform their work. This will be adding on benefit for the customers as it will save their
time, plus it adds on for the shopkeepers also, as people will continue to shop from local shops
rather than preferring to supermarkets every time. Also, since the deliveries from these local
vendors will not be as time-consuming as these days Flipkart, Amazon, etc. take but rather will
be delivered the same day of an order placed. Else the shopkeeper can ask the customer that
the product will be available by the next day, so if he/she still wants to place the order, it can
be done.
• The customer can pay through debit/credit card. UPI and Cash on Delivery.
• Customer can also choose pick-up or delivery
• The customer can easily search for the products and can add immediately to her/his
shopping cart
• The system can print the receipt of the customer’s order
• The system has email validation through Gmail
• Customer can see the order details and the actions done to her/his orders.
• System has its inventory report and sales report.
• The customer can print her/his own receipt
9
2. FEASIBILITY STUDY
After doing the project Online Grocery Store, study and analysing all the existing or required
functionalities of the system, the next task is to do the feasibility study for the project. All
projects are feasible – given unlimited resources and infinite time.
Feasibility study includes consideration of all the possible ways to provide a solution to the
given problem. The proposed solution should satisfy all the user requirements and should be
flexible enough so that future changes can be easily done based on the future upcoming
requirements.
A feasibility study is a high-level capsule version of the entire system analysis and design
process. The study begins by classifying the problem definition. Feasibility is to determine if
it’s worth doing. Once an acceptance problem definition has been generated, the analyst
develops a logical model of the system. A search for alternatives is analysed carefully. There
are 3 parts in feasibility study.
1. Operational Feasibility
2. Technical Feasibility
3. Financial Feasibility
4. Economical Feasibility
10
The system is self-explanting and does not need any entire sophisticated training. A system has
been built by concentrating on the graphical user interface concepts, the website can also be
handled very easily with a novice uses. The overall time that a user needs to get trained is less
than 15 minutes.
Since no special hardware is required for the system the direct or indirect cost required for the
development and the deployment of the project is reduced. As our project consists of a web
website it does not require any financial help. We will only need a web domain and nothing
else. Hence, our project is financially very feasible.
In our website, it is built for the all the people. It is freely available to utilized. This website
doesn’t have any monetary service to take the charges according to the usage, any user can
access this website in freely. Every user can access this website.
It refers to the benefits or outcomes we are deriving from the product as compared to the total
cost we are spending for developing the benefits are more or less the same as the older system
then it is not feasible to develop the product. The product is economical feasible.
The cost centres in the system development as well as operation are trivial. The major can be
network, internet and the software required for coding. The software used for the development
of the proposed system is PHP and MySQL.
As mentioned above, there have been some systems in the market to give groceries at the
doorstep. Some examples of such systems are Big Basket and Grofers. The above-mentioned
Online Grocery Stores have gained a lot of success in metro cities like Mumbai, Pune, Chennai,
Bangalore, Noida, Ahmedabad, etc. But as we said earlier, they were unable to gain success in
non-metropolitan cities. Another aspect where these stores fall short is time, the delivery times
of these stores are long. In the case of Big Basket, they only have three-timeslots for delivery
in a day, which doesn’t fulfil the fast delivery feature. In the case of above-mentioned stores,
they take the order from customers at any time of the day but deliver the order in Any one of
the three time slots. In non-metro cities also there is a requirement for a system, which can
probably ease the life of people and also to reduce the wastage of time.
11
2.6 PROPOSED SYSTEM
As we know that grocery is an important part of our daily life. All human beings, may it be a
college student, a bachelor staying away from home due to a job or even the local people in a
city or town of them need groceries. If we think about ourselves as well as others and ask a
simple question: “Would you like to get the grocery while sitting at home rather than wandering
outside in search of grocery. Shops and good quality products?” What would be your answer,
in most cases the answer would be a big “YES”. So, our project is to develop and design an
Online Grocery Store that will provide the grocery of good quality at the doorstep to the
customers within the specified time. This store will provide services in most the cities including
nonmetro cities. The working of this Online Store will be completely based on the local vendors
of the city, unlike the existing systems, which provide groceries directly from the
manufacturers. The involvement of local vendors adds up to the advantages of this system
likewise: If local vendors are involved then it assures the quality of the product. And secondly,
as the vendors are of the same locality as the customer, it makes the delivery of products
ductless and time-consuming. Hence, felicitating fast delivery feature.
12
2.9 LITERATURE SURVEY
The objective of this study is to investigate the factors affecting online shopping. A model
explaining the impact of different factors on online shopping intentions and behaviour is
developed based on the theory of planned behaviour. The model is then tested empirically in a
longitudinal study with two surveys. Data collected indicate that subjective norms, attitude,
and beliefs concerning the consequences of online shopping have significant effects on
consumers' intentions to buy online. Behavioural control and intentions significantly
influenced online shopping behaviour.
American online retail giant Amazon.com has made an entry into the Indian market
withJunglee.com, an online shopping site powered by the $ 48 billion company. The site which
went live on Thursday morning says that it’s an online shopping service by Amazon "which
enables customers to find and discover products from online and offline retailers in India and
from Amazon.com”. (Jayadevan P K), 2012.
It's a net gain for the virtual world. Riding high on the increasing interest of the net savvy
people, online shopping portals are witnessing a whopping 200% growth in the sale of
electronic items every year. "Since electronic gadgets such as cell phones and iPods usually
involve an individual choice compared to products catering to the needs of the entire family.
(Pramugdha Mamgain), 2007.
13
3. STUDY OF THE SYSTEM
3.1 MODULES
The system after careful analysis has been identified to be presented with the following
modules and roles.
ADMINISTRATOR:
The administrator is the super user of this application. Only admin have access into this admin
page/panel. Admin may be the owner of the store. The administrator has all the information
about all the users and about all products.
Manage Users:
1. View Users:
The admin will have a list view of all the users registered in the system. Admin can view
all the details of each user in the list except password.
2. Add Users:
Admin has privileges to add a user directly by providing the details.
Manage Products:
1. Add Products:
The shopping cart project contains different kind of products. The products can be
classified into different categories by name. Admin can add new products into the existing
system with all its details including an image.
2. Delete Products:
Administrator can delete the products based on the stock of that particular product.
14
3. Search Products:
Admin will have a list view of all the existing products. He can also search for a particular
product by name.
Manage Orders:
1. View Order:
Administrator can view the Orders which is generated by the users. He can verify the details
of the purchase.
2. Verify Order:
Admin can verify the order which is generated by the users.
3. Delete Order:
Admin can delete order from the orders list when the product is taken for delivery.
USERS:
1. Registration:
A new user will have to register in the system by providing essential details in order to view
the products in the system. The admin must accept a new user by unblocking him.
2. Login:
A user must login with his user name and password to the system after registration.
3. View Products:
User can view the list of products based on their names after successful login. A detailed
description of a particular product with product name, products details, product image,
price can be viewed by users.
4. Search Product:
Users can search for a particular product in the list by name.
5. Add to cart:
The user can add the desired product into his cart by clicking add to cart option on the
product. He can view his cart by clicking on the cart button. All products added by cart can
be viewed in the cart. User can remove an item from the cart by clicking remove.
6. Submit Cart:
After confirming the items in the cart the user can submit the cart by providing a delivery
address. On successful submitting the cart will become empty.
15
7. History:
In the history the user will have a view of pending orders.
8. Edit Profile:
The user can view and edit the profile.
GUEST USER:
1. View Products:
User can view the list of products based on their names after successful login. A detailed
description of a particular product with product name, products details, product image,
price can be viewed by users.
3. Search Product:
Users can search for a particular product in the list by name.
16
4. SYSTEM REQUIREMENT STUDY
In this chapter, we will learn about the system requirement, specification and functionality.
Online Grocery Store is a computerized, online solution to the various problems faced by the
Product buyer and seller wishing to outsource their software development work to a Provider
at an economical cost, thus achieving high performance, accuracy, reliability and high speed
of data retrieval.
In this system, there is a registration process each for the Product buyer. The Administrator of
the site verifies the Provider after his registration and if satisfied, assigns him a user name and
password.
Our site can be used by anyone who is searching for Products whether he/she is first time
visiting our site. Our site also provides some discounted Products as same u get on any shop.
The software covers the following point while keeping in mind user’s requirement-:
• ADMINISTRATOR
• USERS
• GUEST USER
• Manage Users
Administrator • Manage Products
• Manage Orders
17
• Registration
• Login
• View Products
Users
• Search Products
• Add to cart
• Submit Cart
• Edit Profile
• View Products
Guest Users • Guest user can enquiry
• Search Product
Hardware Requirements:
• Computer/Laptop
• With Minimum RAM of 4 GB
• External Hard Drive 512 GB for
Backup.
• Internet Connectivity required.
• Mouse and Keyboard
18
4.4 FUNCTIONAL REQUIREMENT
Functional requirements define what a software system should do. It defines a function of a
software system or its module. Functionality is measured as a set of inputs to the system under
test to the output from the system.
Functional requirements could include the following components that can be measured
as part of functional testing:
1. INTEROPERABILITY:
Interoperability Requirements describe that how easily a system can share and exchange
data and information with
1. Other systems
2. Other external hardware and devices
3. Other Software
4. Other websites
Requirement describes a software system is interoperable across different systems. So,
interoperability checks whether communication between the two different devices is
possible or not.
By using Interoperability user can interact with administrator and administrator can interact
with user and details or information of products, users and order are exchanged efficiently.
2. SECURITY:
The functional requirement describes the security aspect of software requirements. Security
requirements can be formulated on different abstraction levels. At the highest abstraction
level, they basically just reflect security objectives. "The system must maintain the
confidentially of all data that is classified as confidential". This is Online Grocery Store
website, all logged information, user data, order updates, user activities are securely stored.
3. ACCURACY:
Accuracy defines a data entered into the system is correctly calculated and used by the
system and that the output is correct. The accuracy of information is often regarded as an
inherent property of any automated information system. The accuracy of user data,
products, order update are present in website.
4. COMPLIANCE:
Compliance functional requirements validate that the developed system is compliant to
Industrial standards. The Online Grocery Store are made according to Industrial Standard.
6. AUTHENTICATION FUNCTIONS
19
They concern the information users share with the system and their authentication level.
These functions determine various system access levels and decide who can CRUD
(change, read, update, or delete) information.
1. PERFORMANCE:
A performance attribute type of non-functional requirement measures system performance.
that system performance measurement is different from load measurement. During load
testing, we load the system CPU and RAM and check the system throughput. In the case
of performance, we test system throughput in normal load/stress conditions.
2. USABILITY:
Usability measures the usability of the software system being developed.
3. MAINTAINABILITY:
Maintainability of a software system is the ease with which the system can be maintained.
Maintainability is often measured at code level using Cyclomatic complexity. Cyclomatic
complexity says that the lesser complex the code is, the easier it is to maintain the software.
4. RELIABILITY:
Reliability is another aspect of availability. This quality attribute emphasizes the
availability of a system under certain conditions. It is measured as Mean Time Between
Failures (MTBF) just like maintainability.
5. PORTABILITY:
Portability means the ability of a software system to work in a different environment if the
underlying dependent framework stays the same.
6. SUPPORTABILITY:
Serviceability of a software system is the ability of a service/technical expert to install the
software system in a real-time environment, monitor the system while it is running,
identify any technical issues in the system and provide a solution to resolve the issue.
Service ability is possible if the system is developed to facilitate serviceability.
7. ADAPTABILITY:
The adaptability of a system is defined as the ability of a software system to adapt to change
in an environment without any change in its behaviour.
20
4.6 TOOLS AND TECHNOLOGY USED
This website Development is possible with a couple of software and development kits to support
the software and execution, they are as follows,
JAVASCRIPT
JAVASCRIPT is a dynamic computer programming language. It is most commonly used as
part of web browsers, whose implementations allow client-side scripts to interact with the user,
control the browser, communicate asynchronously, and alter the document content that is
displayed. Java Script is used to create popup windows displaying different alerts in the system
like “User registered successfully”, “Product added to cart” etc.
BOOTSTRAP FRAMWORK
Bootstrap is an HTML, CSS and JS Library that focuses on simplifying the development of
informative web pages (as opposed to web apps). The primary purpose of adding it to a web
project is to apply Bootstrap's choices of color, size, font and layout to that project. As such,
the primary factor is whether the developers in charge find those choices to their liking. Once
added to a project, Bootstrap provides basic style definitions for all HTML elements. The result
is a uniform appearance for prose, tables and form elements across web browsers. In addition,
developers can take advantage of CSS classes defined in Bootstrap to further customize the
appearance of their contents. For example, Bootstrap has provisioned for light- and dark-
colored tables, page headings, more prominent pull quotes, and text with a highlight.
BACKEND DETAILS
Back-end part of a system is more important because it controls all the internal process of a
system. I have chosen MySQL database as back end. Because it is word’s Most Capable
relational database and provide more security than others.
ABOUT PHP:
PHP: Hypertext Preprocessor is a widely used, general-purpose scripting language that was
originally designed for web development to produce dynamic web pages. For this purpose,
PHP code is embedded into the HTML source document and interpreted by a web server with
a PHP processor module, which generates the web page document. As a general-purpose
programming language, PHP code is processed by an interpreter application in command-line
22
mode performing desired operating system operations and producing program output on its
standard output channel. It may also function as a graphical application. PHP is available as a
processor for most modern web servers and as standalone interpreter on most operating systems
and computing platforms.
PHP stores whole numbers in a platform-dependent range. This range is typically that of 32-
bit signed integers. Unsigned integers are converted to signed values in certain situations; this
behaviour is different from other programming languages. Integer variables can be assigned
using decimal (positive and negative), octal, and hexadecimal notations. Point numbers are also
stored in a platform-specific range. They can be specified using floating point notation, or two
forms of scientific notation. PHP has a native Boolean type that is similar to the native Boolean
types in Java and C++. Using the Boolean type conversion rules, non-zero values are
interpreted as true and zero as false, as in Perl and C++. The null data type represents a variable
that has no value. The only value in the null data type is NULL. Variables of the "resource"
type represent references to resources from external sources. These are typically created by
functions from a particular extension, and can only be processed by functions from the same
extension; examples include file, image, and database resources. Arrays can contain elements
of any type that PHP can handle, including resources, objects, and even other arrays. Order is
preserved in lists of values and in hashes with both keys and values, and the two can be
intermingled. PHP also supports strings, which can be used with single quotes, double quotes,
or heredoc syntax.
Why PHP?
PHP is one of the most popular server-side scripting languages running today. It is used for
creating dynamic Webpages that interact with the user offering customized information. PHP
offers many advantages; it is fast, stable, secure, easy to use and open source (free).
• User friendly
• GUI
• Separation of work (designing & coding)
• Written once run anywhere
• PHP API
Why MySQL?
MySQL is the world's most popular open-source database software, with over 100 million
copies of its software downloaded or distributed throughout its history. With its superior speed,
reliability, and ease of use, MySQL has become the preferred choice for Web, Web 2.0, SaaS,
ISV, Telecom companies and forward-thinking corporate IT Managers because it eliminates
the major problems associated with downtime, maintenance and administration for modern,
online applications.
Many of the world's largest and fastest-growing organizations use MySQL to save time and
money powering their high-volume Web sites, critical business systems, and packaged
software — including industry leaders such as Yahoo!, Alcatel-Lucent, Google, Nokia,
YouTube, Wikipedia, and Booking.com.
23
The flagship MySQL offering is MySQL Enterprise, a comprehensive set of production-tested
software, proactive monitoring tools, and premium support services available in an affordable
annual subscription.
MySQL is a key part of WAMP (Window, Apache, MySQL, PHP), the fast-growing open-
source enterprise software stack. More and more companies are using WAMP as an alternative
to expensive proprietary software stacks because of its lower cost and freedom from platform
lock-in.
XAMPP Server
XAMPP is an open-source software developed by Apache Friends. XAMPP software package
contains Apache distributions for Apache server, MariaDB, PHP, and Perl. And it is basically
local host or a local server. This local server works on your own desktop or laptop computer.
The use of XAMPP is to test the clients or your website before uploading it to the remote web
server. This XAMPP server software gives you a suitable environment for testing MYSQL,
PHP, Apache, and Perl projects on the local computer.
The full form of XAMPP is X stands for Cross-platform, (A) Apache server, (M) MariaDB,
(P) PHP, and (P) Perl. The Cross-platform usually means that it can run on any computer with
any operating system.
24
5. SYSTEM DESIGN
System design is the solution for the creation of a new system. This phase focuses on the
detailed implementation of the feasible system. It emphasis on translating design.
Specifications to performance specification. System design has two phases of development
• Logical design
• Physical design
• It is user- friendly and easy to use for both consumers and vendors.
• The consumers are allowed to give feedbacks about any item.
• The consumers are also allowed to modify their carts individually. They can
add/remove grocery item.
• The vendors are allowed to add new items in respective categories.
• The vendors are allowed to promote new arrivals.
• The consumers can view their order history and details.
25
5.2 SYSTEM ANALYSIS
The main components of this system are registration, login, browsing of items, ordering and
view history and order details. The users have to register themselves then only they will be able
to buy goods. The registered members have to login first in order to purchase the goods. After
that, the users(consumers) need to select the required goods and add it to the cart. At checkout,
they have to pay the amount. The order details and history of ordered items can be viewed as
well by the consumers.
26
5.3 SYSTEM ARCHITECTURE
The system architecture consists of three major parts namely Graphical User Interface (GUI),
front end and back end. The architecture displays the basic process flow.
GUI is the interface visible to the user/customer. A GUI allows the use of icons or other visual
indicators to interact with electronic devices; rather than using only text via the command line.
It will display the different categories of grocery items, sign in, register etc.
PHP &XAMPP server are used as front-end technologies. When user clicks on the particular
product, the query goes to the front-end part. After that front end fetches the required data from
the database i.e. Back end. The results are returned to front end and from there, to GUI for
displaying as shown in fig.
There is a database in the back end. It contains all the information regarding customers,
products and vendors. Here, MySQL is used for this purpose. When user fires a particular
query, the query is given to database and the corresponding result is segregated from large
volume of information. Database is also used for retrieving the history of past orders.
27
5.4 UML DIAGRAM
28
CLASS DIAGRAM
29
ACTIVITY DIAGRAM
30
SEQUENCE DIAGRAM
31
ER DIAGRAM
Fig 7: ER Diagram
32
5.5 DATA FLOW DIAGRAM (DFD)
A thorough explanation is provided for the example data flow diagram for online shopping
system. This example emphasizes the three DFD levels (DFD Levels 0, 1, and 2).
The context diagram is an alternative name for the Level 0 DFD Diagram for Online Shopping
System. Users, the main process, and data flow make up its parts. Also, the project concept is
demonstrated using the single process visualization.
DFD Level 0 shows the entities that interact with a system and defines the border between the
system and its environment. This diagram also depicts the online shopping system at a high
level.
The illustration presents the main process in a single node to introduce the project context. This
context explains how the project works in just one look. The user feeds data into the system
and then receives the output from it.
33
DFD Level 1 Online Shopping System
The "detonated view" of the context diagram is Online Grocery Store DFD Level 1. Its function
is to deepen the concept derive from the context diagram.
Specifically, level 1 shows the broader details of Online Shopping System DFD Level 0. This
is to clarify the paths (flow) of data and its transformation from input to output.
The designed diagram portrays four different scenarios: customer information management,
order, product management, and transaction and payments management.
Firstly, the flow of data starts from the restaurant admin or owners and customers. Then the
system caters to the transaction. This idea was based on online shopping processes or
transactions.
34
DFD Level 1 Online Shopping System
Level 2 DFD for Online Grocery Store is also the highest abstraction of the data flow diagram.
This level also broadens the idea from the DFD level 1. It includes the sub-processes from level
1 as well as the data that flows.
35
6. DATABASE DESIGN
A database design is a collection of stored data organized in such a way that the data
requirements are satisfied by the database. The general objective is to make information access
easy, quick, inexpensive and flexible for the user. There are also some specific objectives like
controlled redundancy from failure, privacy, security and performance. A collection of relative
records makes up a table. To design and store data to the needed forms database 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 a technique to avoid redundancy in the tables.
PRODUCT TABLE:
36
ORDER TABLE:
37
7. IMPLEMENTATION
Implementation is the stage in the project where the theoretical design is turned into the
working system and is giving confidence to the new system for the users i.e., will work
efficiently and effectively. It involves careful planning, investigation of the current system and
its constraints on implementation, design of method to achieve the changeover, an evaluation,
of change over methods. A part from planning major task of preparing the implementation is
education of users. The more complex system is implemented, the more involved will be the
system analysis and design effort required just for implementation. The implementation
process begins with preparing a plan for the implementation for the system. According to this
plan, the activities are to be carried out; discussions may regarding the equipment have to be
acquired to implement the new system.
Implementation is the final and important phase. The most critical stage is in achieving a
successful new system and in giving the users confidence that the new system will work and
be effective. The system can be implemented only after thorough testing is done and if it found
to working according to the specification. This method also offers the greatest security since
the old system can take over if the errors are found or inability to handle certain types of
transaction while using the new system.
At the beginning of the development phase a preliminary implementation plan is created to
schedule and manage the many different activities that must be integrated into plan. The
implementation plan is updated throughout the Development phase, culminating in a
changeover plan for the operation phase. The major elements of implementation plan are test
plan, training plan, equipment installation plan, and a conversion plan.
38
LOGIN PAGE: Existing user can login here
HOME PAGE: The home screen will consist of screen were one can browse through the
products which we have on our website
39
PRODUCT/SHOP PAGE: The page which show all the products which have on our
website
ABOUT US PAGE: The page which describe about website and owners
40
CONTACT US PAGE: Visitors and Registered user can contact website owners and
administrator from here
ADD TO CART PAGE: The page which shows the products added to the cart.
41
PLACE ORDER PAGE: The page when we write delivery information.
42
EDIT PROFILE PAGE: We can edit our profile from here.
43
ADMIN HOME PAGE: The page from where admin can manage users, products, orders.
ADD NEW PRODUCT PAGE: The page from where admin can add new products.
44
ADMIN PLACED ORDER VIEW PAGE: The page from where admin can see
placed order.
ADMIN USER ACCOUNT PAGE: The page from where user can see all the user
account.
45
8. LIMITATIONS
Although I have tried to do the best and try to do all the things that are possible in an Online
System, but still the system contains some of the limitations. The reason of these limitations is
the time constraints. Time is the major problem. I Have to deliver the project in a particular
time period. That’s way I have to leave Some of the topics that actually I want to cover, I am
still working on this software and my next goal is to remove these limitations and develop a
more efficient and elegant system.
• This project does not give the information about the stock (quantity) present within the
shop.
• This project does not create monthly, yearly Reports.
• After removing these and other minor limitations I hope this project will very efficient
and effective.
46
9. TESTING
9.1 INTRODUCTION
Testing is the major quality control measure used during software development. It is a basic
function to detect errors in the software. During the requirement analysis and design the output
of the document that is usually textual and non-executable after the coding phase the computer
programs are available that can be executed for testing purpose. This implies that testing not
only has to uncover errors introduce during the previous phase. The goal of testing is to uncover
requirement, design, coding errors in the program.
Testing determines whether the system appears to be working according to the specifications.
It is the phase where we try to break the system and we test the system with real case scenarios
at a point.
1. Unit Testing:
The unit testing of the source code has to be done for every individual unit of module that was
developing part of the system and some errors were found for every turn and rectified. This
form of testing was use to check for the behaviour signified the working of the system in
different environment as an independent functional unit.
2. Integration Testing:
From the individual parts to the cohesion of each part to make the system as a whole, there is
need to test the working between the assembled modules of the system. The modules are
integrated to makeup the entire system. The testing process is concerned with finding errors
that result from unanticipated interaction between the sub-system and system component. It is
also concerned with validating the system meets its functional and non-functional requirement.
3. System Testing:
The requirement specification document that is the entire system is to be tested to see whether
it meets the requirement or not.
47
9.3 Testing Report:
Customer Registration:
Serial Condition
No. To be Test Data Expected Output Remarks
Tested
If the Email Id is Email Id should not be
1. empty Email Id empty SUCCESSFUL
If the entered
password size is Password should contain
3. Password SUCCESSFUL
less more than 8 characters
than 8
4. If the entered email
Email Id, Entered Login
Id and
Password credentials SUCCESSFUL
password is not not valid
valid
Email Id,
If Email Id and
5. Password Logged in successfully SUCCESSFUL
password is valid
4. If User Image is
User Image Add the User Image SUCCESSFUL
not Add
Customer Login:
Serial Condition
No. To be Test Data Expected Output Remarks
Tested
If the Email Id is Email Id should not be
1. empty Email Id empty SUCCESSFUL
48
Email ID,
If the entered
4. Email ID and Password Logged in successfully SUCCESSFUL
password is valid
Admin Login:
Serial Condition
No. To be Test Data Expected Output Remarks
Tested
If the Email ID is
1. Email ID Kindly enter Email ID SUCCESSFUL
empty
If the password is
2. empty Password Kindly enter password SUCCESSFUL
3.
If the entered Email
You have entered
Email ID,
ID and password is invalid SUCCESSFUL
Password
not valid Login credentials
Email ID,
If the entered Email
4. ID and password is Password Logged in successfully SUCCESSFUL
valid
Change Password:
Serial ConditionTo
No. be Tested Test Data Expected Output Remarks
49
If confirm password Confirm
Failed to change
6. is incorrect Password SUCCESSFUL
password
Add Product:
Condition
Serial No. To be Test Data Expected Output Remarks
Tested
If Product name is
1. not Written Product Name Please Enter the Name SUCCESSFUL
3.
If Category is not Product Please Select the
SUCCESSFUL
Selected category Category
4. If Product Image
Product Image Add the Product Image SUCCESSFUL
is not Add
If Product Details
5. is not written Product Detail Add the Product Details SUCCESSFUL
Order:
Condition
Serial No. To be Test Data Expected Output Remarks
Tested
If User name is
1. not Written User Name Please Enter the Name SUCCESSFUL
50
4. If Address is not Please Enter the
Product Image SUCCESSFUL
written Address
51
10. CONCLUSION
Online shopping is becoming more popular day by day with the increase in the usage of World
Wide Web, Understanding customer’s need for online selling has become challenge for
marketers. Specially understanding the consumer’s attitudes towards online shopping, making
improvement in the factors that influence consumers to shop online and working on factors that
affect consumers to shop online will help marketers to gain the competitive edge over others.
After having detail study on Online Shopping one can see a great change in the behaviour of
people in many manners like their attitude, buying pattern. In earlier times people use to do
manual shopping but now as time changed people are becoming busy and due to which
technology has brought a new revolution. From the results we have concluded that the most
influencing and attractive factor among four factors particularly the security concerns are very
important while shopping online. Last but not least after analysing, we have found that low
price, discount, product pricing, and quality of product and information are also considered to
be important factors.
52
REFERENCES
• https://www.w3schools.com/html/
• https://www.w3school.com/css/
• https://www.w3schools.com/php/
• https://www.slideshare.net/ABHISHEKRAWAT63/nigbasket-indias-online-
grocery-store-case-study/
• https://www.digitalvidya.com/
• https://www.thecasesolutions.com/amazonfresh-rekindling-the-online-grocery-
market-3-38827/
• https://aws.amazon.com/solutions/case-studies/big-basket/
53