My Ssec Capstone Project A Project Report on “A TESTED CROP AUCTIONING SYSTEM” Submitted by PATEL DISHA A

A Project Report on “A TESTED CROP AUCTIONING SYSTEM” Submitted by PATEL DISHA A

A Project Report on

“A TESTED CROP AUCTIONING SYSTEM”

Submitted by

PATEL DISHA A. (150220107071)
PATEL HIRAL P. (150220107074)

In Partial Fulfilment for the award of the degree
Of
Bachelor of Engineering
In
Computer science Engineering

Government Engineering College, Patan
At & Post. Katpur, Patan
Gujarat – 384265

Gujarat Technological University, Ahmedabad
May, 2018

Government Engineering College, Patan

CERTIFICATE

Date: / /2018

This is to certify that the project entitled “A Tested Crop Auctioning System” has
been carried out by Ms. Patel Disha A , Ms. Patel Hiral P Enrolment No.:
150220107071 , 150220107074 under my guidance in fulfilment of the degree
Bachelor of Engineering in Computer Science Engineering Semester-VII of Gujarat
Technological University, Ahmedabad during the academic year 2018-2019.

Internal Guide: Prof. : Neha.J.Mistry

Head of Department
H.B.Jethava

ACKNOWLEDGEMENT

We would like to take this opportunity to express our sincere thanks
and deep sense of gratitude to all those people without whose support,
encouragement and co-operation this project would not have been a
Success. We would like to thank our institute for giving us the
Opportunity to have some feel about the Industrial environment. We
Would like to thank our H.O.D Prof. H.B. Jethava, our Faculty
Prof. Neha J. Mistry for constantly guiding and showing us the correct
path to reach towards our desired goal. This acknowledgement will be
incomplete if we do not convey our heartfelt gratitude to other faculty
members for their guidance and moral support during the preparation
of this project.

Patel Disha A.
Patel Hiral P.

ABSTRACT

The tested crop auctioning system is useful for a many people,
but it most use full for the farmer. The objective of this project is to
provide better solution to the farmer. It will make available up-to-date
rated crop in the market. This system makes available to the user
(farmer) the original price of the crops. The user can login or logout
& view his/her personal details and available crops details. The
administrator can block and unblock user & controls entire database. .
The administrator controls the entire database. All details are
maintained by administrators. The main role of the administrator is to
safeguard the database. The project security is provided with login-id,
password unauthorised use cannot use.

INDEX
Sr No. NAME Page no.
1 1.0 Introduction
1.1 Project summery
1.2 Objective and scope
1.3 Hardware –software technology used

1
2 2.0 System Analysis
2.1 Study of current system
2.2 Problem and weakness of current
system
2.3 Requirement of new system

3
3 3.0 Project Management
3.1 Project Planning And Scheduling
3.2 Risk Management
3.3 Risk Planning
3.4 Risk Identification
5
4 4.0 Implementation
4.1 Use case Diagrams
4.2 Activity Diagrams
4.3 Dataflow diagrams
4.4 Dataflow diagrams
4.5 Sequence diagrams
4.6 E-R Diagram
10

8 8.0 Biography and Reference 32

4.7 Data dictionary

5 5.0 System Design
5.1 AEIOU summery

5.2 Eampathy canvas

5.3 Ideation canvas

5.4 Production development canvas

21
6 6.0 Limitation And Future Enhancement 30
7 7.0 Conclusion 30

A Tested Crop Auctioning System GEC Patan

1

1. INTRODUCTION:

1.1 PROJECT SUMMARY:

? Farming is the only way Farmers are able to earn livelihood for them.Crops they sell earns
livelihood to them as well as they are necessary to sustain human life.
The objective of Project is to provide better solution to farmers.It will make available Up-to-
Date rated crops in the market.

1.2 OBJECTIVE AND SCOPE:

OBJECTIVE:

? To make available to the user(farmer) the original price of the crop.
? To make the best rated crop available to user.
? To make best deserved price available to user(farmer).

SCOPE:-
This project has greater scope for future. This project is developed on web base system.
Project security is provided with login-id, passwords unauthorized person cannot use your. Only
authorized persons that have proper authority only can access it account.

INTRODUCTION chapter-1

A Tested Crop Auctioning System GEC Patan

2

1.3 HARDWARE–SOFTWARE TECHNOLOGY USED:

? Software Environment:-

? Hardware requirement:-

Tools/Technology Front-end – Java 8.0
Back-end – MySQL
Browser – Internet Explorer 6.0 and above version,
Firefox, Google Chrome
Front end tool – Net Beans IDE8.02
Operating System Windows 8
Client Configuration
? Operating System : Windows 7or above
? RAM : 1 GB minimum

