Application of a Successful Agricultural System

A project report submitted in partial fulfillment of the requirements for the

award of the

PG-Diploma

in

BIG-DATA ANALYTICS/ADVANCED COMPUTING

By
Name - Rupin Das
PRN Number- 20026082007

CENTRE FOR DEVELOPMENT OF ADVANCED COMPUTING

(Autonomous Scientific Society of Department of Electronics and Information

Technology, Govt. of India)

Taramani, Chennai Tamilnadu – 600113.

January 2020

Page | 1
 CENTRE FOR DEVELOPMENT OF ADVANCED COMPUTING
(Autonomous Scientific Society of Department of Electronics
and Information Technology, Govt. of India)
Taramani, Chennai Tamilnadu – 600113.

CERTIFICATE
This is to certify that the Project Report entitled “Application of a Successful
Agricultural System” is being submitted by “Name and Number”, in partial fulfillment of
the requirement for the award of the PG Diplomain ADVANCED COMPUTING of CDAC
is a record of bonafide work carried out by he in ACTS Chennai during January 2020.

The results embodied in this project report have not been submitted to any other
institute for the award of diploma.

Page | 2
 DECLARATION

I Dupin Dashereby declare that the project report “Application of a Successful

Agricultural System” done by me in partial fulfillment of the requirement for the award
of the PG Diplomain ADVANCED COMPUTING of CDAC is a record of bonafide
work carried out by me in ACTS Chennai during January 2020.

DATE : 22-01-2021 SIGNATURE OF THE CANDIDATE

PLACE : Chennai

Page | 3
 TABLE OF CONTENT

1. INTRODUCTION
 Scope
 Overview
 Objective

2. SYSTEM ANALYSIS
 Feasibility
 Software Specification

3. SYSTEM DESIGN
 Module Design
 Input/Output Design
 Database Design

4. SYSTEM DEVELOPMENT
 Technology Used

5. SYSTEM TESTING AND IMPLEMENTATION

 Test Cases

6. CONCLUSION
7. BIBLIOGRAPHY
8. APPENDICES
 ER Diagram
 Data Flow Diagram

Page | 4
 INTRODUCTION

SCOPE
The Application of a Successful Agricultural Systemis a Database management system in
which It can used in a
Various organization for betterment of the farmers, Retailer and the customer.
Application of a Successful Agricultural System it is a web application where Farmers,
Retailer and Customer have a common Platform where Farmers can sell their crops to Whole
seller and Customer can can buy them and have a price comparison. And can also see the
what types of crops a farmers had.

OVERVIEW
In the Navigation Bar It has About Section, Product, View cart, My orders, Contact,
Log In, Register for The Customer, Whole Seller andFarmers, In this website
For Login and Register is common for theCustomer , Farmer and the Retailer
Where farmers can sell goods to the Retailer and customers can buy the good from the
website .
Retailer can add the Product and edit it According to its need ,The Farmer can add the
product , where customer can see it .

OBJECTIVES
• To provide the stress-free zone for the vegetable Retailers.
• This system can be use by both farmers and Retailers.
• To provide stress free zone same for farmers.
• It is a common web application between farmers and Retails.
• It can solve the problem between the Farmers and the Retailers.
• it will help to compare the price of everycrops, vegetable,
• It will also help the Customer to buy the Product For its need.

Page | 5
 SYSTEM ANALYSIS
FEASIBILITY STUDY
After the scope has been identified it is reasonable to ask that the project is feasible or
not. Software feasibility has four solid dimensions.
1. Technology - Is a project is technically feasible that is it uses latest technology.
2. Finance - Is it financially feasible that is, can development be completed at cost that it
client or market can afford.
3. Time - Time will be the project completed in ONE MONTH
4. Resources- does the organization have the resource to complete the project too
successfully? WE will discuss above subtopics one by one for the project to know about
feasibility.

Technology
In this project we will use php as the server site script and MS SQl – Server as the
back end. It is because php is highly capable to provide user friendly environment, which is
must in the websites according to requirement as well as it is very easy to program and needs
very few efforts to make it.
Xampp server also provides highly efficient database management system through
mysql with proper security concern as required. So we can start programming our website in
php to properly fulfill the requirements described in requirement analysis.

