[go: up one dir, main page]

0% found this document useful (0 votes)
115 views43 pages

Final Report Book

The document describes an online grocery shopping system that aims to address the disadvantages of traditional in-person grocery shopping. It allows users to purchase vegetables, fruits, and dairy products online by browsing products on a e-commerce website and having their orders delivered. The system is proposed to provide fresh products, store data efficiently in a database for fast retrieval, and ensure quality by allowing users to check product quality before paying. It is intended to save users' time by eliminating physical trips to shops and adjusts to users' schedules by being available 24/7.

Uploaded by

Ali
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
115 views43 pages

Final Report Book

The document describes an online grocery shopping system that aims to address the disadvantages of traditional in-person grocery shopping. It allows users to purchase vegetables, fruits, and dairy products online by browsing products on a e-commerce website and having their orders delivered. The system is proposed to provide fresh products, store data efficiently in a database for fast retrieval, and ensure quality by allowing users to check product quality before paying. It is intended to save users' time by eliminating physical trips to shops and adjusts to users' schedules by being available 24/7.

Uploaded by

Ali
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 43

1.

INTRODUCTION
1.1 Abstract of project

BOOK AUR COOK is the online process whereby consumers directly buy goods, services etc.
from a seller interactively in real-time without an intermediary service over the internet. In day to
day life, we will need to buy lots of goods or products from a shop. It may be food items,
electronic items, house hold items etc etc. Now a days, it is really hard to get some time to go out
and get them by ourselves due to busy life style or lots of works. In order to solve this, B2C E-
Commerce websites have been started. Using these websites, we can buy goods or products
online just by visiting the website and ordering the item online by making payments online.

This existing system of buying goods has several disadvantages. It requires lots of time to travel
to the particular shop to buy the goods. Since everyone is leading busy life now a days, time
means a lot to everyone. Also there are expenses for travelling from house to shop. More over
the shop from where we would like to buy some thing may not be open 24*7*365. Hence we
have to adjust our time with the shopkeeper’s time or vendor’s time.

In order to overcome these, we have e-commerce solution, i.e one place where we can get all
required goods/products online. The proposed system helps in building a website to buy, sell
products or goods online using internet connection. Purchasing of goods online, user can choose
different products based on categories , online payments , delivery services and hence covering
the disadvantages of the existing system and making the buying easier and helping the vendors to
reach wider market.

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 1


Objective of the Project

The system helps in buying of vegetables, fruits and all dairy products and services online by
choosing the listed products from website(E-Commerce site). We are going to provide solution
of all types of problems related to shopping. After the execution of this project you can enjoy all
your favourite vegetables , fruits and dairy products at your door step. You don’t need to go
anywhere in search of your favourite eatables , you have to just order it from our website and it
will reach to you in an optimum time period. We have tie ups with various farmers who provide
us with fresh fruits and vegetables on daily basis and we also have contract with distributors in
order to provide with best quality dairy products which is our key role.Thus it will also ensure
the quality of your goods and you will pay after checking the quality of items.

Thus in sort, it is the solution to all problems related to vegetables, fruits and dairy products
shopping.

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 2


1.2 Problem With Existing Systemisting System
1. The existing system having limited promises to provide fresh product to the customers
2. Uses manual methods for storing data and processing product information which is a time
taking process.
3. Often this results in wastage of time and miscommunication among the involved parties
4. Using limited area to provide customer services.

Proposed System

1. It provides the application with various controls, provided by system Rich User Interface.

2. The system makes much easier and flexible. It will show the products information in

categorized way .

3. Promises to the customer delivery on or before time slot

4. Having effective cart facility

5. Here data is stored in the database and provide more secured and fast processing method.

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 3


2. FEASIBILITY STUDY

All projects are feasible given unlimited resources and infinite time. Unfortunately the
development of computer-based system in many cases is more likely to be plagued by scarcity of
resources and delivery date. Hence, we have made use the concept of reusability that is what
Object Oriented Programming (OOPS) is all about.

The feasibility report of the project holds the advantages and flexibility of the project. This is
divided into three sections:
 Economical Feasibility
 Technical Feasibility
 Behavioral Feasibility

It is test of system proposal according to its workability, impact on organization, ability to meet
the needs, effective use of resources. During the study, the problem definition is crystallized and
aspects of the problem to be included in this system are determined. The result of the feasibility
study is a formal proposal. If the proposal is accepted, we continue with the project

