A

PROJECT REPORT

ON

“E-Tender System”

Submitted By

Miss. Jadhav Vaishnavi Ramchandra

Guided By

Mr. Mahajan S.P.

In partial fulfilment for award of the degree

MASTER OF COMPUTER SCIENCE

LOKNETE DR. BALASAHEB VIKHE PATIL (PADMABHUSHAN AWARDEE)

PRAVARA RURAL EDUCATION SOCIETY’S

PADMASHRI VIKHE PATIL COLLEGE OF ARTS SCIENCE

AND COMMERCE, PRAVARANAGAR,TAL-RAHATA,
DISTAHMEDNAGAR, Pin-413713
Year:2022-23
LOKNETE DR. BALASAHEB VIKHE PATIL (PADMABHUSHAN AWARDEE)
PRAVARA RURAL EDUCATION SOCIETY’S

PADMASHRI VIKHE PATIL COLLEGE OF ARTS

SCIENCE AND COMMERCE, PRAVARANAGAR TAL-
RAHATA, DIST-AHMEDNAGAR Pin-413713

CERTIFICATE

This is to certify that the work embodied in

the project
“E-Tender System” is the original work
done by Miss. JADHAV VAISHNAVI
RAMCHANDRA for the degree of Master in
Computer Science of Savitribai Phule Pune
University, Pune in “HTML, CSS,
BOOTSRAP, JAVA” under my personal
guidance and has completed to my entire
satisfaction.

Project Guide HOD

Mahajan S.P. Gondkar R.R.

External
Internal Examiner Examinar
 INDEX
Sr. No. Description Page No.
1. Introduction 5
1.1 Acknowledgment 6
1.2 Company Profile
1.3 Introduction
1.4 Existing system
1.5 Scope of system
2. Proposed System 6
2.1 Proposed System 6
2.2 Objective of System
2.3 User Requirement
2.5 Detailed Description of technology Used
2.6 Feasibility Study
3. Analysis and Design 7
3.1 ER Diagram 9
3.2 Data Dictionary
3.3 Class Diagram
3.4 Object Diagram
3.5 Use Case Diagram
3.6 Activity Diagram
3.7 Sequence Diagram
3.8 Component Diagram
3.9 Deployment Diagram
4. Implementation 10
4.1 Input and Output Screens 11
5. Limitation and Enhancement 13
6. Bibliography 14
 Acknowledgement

It’s our duty to express our thanks to all of does who contributed
directly or indirectly to our project.

Firstly, we would thank you Padmashri Vikhe Patil College of Arts

Science and Commerce, Pravaranagar and the Department of Computer Science
for giving us an opportunity. Many thanks to Prof. Gondkar R. R., Head of the
Department of Computer Science for his encouragement and valuable guidance.

We acknowledgement our indebted to Prof. Mahajan S.P. who initiated

us to complete to this project and guided us timely. We would like to thanks,
which timely made us alert of our mistake and guided in system designing.

It’s our privilege to express our gratitude to all staff member and non-
staff members for their excellent suggestion and active co-ordination.

Last but not the least, we would like to thank all our friends for their
support and timely help.

You’re sincerely

Miss. Jadhav Vaishnavi Ramchandra

 Company Profile

TechRel Technologies Pvt.Ltd

Add: Raghudurga,Opp. Varunraj Hotel,

Near Persistent,Off Karve Road ,
Erandwane,

Pune-411 004

About the Company

Being an IT Private Limited Company, we are intended to applaud the web

plans and develop technology to help people create brands on the web. We
pioneered Web Design and Software Development services and call our
company TechRel Technologies Pvt.Ltd, which means we can handle and
satisfy all your IT needs. As an IT Limited Company, we aim to make your
company smart, exclusive, and direct in the online environment so that it can
generate a high Return on Investment.

INTRODUCTION
 This is a plan to make Maha E-Tender publishing online. As a part of it, Maha E-Tender data
is recorded along with particulars of the products, their specifications and conditions. Tenders
published will be visible to the visitors of the site till the closing date of tender.