Server Configuration
Servers, each with following configuration
? CPU
? Core i5 or i7
? RAM : 4GB Minimum
? 500GB hard disk

A Tested Crop Auctioning System GEC Patan

3

2 System Analysis:

2.1 STUDY OF CURRENT SYSTEM:
The e-mandi is not oriented to just Business.Here in present system Government fixes the
price of the crop and that is fixed for every crop and farmer regardless of the quality of the
crop.Here in present system sometimes there occurs the situation of partiality as the one with
low quality crop gets the same price as the one getting for good quality crop.
? NORMAL USER
? ADMIN
? LABORATORY

NORMAL USER’S ROLE:-
The user’s can login/logout. He/She can view his/her personal details, and available
crops details. The user can just view the information where he/she could not make
changes in the database.User can add/buy crops.They can update their crop’s details
too.User can give complaint.
ADMINISTRATOR ROLE:-
The administrator can block and unblock user.Admin takes care of compalaints. Also do
Payment management, website updating. The administrator controls the entire database. All
details are maintained by administrators. The main role of the administrator is to safeguard the
database.
2.2 PROBLEM AND WEAKNESS OF THE CURRENT SYSTEM:
? All kinds of products are made avialble.No quality criteria is applied.
? All crops have same price fixed by government regardless of quality.
? Not equally beneficial for all users.

System Analysis chapter 2

A Tested Crop Auctioning System GEC Patan

4

2.3 REQUIREMENT OF NEW SYSTEM:

Due to the above problems and weakness in current system, our proposed system provides the
solution for all the problems in a single platform.
This system provides a user friendly environment for all users.Farmers are paid according to quality
so no biased environment is created.The system is much needed in India as majority of population has
farming as their occupation.
2.4 FEASIBILITY STUDY:
? Feasibility study is the study of the system to check whether the system made is feasible or not. It
is very useful to check whether the system work as per the requirement or not.

? Feasibility study is highly dependent on the type of developer, the end-user and the application on
other hand.

A Tested Crop Auctioning System GEC Patan

5

3 Project Management:

3.1 Project Planning And Scheduling:
3.1.1 Project Development Approach:
Iterative and Incremental development is any combination of both iterative
design or iterative method and incremental build model for software development. The
combination is of long standing and has been widely suggested for large development efforts.
During software development, more than one iteration of the software development cycle may
be in progress at the same time.” and “This process may be described as an ‘evolutionary
acquisition’ or ‘incremental build’ approach.” The relationship between iterations and
increments is determined by the overall software development methodology and software
development process. The exact number and nature of the particular incremental builds and
what is iterated will be specific to each individual development effort.

Fig1(a)

Project Management chapter-3

A Tested Crop Auctioning System GEC Patan

6

Iterative development is a way of breaking down the software development of a large application
into smaller chunks. In iterative development, feature code is designed, developed and tested in
repeated cycles. With each iteration, additional features can be designed, developed and tested
until there is a fully functional software application ready to be deployed to customers.

3.1.2 Project Plan & Schedule Representation:
Plan:The objective of project planning is to provide framework that enable user to get all
updated details of properties and different schemes of properties, cost and area . Find flaws of
existing system and work in the direction of enhancing it with an effective and efficient
solution.
Analyzing Existing System:- Traditional Approach is to gather the data about estates
manually from the scattered sources. Client has to do listing of different data manually from
different sources. It causes waste of hours and tedious.

Gantt Chart:
Table-1 Gantt Chart up to Documentation

Work tasks July August September October
Analyze the
requirements.
Study and design IDP.
Study of project
planning and
scheduling.
Study of risk analysis
Every Day Working
Documentation.
Final Documentation.

Documentation
Complete

A Tested Crop Auctioning System GEC Patan

7

3.1.3 Roles and Responsibilities:-

This project is being done solely by our me. So I m burdened with all responsibilities. We have to
act as Designer, Coder, and tester.

3.2 Risk Management:
3.2.1 Risk Analysis:
Risk identification and management are the main concerns in every software project. Effective
analysis of software risks will help to effective planning and assignments of work.Risks are
identified, classified and managed before actual execution of program. These risks are
classified in different categories.
Schedule Risk:
Schedule risks mainly affect on project and finally on company economy and may lead to
project failure.
Schedules often slip due to following reasons:
? Wrong time estimation
? Resources are not tracked properly. All resources like staff, systems, skills of individuals
etc.
? Failure to identify complex functionalities and time required to develop those
functionalities.
? Unexpected project scope expansions.
Budget Risk:
? Wrong budget estimation.
? Cost overruns
? Project scope expansion