1. Economic Feasibility
Economic analysis is most frequently used method for evaluating the effectiveness of a
candidate system. More commonly known as cost/benefit analysis, the procedure is to
determine the benefits and savings that are expected from a candidate system and
compare them with costs.

2. Technical Feasibility
Technical feasibility centers on the existing computer system and to what extend it can
support the proposed system. It involves financial considerations to accommodate
technical enhancements. If the budget is a serious constraint, then the project is judged
not feasible.

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 4


3. Behaviour Feasibility
People inherently resist change and computers have been known to facilitate change. An
estimate should be made of how strong a reaction the user staff is likely to have toward
the development computerized system. The computer installations have something to do
with turnover, retraining and changes to employee status.

Proposed System Functionality:-

The proposed system will be designed to support the following features:-


 The proposed system has a user friendly Interface for porting of data to server.
 The proposed system provides the facility to pull the data from the server of the specified
Supply order number and get the respective report.
 The proposed system provides the no replication of data.
 User can get the desired output according to their queries .This is an added advantage.

Resource feasibility

 This involves questions such as how much time is available to build the new system,
when it can be built, whether it interferes with normal business operations, type and
amount of resources required, dependencies.

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 5


3. Software Requirement Specification

PHP is a server-side scripting language designed for web development but also used as a
general-purpose programming language. As of January 2013, PHP was installed on more than
240 million websites (39% of those sampled) and 2.1 million web servers. Originally created by
Rasmus Lerdorf in 1995, the reference implementation of PHP is now produced by The PHP
Group. While PHP originally stood for Personal Home Page, it now stands for PHP: Hypertext
Preprocessor, a recursive backronym.

PHP code is interpreted by a web server with a PHP processor module, which generates the
resulting web page: PHP commands can be embedded directly into an HTML source document
rather than calling an external file to process data. It has also evolved to include a command-line
interface capability and can be used in standalone graphical applications.

PHP is free software released under the PHP License. PHP can be deployed on most web servers
and also as a standalone shell on almost every operating system and platform, free of charge.

Release Supported
Version Notes
date until
8 June Officially called "Personal Home Page Tools (PHP Tools)".
1.0
1995 This is the first use of the name "PHP". ]

1
2.0 November
1997
Development moves from one person to multiple developers.
6 June 20 October
3.0 Zeev Suraski and Andi Gutmans rewrite the base for this
1998 2000
version.
22 May 23 January Added more advanced two-stage parse/execute tag-parsing
4.0
2000 2001 system called the Zend engine.
10
12 March
4.1 December Introduced 'superglobals' ($_GET, $_POST, $_SESSION, etc.) ]

2002
2001
6 Disabled register_globals by default. Data received over the
22 April
4.2 September network is not inserted directly into the global namespace
2002
2002 anymore, closing possible security holes in applications. ]

27
31 March Introduced the command-line interface (CLI), to supplement the
4.3 December
2005 CGI.
2002
4.4 11 July 7 August Fixed a memory corruption bug, which required breaking binary

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 6


compatibility with extensions compiled against PHP version
2005 2008
4.3.x.
5
13 July
5.0 September Zend Engine II with a new object model.
2004
2005
24 Performance improvements with introduction of compiler
24 August
5.1 November variables in re-engineered PHP Engine. Added PHP Data
]

2006
2005 Objects (PDO) as a consistent interface for accessing databases.
2
6 January
5.2 November Enabled the filter extension by default. Native JSON support. ]

2011
2006
Namespace support; late static bindings, Jump label (limited
goto), Native closures, Native PHP archives (phar), garbage
collection for circular references, improved Windows support,
30 June sqlite3, mysqlnd as a replacement for libmysql as underlying
5.3 July 2014 [43]

2009 library for the extensions that work with MySQL, fileinfo as a
replacement for mime_magic for better MIME support, the
Internationalization extension, and deprecation of ereg
extension.
Trait support, short array syntax support. Removed items:
register_globals, safe_mode, allow_call_time_pass_reference,
1 March 1 March session_register(), session_unregister() and
5.4
2012 2015 [44]
session_is_registered(). Built-in web server. Several
[45]

improvements to existing features, performance and reduced


memory requirements.
Support for generators, finally blocks for exceptions handling,
20 June 20 June
5.5 OpCache (based on Zend Optimizer+) bundled in official
2013 2016
distribution. [46]

Constant scalar expressions, variadic functions, argument


