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.