Many huge enterprises handle large/huge projects of government and other private
enterprises. In all such projects thousands of employees would be working on them. Such
enterprise requires purchases from various vendors for different purposes. The employees
would float tenders globally by advertising in reputed newspapers. Advertising in newspapers
involves lot of cost, searching in newspapers is time-consuming, communication gap between
buyers and suppliers (only way is through phone or mail), receiving bids and finalizing
tenders takes a lot of time. So we make this whole process of tendering online which is
efficient and consumes very less time.

Existing System
In the existing system, all the work is done manually. This Maha E-Tender works need to be
completed manually. Contractors need to submit their documents on time and must be submitted
through ordinary post by which they sometimes not able to bid for particular Maha E-Tender on
time.
All working personnel within department involved just for doing the same task which is
document verification and there may be a chance in which the best one may be left behind.

1.4. Limitations of Existing system

The limitations of existing system are as follows:
1. Advertising in newspapers involves lot of cost.
2. Once the paper is lost, you cannot view them.
3. Searching in newspapers is time-consuming.
4. Communication gap between buyers and suppliers(only way is through phone or mail)
5. Receiving bids and finalizing tenders takes a lot of time.

System Requirements

Software Requirements:
⚫ Server side :-
Operating system Linux/Windows
Processor Core 2 Duo

Software Web Server, JDK 1.8 , Html5,Css3

MySQL
Hardware Requirements:
⚫ Server side :-
RAM 4 GB
Hard Disk 60 GB and Above.

⚫ Client side :-
RAM Minimum 2 GB
Hard Disk Minimum 80 GB
Processor Dual Core or above

Scope

This software is used for E-Tender and posted tenders can be viewed anywhere and
anytime. Suppliers can ask queries immediately.
Bidding online saves a lot of time and buyers can answer queries posted by suppliers
immediately.
 Proposed System

The Proposed Maha E-Tender provides all Maha E-Tender documents online which can be
accessed by all the vendors using their id and password. Vendors can able to act on more than one
E-Tender through this online system.

Eliminating the need for sending and receiving the documents by post, so immediate response can
be taken for the existing tender. To reduce paper work, data which are available online, using this
final decision can be taken by the administration and can contact directly to such suppliers.

Many huge enterprises handle large/huge projects of government and other private
enterprises. In all such projects thousands employees would be working on them. Such
enterprise requires purchases from various vendors for different purposes. The employees
would float tenders globally by advertising in reputed newspapers or on Website.

Proposed System:-

Here, the entire process of tendering is done online.

● Buyers publish tenders.

● Tenders consist of product name, its specifications, quantity etc.
● Suppliers log in and view the E-Tender details.
● If the supplier is new, he registers in the website.
● Supplier can pose queries if he has any.
● Buyers answer the queries posed by suppliers.
● If interested, supplier bids for the product. Buyers view the bid and select the best bid.
 Objectives

● No cost for advertising in newspapers.

● Tenders can be viewed anywhere and anytime.
● Suppliers can ask queries immediately.
● Bidding through online saves a lot of time.
Buyers can answer queries posed by suppliers immediately
Functional Requirement:
The functional requirements of this system are as follows:
1) Marketing and Sales:
● Project and E-Tender: Admin can manage their all details.
● Advertisement Management: Admin can manage their all Ad details.
● Contact Us Management: System can manage their all customers
contact details.
● Product Category Management System can manage all the details of
the organizations with which the organization have some service
contracts or tie-ups.
● Report Management: Organizations can manage all the details of
their Dealer and the customer.
● Package Management: System can manage all Package related Data.
● Improve Rank Management: System can manage all their Rank
details data.
● Dynamic Website Management: Admin can manage Dynamically
created website data Customer wise.

Non-functional Requirements:
The Non-functional requirements of this system are as follows:

Security:
● Each member is required to have an individual password
● Administrators have the option of increasing the level of password security their
members must use.
● For maximum security, each member must protect their password.
Reliability:
● System will prompt the user if any incorrect input is made.
● To handle data consistency, DBMS software is used.
● User can easily work through the different menus and buttons.
 Maintainability:
● Proper documentation is available for further upgradation and maintenance.
● User will be trained enough to handle the minor changes required.
Availability:
● The system shall be available all the time.
Portability:
● System is independent of hardware specification.
● It can run on any operating system
● System is independent of browser compatibility because web pages will be designed
by JSP and Strut2.0.

Performance:
● The performance of our product is at its best if stored locally, as the response time will
be much faster.
● If the product accessed via Internet, the performance is limited by the connection
speed.
● The only foreseen limitation is that of web server response.
User Friendly:
● Our system is very easy to use and user friendly. Its GUI is very attractive and
understandable to the common users.
Module Specification
The major modules of the project are:
1. Administration
2. Employee
3. Vendor
4. Supplier

Admin:

1. This specification is provided with privacy to prevent access to the unauthorized user
accounts.
2. Publish Tender
3. View all Supplier
4. View all Vender
5. Manage Tender
6. Administrator is the master user of this system who will responsible for uploading
i. advertisement documents,
ii. verifying suppliers by using their information,
iii. maintaining data
iv. Confirmation of final report.

Employee:
1. The employee will design the E-Tender to be published.
2. As a part of it, E-Tender data is recorded along with the particulars of products, their
specifications and conditions.
3. Tenders recorded will be visible to the visitors of the site on a particular date as mentioned
in the data.

Vendor:
1. The vendor needs to get registered and log in with a valid username and password.
2. The vendor can apply for the E-Tender and view the status of the tender.
3. The vendor can give feedback

Supplier:
1. Here suppliers login and view the tenders details.
2. If the suppliers are new, he/she registers in the website.
3. Suppliers can pose queries if he/she has any. Then buyers answer the queries posed by the
suppliers.
4. Here if interested, suppliers bid the product.
5. Buyers view the bid and select the best bid.
6. The supplier will be the person who will bid for the published E-Tender and will monitor
the status of E-Tender through this module.
 FEASIBILITY STUDY
Feasibility study carried out whether there is complex problem. A feasibility study is
undertaken to determine the possibility or probability of either improving the existing system or
developing completely new system. Feasibility study evaluates the cost and benefits of the
proposed system.
There are three aspects of feasibility study, which should be check. Following are the types
of Feasibility Study:

1.Technical Feasibility
2.Economic Feasibility
3.Operational Feasibility

Technical Feasibility:

Definition:
“Technical feasibility is carried out to determine whether the company has the
capability, in terms of software, hardware, personnel and expertise, to handle the
completion of the project.”

Technical feasibility determines whether it is possible to develop the project with available
equipment, available software technology and the workers. If there is any kind of need in order to
develop software in this case the cost of hardware, software and technical equipment are
considered.
Our system used hardware, software which are we used the Windows 11 operating system,
processor Intel® Core™ i5 CPU, RAM 4 GB, Hard Disk 500 GB, Front end and back end are
PHP and MySQL respectively. Therefore, we do not require costly hardware.
There is lot of security, accuracy and reliability in system by considering the above
reason the system is technically feasible.

Economic Feasibility:

Definition:

“Economic analysis is the most frequently used method for evaluating the effectiveness
of a new system. Most commonly called as cost or benefit analysis, the procedure is to
determine the benefits and saving that are expected from a candidate system and compare
them with costs.”

It is the study of economical benefits of this software. 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. If benefits outweigh costs, then the decision is made to
design and implement the system. An entrepreneur must accurately weigh the cost versus benefits
before taking an action. These websites save our money and time. By this website, we can buy
product in online. Today everybody is busy, so time saving is another important thing of our life

Economic feasibility consists of two types of cost are as follows:

 One-time Cost:

One-time cost may include:

1.Feasibility study cost.
2.The costs for converting from present system to new system.
3.Construction or remodeling of computer room/facilities.
4.Cost involved in software packages.

Operational Feasibility:

Definition:

“Operational feasibility in a measure of how well a proposed system solves the problem
and takes advantages of the opportunities identified during scope definition and how it
satisfies the requirements identified in the requirements analysis phase of system
development.”