Finance
As the project is being made in php as the server site script and MS SQl - Server as
the back end. So the effort and cost needed to complete the project will be obviously very less
than to develop this in other language. The cost will be so less that the target customer for
whom we are developing this software can afford it.
Hence, the project is financially feasible.

Page | 6
 COST AND BENEFIT ANALYSIS
Cost and benefits analysis

In the early days of computing, software costs computed small percentage of the overall
computer based system cost. An order of magnitude error in estimates of software costs had
relatively impact. Today, software is the most expensive element of virtually all computer-
based system. For complex custom systems a large cost estimation error can make the
difference between profit and loss. Cost overrun can be disastrous for the developer.

To achieve reliable cost and effort estimates a number of options arise.

1. Delay estimation until late in the project.

2. Base estimate on similar projects that have already been completed.

3. Use relatively simple decomposition technique to generate project cost and efforts
estimates.

4. Use one or more empirical models for software costs and efforts estimation.

Project estimation:-

The project size is another important factor for project estimation that can affect
accuracy and efficacy of estimates. As size increases, the interdependency among various
elements of the software grows rapidly.

Risk Analysis:-

Risk analysis and management are a series of steps that help a software team to
understand and manage uncertainty. Many problems can infect a software project. A risk is a
potential problem-it might happen, it might not. But regardless of the outcome, it’s a really
good idea of identity it, assess its probability of occurrence, estimate its impact, and establish
a possibility plan should the problem actually occur

For Risk Analysis firstly recognizing what can go wrong that is called “Risk
Identification”. Next, each risk is analyzed to determine the probability that it will occur and
the damage that it will do if it does occur. Once this information’s established, risks are
ranked, by probability and impact. Finally a plan is developed to manage those risks with
high probability and high impact

Page | 7
Technical : This project is Possible in current technology but it has its own Restriction. It can
be used by Moderate version of any technology.
Technical Risk : There is a Possibility that the Website will not run properly
If not Provided the Suitable Environment.
Availability: Yes, it can be available Locally and it can be use in the
Any System.
Economic Feasibility : it is Possible in the Given Resource, it will reduce the
Headache of Retailers and the farmers where he can upload the goods.
The software used all are open source.
Schedule Feasibility:
The project has taken a bit time to complete, it may Require Little bit Time
Operational Feasibility:
IT is capable to deal with the Social Issue and Can be used in the Industry.
Software Specification:
Software Used in the Website:
PHP, HTML, CSS, MYSQL, PHPMYADMIN, XAMP SERVER,
BOOTSTRAPE,

SYSTEM DESIGN-
MODULE DESIGN : module is divided in three section
 Farmers
 Retailer
 Customer
Farmers – can sell the goods to the Retailer, where he can add the Product
Upload it , He can Search it by its Description ,
Retailers –Retailers Will take the good from the Framers and upload it in the website where
Customer can buy from the from there.
Customers – Customers can shop item from the website and where customers can buy from
There.

INPUT DESIGN:
Registering and Login is Common for all the three Entity Customer, Retailer

Page | 8
 PROJECT OVERVIEW

The project organization includes system flow and software process model. System
flow basically deals with the life cycle of the software. Software process model refers to the
various process models. System flow and software process model are described below.
SDLC (System Development Life Cycle):-
System flow is a process consisting of the life cycle

Feasibility study

Analysis

Design

Testing

Implementation

Evaluation

Maintenance

Page | 9
 HARDWARE & SOFTWARE SPECIFICATIONS

HARDWARE SPECIFICATIONS:
Microprocessor : Dual Core or more
RAM : 2 GB or more
Hard Disk Space : 260 GB or more
Monitor : TFT / LED /LCD
Printer : Laser / Ink Jet
Keyboard : 108Keys
Mouse : Digital / Optical
CD/DVD-ROM : 700 MB

SOFTWARE SPECIFICATIONS:
Server : Xampp
Front End : PHP
Other supporting languages : Java Script, Ajax, HTML 5, Bootstrap
Web Browser : Google Chrome or any other
Back-end : MY SQL 7.0