3 years unpacking, new exponentiation operator, extensions of the use
5.6 No date set
after release operator, new phpdbg debugger as a SAPI module, and other
smaller improvements
Beginning on June 28, 2011, the PHP Group began following a timeline for when new versions
of PHP will be released. Under this timeline, at least one release should occur every month. Once
per year, a minor release should occur which can include new features. Every minor release
should at least have 2 years of security and bug fixes, followed by at least 1 year of only security
fixes, for a total of a 3 year release process for every minor release. No new features (unless
small and self-contained) will be introduced into a minor release during the 3-year release
process.

HTML:

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 7


HTML or HyperText Markup Language is the standard markup language used to create web
pages.
HTML is written in the form of HTML elements consisting of tags enclosed in angle brackets
(like <html>). HTML tags most commonly come in pairs like <h1> and </h1>, although some
tags represent empty elements and so are unpaired, for example <img>. The first tag in a pair is
the start tag, and the second tag is the end tag (they are also called opening tags and closing
tags).
The purpose of a web browser is to read HTML documents and compose them into visible or
audible web pages. The browser does not display the HTML tags, but uses the tags to interpret
the content of the page. HTML describes the structure of a website semantically along with cues
for presentation, making it a markup language rather than a programming language.
HTML elements form the building blocks of all websites. HTML allows images and objects to
be embedded and can be used to create interactive forms. It provides a means to create structured
documents by denoting structural semantics for text such as headings, paragraphs, lists, links,
quotes and other items. It can embed scripts written in languages such as JavaScript which affect
the behavior of HTML web pages.
Web browsers can also refer to Cascading Style Sheets (CSS) to define the look and layout of
text and other material. The W3C, maintainer of both the HTML and the CSS standards,
encourages the use of CSS over explicit presentational HTML.
HTML versions timeline
November 24, 1995
HTML 2.0 was published as IETF RFC 1866 . Supplemental RFCs added capabilities:
 November 25, 1995: RFC 1867 (form-based file upload)
 May 1996: RFC 1942 (tables)
 August 1996: RFC 1980 (client-side image maps)
 January 1997: RFC 2070 (internationalization)
January 1997
HTML 3.2 was published as a W3C Recommendation. It was the first version developed
and standardized exclusively by the W3C, as the IETF had closed its HTML Working
Group in September 1996.

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 8


Initially code-named "Wilbur", HTML 3.2 dropped math formulas entirely, reconciled
overlap among various proprietary extensions and adopted most of Netscape's visual
markup tags. Netscape's blink element and Microsoft's marquee element were omitted
due to a mutual agreement between the two companies. A markup for mathematical
formulas similar to that in HTML was not standardized until 14 months later in MathML.
December 1997
HTML 4.0 was published as a W3C Recommendation . It offers three variations:
 Strict, in which deprecated elements are forbidden,
 Transitional, in which deprecated elements are allowed,
 Frameset, in which mostly only frame related elements are allowed ;
Initially code-named "Cougar", HTML 4.0 adopted many browser-specific element types
and attributes, but at the same time sought to phase out Netscape's visual markup features
by marking them as deprecated in favor of style sheets. HTML 4 is an SGML application
conforming to ISO 8879 – SGML.
April 1998
HTML 4.0 was reissued with minor edits without incrementing the version number.
December 1999
HTML 4.01 was published as a W3C Recommendation. It offers the same three
variations as HTML 4.0 and its last errata were published May 12, 2001.
May 2000
ISO/IEC 15445:2000 ("ISO HTML", based on HTML 4.01 Strict) was published as an
ISO/IEC international standard. In the ISO this standard falls in the domain of the
ISO/IEC JTC1/SC34 (ISO/IEC Joint Technical Committee 1, Subcommittee 34 –
Document description and processing languages).
As of mid-2008, HTML 4.01 and ISO/IEC 15445:2000 are the most recent versions of
HTML. Development of the parallel, XML-based language XHTML occupied the W3C's
HTML Working Group through the early and mid-2000s.
HTML draft version timeline
October 1991
HTML Tags,an informal CERN document listing 18 HTML tags, was first mentioned in
public.

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 9


June 1992
First informal draft of the HTML DTD, with seven subsequent revisions (July 15, August
6, August 18, November 17, November 19, November 20, November 22)
November 1992
HTML DTD 1.1 (the first with a version number, based on RCS revisions, which start
with 1.1 rather than 1.0), an informal draft
June 1993
Hypertext Markup Languagewas published by the IETF IIIR Working Group as an
Internet-Draft (a rough proposal for a standard). It was replaced by a second version one
month later, followed by six further drafts published by IETF itself that finally led to
HTML 2.0 in RFC1866
November 1993
HTML+ was published by the IETF as an Internet-Draft and was a competing proposal to
the Hypertext Markup Language draft. It expired in May 1994.
April 1995 (authored March 1995)