Operational feasibility is a measure of how well a proposed system solves the problems, and
takes advantage of the opportunities identified during scope definition and how it satisfies the
requirements identified in the requirements analysis phase of system development
After implementing the system, the system-training program are arranged for the users. The
people who are familiar with information system as well as the techniques carry this out. They are
experienced persons like system analyst or managers. The cost of the training program as well as
space requirement for implementation of the system and the other assets are considered.
Therefore, our system is operationally feasible.

1.It is user-friendly system.

2.Does not require special training.

3.Provide better security.

4.Any user having technical knowledge or not can operate system.

.

ER Diagram
Data Dictionary
Admin
Field Name Data Type Size Constraint Description
A_email varchar 20 NOT NULL It store Email of
Admin
A_password varchar 10 NOT NULL It store
password of
Admin
A_confirmPassword varchar 10 NOT NULL It store confirm
password of
Admin

Tender
Field Constrai
Datatype size Description
Name nt
PRIMAR
T_id int 10 It store id of tender
Y KEY
It Store Tender
T_sector varchar 10 NOT NULL
sector
T_description varchar 10 NOT NULL ItStoreTender description
NOT
T_city varchar 20 It Store Tender City
NULL
NOT
T_date varchar 20 It Store Tender Date
NULL
NOT
T_time varchar 20 It Store Tender Time
NULL
NOT
T_status varchar 20 It Store Tender Status
NULL

vender
Constr Descriptio
Field Name Datatype size
aint n
Primar It store vender
V_id int 10
y key id
 NOT It store Vendor
V _name varchar 20
NULL Name
NOT It store Vender
V _email varchar 20
NULL email
NOT It store Vender
V_mobile varchar 20
NULL Mobile
NOT Vendor
V_charges int 10
NULL Charges

Employee
Field Name Data Type Size Constraint Description
E_name varchar 50 NOT NULL It store Name of
Employee
E_email varchar 20 NOT NULL It store email of
Employee
E_password varchar 10 NOT NULL It store
password of
Employee

Supplier
Field Name Data Type Size Constraint Description
S_user_id integer 10 PRIMARY It store user_id
KEY of Supplier
S_email varchar 20 NOT NULL It store email of
Supplier
S_password varchar 10 NOT NULL It store
password of
Supplier

S_address varchar 50 NOT NULL It Store address

of supplier
S_phone varchar 10 NOT NULL It store
phone of
supplier
Class Diagram
Object Diagram

Use Case Diagram

Activity Diagram
Sequence Diagram
Component Diagram

Deployment Diagram
 Implementation
Input and Output Screen
Home Page:

 Home page displays information vital and very important details of the system.

Admin Login Page:

 Admin Login page contains admin login credentials.

  Admin is master user of the system. Login page has a user name and
password which is for authentication.

Admin Dashboard:

New Tender:

This page is for create a new tender.

 View Vendors:

 This page is displays total number of vendors.

View Assigned Tenders:

 Add Notice:

View All Notice:

Delete Notice:

Update Admin Profile:

 Change Password:

Limitation And Enhancement

 This system is not supported for multicurrency.

 This system is available in limited area.
 This system is not supported for Multilanguage’s.
 Product view in not in video format
 Scope for future development

This software is used for E-Tender and posted tenders can be viewed anywhere
and anytime. Suppliers can ask queries immediately. Bidding online saves a lot of time
and buyers can answer queries posted by suppliers immediately. . a whole includes a
number of documents like conditions of the tender which includes the rules of the
tendering process and response, form of tender which includes schedules and details that
the supplier needs to include in the response, scope of tender which includes the details of
the goods and services required by the buyer, evaluation criteria which specifies how the
buyer assesses the responses given by the supplier, and conditions of contract which
includes the particulars of the legal contract that is to be awarded to the supplier.

Conclusion

Our project tender management system has successfully created a user friendly
environment in tender management process. our project is flexible and changes can be
incorporated easily. It is so designed that further modifications to the system can be easily
done.
 Reference

● stackoverflow.com
● dzone.com
● leetcode.com

Online References-
Mahatenders.gov.in