Operating System : Win 7 or more

Text Editor : visual studio code or any other

Page | 10
 SYSTEM DESIGN

PROGRAMER SETS IN DESIGNING PROJECT

System analysis and design are key to system lifecycle. Analysis must be done from
one step to another methodical achieving result in each step involve in the analysis are:

RECOGNIZATION OF NEED’S
It must be known what the problem is this needs preliminary survey and initial
investigation to determine whether any alternative system can solve the problem.

FEASIBILITY STUDY
Depending on the result of initial investigation, Evaluation of existing system and
procedure is performed also analysis of Alternative candidate system cost estimate are made.

ANALYSIS
It is detailed study of various operations performed by a system and their
Relationship within and outside of system. It is the logical model of the system as data
dictionary, data flow diagram etc. Also identifies the boundaries of the system and also
determines whether or not a candidate system should consider other related system.

DESIGN
Most creative and challenging phase of the system life is system design. The designs
describe a final system process by which it is developed/

IMPLIMELTATION
This process is less creative then system design. It is concerned with user training
preparation and life conversion.

Page | 11
 INPUT / OUTPUT DESIGNS

USE CASE DIAGRAM

Products

View Cart

My Orders

Contact

About

My Products
Customer
Login
Retailer
Registration

My Details

Farmer Logout

Add products

Receive Orders

Add Brand

Add Categories

Admin Remove Products

Remove Orders

Remove Users

Page | 12
CUSTOMER

Page | 13
Page | 14
Page | 15
Page | 16
Page | 17
RETAILER

Page | 18
Page | 19
Page | 20
ADMIN

Page | 21
Page | 22
Page | 23
Page | 24
FARMER

Page | 25
Page | 26
Database Tables

Page | 27
 SYSTEM DEVELOPMENT
STEP OF SDLC

FORM
ANALYSIS
1

OUTPUT DETAILED
DESIGIN SYSTEM
DOCUMENTATIO
N

COST JUSTIFICATION
INPUT DESIGN SUBMITTED TO &CANDIDATE SYSTEM DESIGN
DESIGIN MANAGEMENT
FOR APPROVAL

FILE
DESIGIN DESIGN ACCEPTED ABANDON PROJECT

PROCESSING
DESIGIN

TEST PROGRAM

2 GO FO IMPLEMENTATION

Page | 28
 USED INCREMENTAL MODEL IN SDLC:
Incremental Model is a process of software development where requirements are broken
down into multiple standalone modules of software development cycle. Incremental
development is done in steps from analysis design, implementation, testing/verification,
maintenance.

Each iteration passes through the requirements, design, coding and testing phases. And
each subsequent release of the system adds function to the previous release until all designed
functionality has been implemented.

The system is put into production when the first increment is delivered. The first increment is
often a core product where the basic requirements are addressed, and supplementary features
are added in the next increments. Once the core product is analyzed by the client, there is
plan development for the next increment.

Characteristics of an Incremental module includes

 System development is broken down into many mini development projects

 Partial systems are successively built to produce a final total system
 Highest priority requirement is tackled first
 Once the requirement is developed, requirement for that increment are frozen

Page | 29
Incremental Phases Activities performed in incremental phases
Requirement  Requirement and specification of the software are
Analysis collected
Design  Some high-end function are designed during this stage
Code  Coding of software is done during this stage
Test  Once the system is deployed, it goes through the testing
phase

When to use Incremental models?

 Requirements of the system are clearly understood

 When demand for an early release of a product arises
 When software engineering team are not very well skilled or trained
 When high-risk features and goals are involved
 Such methodology is more in use for web application and product based companies

Advantages and Disadvantages of Incremental Model

ADVANTAGES DISADVANTAGES
 The software will be  It requires a good planning designing
generated quickly during the
software life cycle
 It is flexible and less  Problems might cause due to system
expensive to change architecture as such not all requirements
requirements and scope collected up front for the entire software
lifecycle
 Throughout the development  Each iteration phase is rigid and does not
stages changes can be done overlap each other
 This model is less costly  Rectifying a problem in one unit requires
compared to others correction in all the units and consumes a
lot of time
 A customer can respond to 