3.1Identification of Needs

In the world we are growing for globalization day by day with the development in IT resources
and advancement, by using latest technologies every organization wants to beat its competitors
and want to grow. Enterprise Resourceful Planning is the need of today’s organization. Survival
on manual system is difficult so, that’s why organization of the corporate world wants to
computerize their departments. The modules should be complete database driven and interactive
that should provide the proper information about the Placement and Training Organization.

Success of any system depends up to a large extent on how accurately a problem is defined,
thoroughly investigated and properly carried out to the choice of solution. Analysis is the only
phase in which the requirements for the new system are identified. System analysis is a detailed
study of the various operations performed by a system and their relationship within and outside
of the system. The question is: what must be done to solve the problem? One aspect of analysis
is defining the boundaries of the system and determining whether or not a candidate system

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 10


should consider other related system. During analysis data are collected on the available files,
decision points and transactions handled by the parent system. Data flow diagram, interviews,
onsite observations, questionnaires are used as a logical system model and tools to perform the
analysis.

An analyst is responsible for performing following tasks:


Gathered all facts about the present system from the employees.
Studied strength and weakness of the current system.
Determined “what” must be done to solve the problem.
Prepared a functional specifications document.

In order to reduce the time, there is a need for computerized system that cans retrieve data, insert
data, update existing data or delete existing data. These modules are developed wit the aim of
reducing time, reducing manpower, reducing cost so that the records can be easily maintained.
The volume of work and complexity are increasing year by year. This system reduces
complexity and workload.

3.2 Preliminarily Investigation

A request to take assistance from information system can be made for many reasons, but in each
case someone in the organization initiate the request. When the request is made, the first system
activity the preliminary investigation begins. This activity has three parts:
Request clarification
Feasible Study
Request approval
Many requests from employees and users in the organization are not clearly defined. Therefore,
it becomes necessary that project request must be examined and clarified properly before
considering systems investigation.
The feasibility study is carried out by a small group of people who are familiar with information
system techniques, understand the parts of the business or organization that will be involved or
affected by the project, and are skilled in the system analysis and design process.

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 11


3.3 Hardware And Software Requirement Specifications

Software

• Operating System Server : Windows XP or later


• Database Server :MySQL
• Server :XAMPP
• Client : Chrome
• Tools : NetBeans
• User Interface :PHP with Ajax
• Code Behind : PHP

Hardware

• Processor :Intel Pentium or More


• RAM :512 MB RAM
• Hard Disk :PC with 20GB

4. DESIGN

4.1 E-R Diagram:-

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 12


An entity-relationship (ER) diagram is a specialized graphic that illustrates the interrelationships
between entities in a database. ER diagrams often use symbols to represent three different types
of information. Boxes are commonly used to represent entities. Diamonds are normally used to
represent relationships and ovals are used to represent attributes.

Introduction:
Without understanding the relationship between an users with the Forum we cannot build the on-
line test and forum system. The below E-R Diagram illustrates the relationship between an users
and an forum, only then we would be able to design the process that needs to be computerized to
build the system.
The diagram documents the entities and relationships involved in the user information and on-
line test system. It depicts the fundamental relations like recording personnel information, taking
test handling queries.
The E-R Diagram for Forum can be simple as well as complex.

Data Flow Diagramming is a means of representing a system at any level of detail with a
graphic network of symbols showing data flows, data stores, data processes, and data
sources/destination.
The data flow diagram is analogous to a road map. It is a network model of all
possibilities with different detail shown on different hierarchical levels. This processes of
representing different details level is called “leveling” or “partitioning” by some data flow
diagram advocates. Like a road map, there is no starting point or stop point, no time or timing, or
steps to get somewhere. We just know that the data path must exist because at some point it will
be needed. A road map shows all existing or planned roads because the road is needed.

Details that is not shown on the different levels of the data flow diagram such as volumes,
timing, frequency, etc. is shown on supplementary diagrams or in the data dictionary. For
example, data store contents may be shown in the data dictionary.

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 13


Data Flow Diagram (DFD) uses a number of symbols to represent the systems. Data
Flow Diagram also known as ‘Bubble Chart’ is used to clarify system requirements and
identifying the major transformations that will become programs in system design. So it is the
starting point of the design phase that functionally decomposes the requirements specifications
down to the level of details.

