Staff mutual benefit fund deals the information regarding  loan transactions of staff members in a college. it also stores the information regarding payments done by the staff members. Before the information stored in text based records like files, records etc it was very tedious process to search information regarding staff members. This project provides various search criteria’s so that information could be searched in fraction of seconds which is less time consuming and reduces the man power. This document has Staff Mutual Benefit Fund Project Report.

The project entails “Staff  mutual benefit fund” is developed using visual basic.net as front end and SQL for database in back end to computerize the process of staff mutual benefit fund. This project covers only the basic features required.


Staff Mutual Benefit Fund Project Modules

  • login : we have a single user and he has to enter the user name and password  to use the application.
  • membership : it holds the information regarding the members of  that committee admin could add,delete,update the member information.
  • Applicant details: it holds the information regarding the members who has applied for the loan.
  • monthly installment: it holds the information regarding applicants monthly payment of loan with interest & service charge.
  • yearly installment: it holds the information regarding applicants monthly payment of loan With check details.

Table Design of Staff Mutual Benefit Fund

tbl_member

Field Name Data Type Constraints Description
name Varchar(50) Not null Name of the applicant
Name_id Numeric(18,0) Foreign key Personal identification number
Dept Varchar(20) Not null Department of the applicant
Address Varchar(50) Not null Address of the applicant
Phone_no Numeric(18,0) Not null Phone number of the applicant
Mem_amount Numeric(18,0) Not null Membership fees

tbl_ applicants_loan_details:-

Field Name Data Type Constraints Description
App_name Varchar(50) Not null Applicants name
Name_id Numeric(18,0) Primary key Personal  identification number
Dept Varchar(20) Not null Department of the applicant
Purpose Varchar(50) Not null Loan purpose
Amount_req Numeric(18,0) Not null Loan Required amount
Apply_date Varchar(10) Not null Applied date for loan
Place Varchar(20) Not null Place
G1 Varchar(20) Not null Surity holders name 1
G2 Varchar(20) Not null Surity holders name 2
Amount_sanc Numeric(18,0) Not null Loan amount Sanctioned
Sanc_date Varchar(20) Not null Loan Sancationed date
C_nos Varchar(20) Not null Number of cheques
Secretary Varchar(40) Not null Secretary of the commite
President Varchar(40) Not null President of the commite

tbl_monthly_cheque_details

Field Name Data Type Constraints Description
Dept_name Varchar(50) Not null Department of the applicant
Acc_no Numeric(18,0) Foreign key Account number of the applicant
Cheque_no Varchar(20) Not null Number of the cheques issued
Year Varchar(50) Not null Year of repayment
Month Varchar(50) Not null Month of repayment
Amount Numeric(18,0) Not null Amount to be repayed in a month

tbl_installment

Field Name Data Type Constraints Description
App_name Varchar(50) Not null Applicants name
Cheques Varchar(20) Not null Number of cheques issued
Year Varchar(50) Not null Year of repayment
Amount Numeric(18,0) Not null Amount to be repayed in a month

DOWNLOAD Staff Mutual Benefit Fund Project Report


Note: We have shared lots of project report in the PROJECT REPORT section. Download it for reference purpose.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.