each building
 Errors are easy to be 
identified

TECHNOLOGY USED

Page | 30
ABOUT PHP

PHP started out as a small open source project that evolved as more and more people
found out how useful it was. Rasmus Lerdorf unleashed the first version of PHP way back in
1994.
 PHP is a recursive acronym for "PHP: Hypertext Preprocessor".
 PHP is a server side scripting language that is embedded in HTML. It is used to
manage dynamic content, databases, session tracking, even build entire ecommerce
sites.
 It is integrated with a number of popular databases, including MySQL, PostgreSQL,
Oracle, Sybase, Informix, and Microsoft SQL Server.
 PHP is pleasingly zippy in its execution, especially when compiled as an Apache
module on the Unix side. The MySQL server, once started, executes even very
complex queries with huge result sets in record-setting time.
 PHP supports a large number of major protocols such as POP3, IMAP, and LDAP.
PHP4 added support for Java and distributed object architectures (COM and
CORBA), making n-tier development a possibility for the first time.
 PHP is forgiving: PHP language tries to be as forgiving as possible.
 PHP Syntax is C-Like.
Common Uses of PHP
PHP performs system functions, i.e. from files on a system it can create, open, read,
write, and close them. The other uses of PHP are:
 PHP can handle forms, i.e. gather data from files, save data to a file, thru email you
can send data, return data to the user.
 You add, delete, modify elements within your database thru PHP.
 Access cookies variables and set cookies.
 Using PHP, you can restrict users to access some pages of your website.
 It can encrypt data.

Page | 31
 MY SQL SERVER

MySQL is an open-source relational database management system (RDBMS). Its name is a

combination of "My", the name of co-founder Michael Widenius's daughter, and "SQL", the
abbreviation for Structured Query Language. The MySQL development project has made
its source code available under the terms of the GNU General Public License, as well as
under a variety of proprietary agreements. MySQL was owned and sponsored by a single for-
profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation. For
proprietary use, several paid editions are available, and offer additional functionality.

Overview

MySQL is written in C and C++. Its SQL parser is written in yacc, but it uses a home-
brewed lexical analyzer. MySQL works on many system platforms,
including AIX, BSDi, FreeBSD, HP-UX, eComStation, i5/OS, IRIX, Linux,
macOS, Microsoft Windows, NetBSD, Novell NetWare, OpenBSD, OpenSolaris,
OS/2 Warp, QNX, Oracle Solaris, Symbian, SunOS, SCO OpenServer, SCO UnixWare,
Sanos and Tru64. A port of MySQL to OpenVMS also exists.

The MySQL server software itself and the client libraries use dual-licensing distribution.
They are offered under GPL version 2, beginning from 28 June 2000 (which in 2009 has been
extended with a FLOSS License Exception) or to use a proprietary license.

Page | 32
3.2 TOOLS USED
XAMPP
XAMPP is an easy to install Apache distribution containing
MariaDB, PHP, and Perl. XAMPP is a free and open-source
cross platform web server solution stack package developed
by Apache Friends, consisting mainly of the Apache HTTP
Server ,MariaDB database, and interpreters for scripts written
in the PHP and perl programming languages. Since most
actual web server deployments use the same components as
XAMPP, it makes transitioning form a local test server to a
live server possible.

XAMPP is a small and light Apache distribution containing the

most common web development technologies in a single
package. Its contents ,small size ,and portability make it the ideal
tool for students developing and testing applications in PHP and
MYSQL. XAMPP is available as a free download in two
specific packages full and lite .

Visual Studio Code is a free source-code editor made by

Microsoft for Windows, Linux and macOS. Features include support for debugging, syntax
highlighting, intelligent code completion, snippets, code refactoring, and embedded Git.
Users can change the theme, keyboard shortcuts, preferences, and install extensions that add
additional functionality.

Microsoft has released Visual Studio Code's source code on the VSCode repository of

GitHub.com, under the permissive MIT License, while the compiled releases are freeware.

In the Stack Overflow 2019 Developer Survey, Visual Studio Code was ranked the most
popular developer environment tool, with 50.7% of 87,317 respondents reporting that they
use it.