E-R Diagram

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 14


4.2 Data Flow Diagram

A Data Flow Diagram (DFD) is a diagram that describes the flow of data and the processes that
change or transform data throughout a system. It’s a structured analysis and design tool that can

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 15


be used for flowcharting in place of, or in association with, information oriented and process
oriented system flowcharts. When analysts prepare the Data Flow Diagram, they specify the user
needs at a level of detail that virtually determines the information flow into and out of the system
and the required data resources. This network is constructed by using a set of symbols that do not
imply a physical implementation. The Data Flow Diagram reviews the current physical system,
prepares input and output specification, specifies the implementation plan etc.

Four basic symbols are used to construct data flow diagrams. They are symbols that represent
data source, data flows, and data transformations and data storage. The points at which data are
transformed are represented by enclosed figures, usually circles, which are called nodes.

Data Flow Diagram Symbols-

Source or destination of data

Data flow

Process

Storage

Steps to Construct Data Flow Diagrams


Four steps are commonly used to construct a DFD:

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 16


 Process should be named and numbered for easy reference. Each name should be
representative of the process.
 The direction of flow is from top to bottom and from left to right.
 When a process is exploded into lower level details they are numbered.
 The names of data stores, sources and destinations are written in capital letters.

Rules for constructing a Data Flow Diagram


 Arrows should not cross each other.
 Squares, Circles and files must bear names.
 Decomposed data flow squares and circles can have same names.
 Choose meaningful names for dataflow.
 Draw all data flows around the outside of the diagram.

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 17


GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 18
DFD – Level 1

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 19


4.3 Module Description

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 20


Administrator
 Owner of the web site.
• Allow to book products and cancel the user request . He should also have rights to accept
the registration of the Govt.
• Publish latest news about the new updated products and services.
• Able to group messages to the registered customer and can provide offers.
• Change the service terms of the specific products.

Authentication
 The User authentication process through a Role Based Authentication
 He will approve the registration of customers.
 He should able to Add / Update the products and its prize.

Customer Registration
 Register to the Web site by providing Profile details which will be accepted by Admin
 These users are authenticated to the website by providing the credentials which they got at
the time of registration.
 Provide effective GUI to make customer enter the required information.

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 21


Add Cart

• Providing a tab to store the product chosen by the customer.


• It also provide the list of chosen product with its total prize.
• Customer can add and delete the selected product from the cart.

Payment

• Here customer can make payment in two ways.


• Cash on delivery
• Online payment facility is there.
• Card payment.
• Effective user interface with details for payment and billing.

Return Policy and Customer Overview

 Here customer can make payment in two ways.


 Cash on delivery
 Online payment facility is there.
 Card payment.

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 22


4.4Database

Normalization Tables:

Admin Table

Admin Registration

Client Detail

Inventory

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 23


Item Details

Shopping Details

Special Offer

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 24


Temp_Item_Details

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 25


4.4 Input-Output form

Home Page

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 26


Sign Up Page

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 27


Login page

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 28


Admin Login Page

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 29


Dairy Products Page

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 30


Vegetable Category Page

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 31


Fruit Category Page

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 32


Insert Product Detail

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 33


Proceed To Check Out

5. Implementations/Technological Environments:

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 34


Once the system was tested, the implementation phase started. A crucial phase in the system
development life cycle is successful implementation of new system design. Implementations
simply mean converting new system design into operation. This is the moment of truth the first
question that strikes in every one’s mind that whether the system will be able to give all the
desires results as expected from system. The implementation phase is concerned with user
training and file conversion.
The term implementation has different meanings, ranging from the conversion of a basic
application to a complete replacement of computer system Implementation is used here to mean
the process of converting a new or revised system design into an operational one. Conversion is
one aspect of implementation. The other aspects are the post implementation review and
software maintenance. There are three types of implementation:
 Implementation of a computer system to replace a manual system
 Implementation of a new computer system to replace an existing one.
 Implementation of a modified application to replace an existing one.

6. Testing

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 35


Preparing Test Plan
Preparing test plan is the first step in the last phase of software development cycle .The test plan
consists of all the activities that had to be done in the software testing phase. This test plan has
been documented using the rational test manager software.

Validation Test Criteria


Software validation is achieved through a series of black box test that demonstrates conformity
with requirements.

Unit Testing
For not doing break the functionality of existing the system, we will test individual use cases
and list down test cases for each of the use case.

Log in

o Identification and Password properly initiated, encrypted, and validated

o MySql injection test