Operational Risks:
Risks of loss due to improper process implementation, failed system or some external events
risks.
Causes of Operational risks:
? Failure to address priority conflicts
? Failure to resolve the responsibilities
? Insufficient resources
? No proper subject training
? No resource planning
Roles NISHI NISHI NISHI
Feasibility study Yes Yes Yes
Analysis Yes Yes Yes
Design Yes Yes Yes
Implementation Yes Yes Yes
Test Yes Yes Yes
Maintenance Yes Yes Yes

A Tested Crop Auctioning System GEC Patan

8

? No communication in team.

Technical risks:
Technical risks generally leads to failure of functionality and performance.
Causes of technical risks are:
? Continuous changing requirements.
? No advanced technology available or the existing technology is in initial stages.
? Product is complex to implement.
? Difficult project modules integration.

Programmatic Risks:
These are the external risks beyond the operational limits. These are all uncertain risks are
outside the control of the program.
These external events can be:
? Running out of fund.
? Market development
? Changing customer product strategy and priority
? Government rule change

3.2.2 Risk Planning:
A plan to control the risk must be developed. This is generally done at the same time as the
risk assessment, by the same people. You need to consider how to control the risks and how
this could impact on service delivery.
Prioritize:
The risk assessment will have identified the highest risks and these must be dealt with first.
However, if a low priority hazard can be easily fixed, it should still be fixed immediately.
Where possible, eliminate the risk
Your first preference should always be to eliminate the risk entirely, rather than just minimize
it, and this is required by law.

Hierarchy of control
Legislation specifies a “hierarchy of control” which should be considered when planning risk
control measures. The higher up the hierarchy, the more effective the control. You should
always start at the top and work your way down the hierarchy. Communication with the client
? their expectations and responsibilities
? options to manage the risks
? alternative or preferred measures
? who will be responsible for controlling the risks

A Tested Crop Auctioning System GEC Patan

9

Case review meeting
A useful strategy to assist in negotiating and implementing risk controls can be a case review
meeting facilitated by the care coordinator for the client. It involves support workers, any
volunteers and other key stakeholders involved in the risk management process.

3.2.3 Risk Identification :
? Brainstorming is a technique that is best accomplished when the approach is unstructured.
To achieve the desired outcome, it is essential to select participants that are familiar with the
topics discussed, relevant documentation is provided and a facilitator that knows the risk
process leads the group.
? Surveys are a technique where lists of questions are developed to seek out risk in a particular
area. A limitation of this method is that people inherently don’t like to complete surveys and
may not provide accurate information.
? Interviews are an effective way to identify risk areas. Group interviews can assist in
identifying the baseline of risk on a project. The interview process is essentially a questioning
process. It is limited by the effectiveness of the facilitator and the questions that are being
asked
? Experiential Knowledge is the collection of information that a person has obtained through
their experience.
? Documented Knowledge is the collection of information or data that has been documented
about a particular subject. This is a source of information that provides insight into the risks
in a particular area of concern.
? Risk Lists are usually lists of risks that have been found in different situations.
? Outputs from Risk-Oriented Analysis – There are various types of risk oriented analysis.
Two such techniques are fault tree analysis and event tree analysis. These are top down
analysis approaches that attempt to determine what events, conditions, or faults could lead to a
specific top level undesirable event.
? Historical Information is basically the same as documented knowledge. The difference is
that historical information is usually widely accepted as fact.

A Tested Crop Auctioning System GEC Patan

10

System Design chapter-4

4 System Design:

4.1 Usecase Diagrams:

A Tested Crop Auctioning System GEC Patan

11

4.2 Activity Diagrams:

A Tested Crop Auctioning System GEC Patan

12

4.3 Dataflow diagrams: (0 Level)

0.0
A tested crop auctioning
system
UserUserLaboratery
Request
Response
Request
Response
Admin
RequestResponse

A Tested Crop Auctioning System GEC Patan

13

4.4 Dataflow diagrams: (1 Level)

A Tested Crop Auctioning System GEC Patan

14

4.5 Sequence diagrams:

A Tested Crop Auctioning System GEC Patan

15

A Tested Crop Auctioning System GEC Patan

16

4.6 E-R Diagrams:

A Tested Crop Auctioning System GEC Patan

17

4.7 DATA DICTIONARY

? A data dictionary is a catalogue-a-repository-of the elements in a system. As the name
suggests, these elements centre on data and the way they are structured to meet user
requirements and organization needs. In a data dictionary you will get a list of all the
components composing the data flowing through a system. The major components are
data flows, data stores, and processes. The data dictionary stores details and
descriptions of these elements.
? If analysts want to know how many characters are in a data item, by what other names
it is referenced in the system, or where it is referenced in the system or where it is used
in the system, they should be able to find the answers in properly developed data
dictionary.
? Why is a Data Dictionary Important?
Analysts use data dictionary for fie important reasons
? To manage the information in a big system
? To communicate a general meaning for all system elements
? To document the functions of the system
? To facilitate analysis of the details in order to evaluate characteristics and determine
where system changes should be made
? To locate errors and omissions in the system.