Page | 33
BROWSER(CHROME) - A browser is a software application for accessing information
on the World Wide Web . Each individuals web page, image and video is identified by a
distinct URL, enabling browsers to retrieve and display them on the users device
A web browser is not the same thing as a search engine , though the two are often confused .
For a user, a search engine is just a websites. But to connect to and display websites on their
device a user needs to have a web browser installed.

Page | 34
 DESIGN OF DATABASE
A database is a central repository of related information. That is a database is physical
grouping of a collection. When organized in a predictable a structure way, it cuts redundancy
and each data access.

RELATIONAL DATABASE:

A relational database is one in which details arranged in the form of matrix, with the row of
the matrix forming each individual record and the columns of the matrix forming the
individual fields of information across all records.

DATABASE MANAGEMENT SYSTEM:

A database management system is an integrated S/W system that has facilities for defining
the logical and physical structure of the data in a database and for accessing, entering and
deleting data.

ADVANTAGE OF A TYPICAL DBMS

1. Data redundancy can be reduced.

2. Data can be shared.

Page | 35
 CONCLUSION
 We can make this website more attractive and featured.

 Currently the system works for limited number of administrators to work. In the near
future it will be extended.

 It will help to increase marble products business.

 This project will help to increase profit for stone artists.

 It will help to increase marbles product market globally.

 This project will increase awareness about marble products in consumers.

 Currently the sytem works for limited number of administrators to work. In the near
future it will be extended..

LIMITATIONS

We have tried enough to make our project error and limitation free and till the
submitted of report. We have not found any error in the project at run time. But error and
mistake is subject human being. We have achieved almost of objectives, but still it contains
some drawbacks of manual Way of working, which are not removed yet.

Some limitations found in our project are listed below: -

1. This is online project in which user cannot enter on the administrator area .

2. Addition of new entries and the edit and records can’t be done any user.

3. In this project facility is provide for serially input of record.

4. A user and seller can not make any changes to the structure of the project.

Page | 36
 BIBLIOGRAPHY
Project were distributed evenly among the group to the project. All three worked
together in the project planning, sharing in the opportunity of any models and analyzing all
specifications made by the proprietor.

The web page using Bootstrap, PHP, JQUERY and JavaScript. She created the
interaction between the web page and the database that will be held by the Mysql. The
website also connected with the database.

 https://www.tutorialspoint.com
 https://www.w3schools.com
 https://www.geekforgeeks.com
 https://en.wikipedia.org

Page | 37
 APPENDICES
ER DIAGRAM
mobile
email

Id pin id

fname city sid

lname address product_code

registration
users
address product_name
id orders
product_desc
city

fname
pin mobile Aadhar price

date
email units
Id
total
password
parent id

type
category brand

category
brand
category

sid

id

product_code

registration
products
title

description

image

qty
deleted

price c_category

brand p_category
Page | 38
 DATA FLOW DIAGRAM

A graphic that illustrates the movement of data between external entities and the processes

and data stores within a system. Data Fusion Demonstrator. A data flow diagram (DFD) is

graphic representation of the "flow" of data through business functions or processes. More

generally, a data flow diagram is used for the visualization of data processing. It illustrates

the processes, data stores, and external entities, data flows in a business or other system

and.

0 Level DFD

Process
Registration Login Operations Logout

Error in Login

Page | 39
1 Level DFD

Registration Registration
user Process
Login

Verify

Check
user type

Products
Customer / Retailer
My Orders

My Products

Login
Retailer
Registration

My Details

Add products
Farmer

Receive Orders

Add Brand

Add Categories

Admin
Remove Products

Remove Orders

Remove Users

Page | 40
2 level DFD

Process
Registration Registration
user Login

Verify

Check
user type

Regist
Product Products
s
ration
Regist Customer/ Retailer
Orders My Orders
ration
My Products Regist
Product
s
ration
Login

Registration Registr
user
Retailer / Farmer
ation
My Details

Add products

Receive Orders
Regist
Product
Registr
brand Add Brand s
ration
ation
Registr
category Add Categories
ation
Admin
Remove Products

Remove Orders Regist

Orders
ration
Remove Users Registr
user
ation

Page | 41