o Checking for uppercase, lowercase, number, special character in ID and password

o Either of ID and password not blank

o Checking for overlapping ID

o Checking for weak passwords

o Not available to minors without permission from parents

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 36


o Checking for e-mail notification about making ID and initiating password

Login and start shopping

o Correctly validated before staring a shopping

o Not possible to check out products which is already in progress

o Displaying list of all available products

o Checking for newest version products place on first page.

o Checking for exact number of products stocks

o Checking for available coupon information

o Checking for visibility about previous history of search

o Checking for system about suggestion for newest version of


Products

Payment
o Certification username and card information for security

o Consumer payment for money in proper order.

o Certification for expiration month and year

o Certification about CVS number

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 37


o Checking the maximum limit of credit card

o Checking for signature

Shipping
o Checking for available address information

o Checking for private information and updated address

o Chargeable or no chargeable for shipping

o Checking for number about comment to deliveryman

o Checking about time for shipment

o Check about comment when the consumer will not be in home

Logout
a. Search history saved properly after logout

b. Checking out information saved in database

c. Customer redirected to the login screen

d. Checking e-mail system about purchasing information

Memory Leaks
Memory leak testing has been done using rational purity software

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 38


Integration testing

We consider the BOOK AUR COOK system as a black box and white box; also check up all of
the parts. Also, we will conduct as following orders; creating test plans, performing code review
of the application modules that integrate the application block, executing the use cases of the
application, performing load testing, performing stress testing, performing globalization testing
and perform security testing.

 System compatible with different web browsers (Google chrome, Fire fox, and IE)
 System compatible with different Operating System (Widows, Linux, and Mac)
 System compatible with 32 bit or 64 bit operation Stress testing
against a large number of customers
 Stress testing against a large number of purchasing in one products Stress testing against
security hazard from hackers

7. Result
The application is working well so far, and it is easy to install and use. However, feature such as
‘Modify Item’ in the Admin side is still not working friendly. It asks users to re-browse the
image and the manual for the item to be modified. This feature will be fixed in the future works.
More designs and decorations should be added to the web pages to make them more attractive.

8. Enhancement

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 39


I will fix bugs if they are found. More features will be added into this application. For example,
payment methods such as Pay Pal or credit cards will be available on this online store. The
future works also enables users to customize features. Moreover, object-oriented approach will
be applied throughout the application.
There are a few items that really stick out when thinking about what could be done in the future to
enhance an application such as this:

 Implement SSL transactions of sales

 Create a robust cluster of administration pages that allow for the creation, editing,
modification and deletion of items, customers, orders, categories and any other applicable
database item.

 Create better user interfaces for checking out, to include payment options, pulldown
boxes, just-in-time credit card verification and purchase confirmation numbers.

 JavaDoc commenting and documentation of the whole application

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 40


9. Limitations

Scope of the proposed System:

The proposed system provides the automated generation of LPP reference that includes the LPP
Rate and the reference date. LPP is used at the time of Worksheet preparation along with the
tender price, which helps to obtain the overall and annual escalation. Escalation is related to the
number of months, calculated by the LPP reference date and the worksheet preparation date of
the particular financial year.
The “Book aur Cook” software is being developed as an accurate and efficient system for the
user. In this system the record of the each request details are preserved along with their
transaction related to them. The system is also made secured as all the updating and transaction
can be done by the authorized person.

Limitation of the Proposed System:

 Data based used is MS SQL Server and database has a limit size.
 Manual Errors at the time of entering the data can’t be check, only the validation required
w.r.t proposed system is checked.

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 41


10.Conclusion

The application can be used for any E-commerce application. It is easy to use, since it uses the
GUI provided in the user dialog. User friendly screens are provided. The application is easy to
use and interactive making online shopping a recreational activity for users. It has been
thoroughly tested and implemented.

The ‘BOOK AUR COOK’ is designed to provide a web based application that would make
searching, viewing and selection of a product easier. The search engine provides an easy and
convenient way to search for products where a user can search for a product interactively and
the search engine would refine the products available based on the user’s input. The user can
then view the complete specification of each product. They can also view the product reviews
and also write their own reviews. Use of Ajax components make the application interactive and
prevent annoying post backs. Its drag and drop feature make it easy to use.

11.Bibliography

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 42


 www.w3school.com
 www.phptoutorial.com
 Wrox PHP 5th Addition
 PHP Complete Reference

GALGOTIA’S COLLEGE OF ENGINEERING AND TECHNOLOGY, GR.NOIDA 43

You might also like