Tender Management System

Whenever a company requires a service / merchandise , a tender is floated. Company maintains an empaneled list of Vendors. An empaneled vendor can only bid for a tender. Every vendor can bid only once against each tender. Against each tender there may be bids from several vendors. The company will then select the most suitable bid and places the order to that vendor.

There are 2 users in the system

1. Administrator
2. Vendor

The Role of Administrator is:

1. Login with his account.
2. Register new Vendor. (assign a new username and password to him)
3. View all the vendors.
4. Create new tenders.
5. View All the Tenders.
6. View All the Bids of a tender.
7. Assign tender to a vendor.

The Role of a Vendor is:

1. Login with his account (username and password given by admin)
2. View all the current Tenders.
3. Place a Bid against a Tender.
4. View status of a Bid(Whether Selected or Not)
5. View his own Bid History.

Technology used

• Java
• MySQL
• JDBC
• Git & GitHub

Lessons Learned

• Gain excessive knowledge on application of Java, JDBC and MySQL.
• Enjoyed the process of learning and creating the application.

Overview of my work

ER Diagram

Users and Biding has one to many relationship.
Tenders and Biding has one to many relationship.

WorkFlow

Login method

forgot password method

Admin functionality

1. Register new Vendor
2. Register new Admin
3. View all the vendors
4. Create new tenders
5. View all the Tenders
6. View All the Bids of a tender
7. Assign tender to a vendor
8. See all biding details of a tender
9. Back
10. LogOut/Exit

Vendor functionality

1. View all the current Tenders
2. Place a Bid against a Tender
3. View status of a Bid
4. View Bid History
5. Back
6. LogOut/Exit

Feedback

Valuable feedback will be appreciated. You can reach out to me via below medium.

• Email
• Linkedin

Contributor

Mayank Gupta

GitHub