A Tested Crop Auctioning System GEC Patan

18

1. User

2. Crop

3. LAB

A Tested Crop Auctioning System GEC Patan

19

4. LOGIN

5 Bid

6. Bidding Feedback

7. Feedback

A Tested Crop Auctioning System GEC Patan

20

8. Rating

9. Block_Unblock

A Tested Crop Auctioning System GEC Patan

21

System design : chapter-5

DESIGN

??AEIOU SUMMARY

??EAMPATHY CANVAS

??IDEATION CANVAS

??PRODUCT DEVELOPENT CANVAS

A Tested Crop Auctioning System GEC Patan

22

5.1 AEIOU SUMMARY

Environment:
? Farm
? Laboratory
? Warehouse

Activities:
? Update
? Login
? Registration
? Feedback

A Tested Crop Auctioning System GEC Patan

23

? Delete crop
? Reject crop
? Add crop

Interactions:
? Farmer
? Laboratory
? Dealer

Users:
? Farmer
? Admin
? Laboratory
? Dealer

Objects:
? Laptop
? Mobile
? Laboratory
? Crop

A Tested Crop Auctioning System GEC Patan

24

5.2 EAMPATHY CANVAS

Users:
? Farmer
? Admin
? Laboratory
? Dealer

Stakeholders:
? Lab assistant
? Admin

Activities:
? Update

A Tested Crop Auctioning System GEC Patan

25

? Login
? Registration
? Feedback
? Delete crop
? Reject crop
? Add crop

Happy story:
Farmer from my village, come to know this website creates the account and sells
the crop, makes more than expected money. On the other side, dealer gets the hygienic
crop without any interruptions.
Happy story:
Warehouse from mahesana sees an interest in buying a large amount of crop and
finds out the good quality of crop in this website, the farmer takes a reasonable price ,
dealer is happy buying from this website.

Sad story:
Once the farmer gave a sample to the laboratory for rating, laboratory took a test
and gave less quality review than the crop deserved, so no one took a crop and became
a big loss for a farmer.
Sad story:
Laboratory gave the rating to crop on the basis of the sample and dealer bought
the crop on the basis of that rating but dealer got half of the crop got very less quality
so that dealer had to suffer a great loss.

A Tested Crop Auctioning System GEC Patan

26

5.3 IDEATION CANVAS

People:
? Lab assistant
? Dealer
? Farmer
Activities:
? Update
? Login
? Registration
? Feedback

A Tested Crop Auctioning System GEC Patan

27

? Delete crop
? Reject crop
Add crop
Situations/context/location:
? Warehouse
? Laboratory
? Farm

Props/possible solutions:
? Network problem
? Restart net

A Tested Crop Auctioning System GEC Patan

28

5.4 PRODUCTION DEVELOPMENT CANVAS

Purpose:
? Live Lab results
? Online bidding
? More security
? No paper work

People:
? Lab assistant
? Dealer
? Farmer

A Tested Crop Auctioning System GEC Patan

29

Product experience:
? Convenient
? Less complex
? Easy
Product functions:
? Delete crop
? Add crop
? Update crop
? Reject crop

Product features:
? Remote
? Easy bidding
? Crop transparency
Components:
? Laptop
? Mobile
? Internet
Customer revalidation:
? Mobile verification
? Email verification
? Sms
Reject/redesign/retain:
? Farmer detail

A Tested Crop Auctioning System GEC Patan

30

Limitation And Future Enhancement: chapter-6

6.1 Limitation And Future Enhancement:

Limitation:
? Application can be error free but never be failure free i.e. software of application can be
syntactically correct but semantically it can have some shortcomings.
? At one time only one page can be accessed.
? More load on the system sometimes affects the performance of the system.
Future enhancement:
Software or Application is continuously changing entity. Software or Application should be reflected
with new features whenever new requirements emerge.
Once system is implemented and installed into its essential environment, we have to examine newly
emerging requirements, misinterpretation of older requirements, impact due to omission of some
important requirements, and failure of some features
? Try to remove all above limitation from our project.

A Tested Crop Auctioning System GEC Patan

31

Conclusion: chapter-7

7.0 Conclusion:

From this project, we conclude that, this application is convenient and easy approach for the
people who are not aware of the area, and need household related services at anytime and
anywhere.

A Tested Crop Auctioning System GEC Patan

32

8. Biography and Reference:

8.1Books:

1) Core Java-2 Volume1- Advance features
2) Complete Reference (7th Edition)
3) Object Oriented Design
4) Software Engineering

Biography and Reference: chapter-8