Abstract
The system mainly deals with the automation of the activities performed at Small Industries Development Bank of India (SIDBI), which issued various kinds of loans to their Customers and accepts monthly installments from them.
All the master information is gathered pertaining to the employees working in the organization, Industries to whom the loans are issued. Different types of loans available are designed and the interest rates applicable are set in the master tables.
Initially after registering the customer, loan is sanctioned according to his requirement and eligibility. Details of a particular loan are gathered such as loan number, customer number, loan code, amount, interest, and number of months, monthly installment and date of sanction.
When the Industries pay the loan installments, details of loan number, payment id, amount and date of payment are gathered and stored.
Simply choosing the appropriate menus such as Employee details report, Customer details report, generates various reports, Loans detail report, Interest report, Customer-loan details report & Payment details report.
The system security is taken care of by a login form, which is allows only authorized users to utilize the system.
The main aim/objective is to develop an effective system, which is fast, accurate, consistent, reliable, and flexible enough so that it can accommodate any further expansion.

IDENTIFICATION OF NEED
Every thing is done manually at present such as customer registration, issuing loans and keeping track of payments.
As the number of customers is high and the risk involved in the transactions due to huge amount involved, the manual system was considered to be inefficient due to huge amount involved, the manual system was considered to be inefficient due to the volume of errors & lesser security.
First when a customer comes to the company he has to be registered and in the manual system it is difficult to verify whether he is already registered. But in the computerized package it would be very easier to check all the customer details.
When a loan is sanctioned to a customer, calculation of monthly installment is done manually in old system, which may result in wrong monthly installments. Where as in the automated system, it is exactly calculated according to the number of months and the interest rates applicable.
Also payments from the customers is difficult to maintain which is could be made easier in the computerized package in which simply by entering the loan number all the other information is displayed.
Therefore the problems in the current system have forced the firm to automate it by developing a software package, which would reduce their problems and increase the efficiency.
PRELIMINARY INVESTIGATION
The current project integrates the following and centralizes all the activities into a single application.

MASTER INFORMATION MODULE:

This module gathers all the master information regarding:
The employees working in the firm such as employee number, name, organization, designation, monthly salary and address.
Industries who take loans from the firm such as customer number, name, organization, designation, monthly salary and address.
Various types of loans available with loan code and description.
Different categories of interest rates applicable for loan amount with interest code and rate of interest.
Userâ„¢s maintenance details such as user name and password.


LOANS MANAGEMENT MODULE:
Firstly after registering the customer, loan is sanctioned according to his requirements and eligibility. Details of a particular loan are gathered such as loan number, customer number, loan code, amount, and interest, number of months, monthly installment and date of sanction.

REPORT GENERATION MODULE:

The system is designed to display and print the following reports, which are called by selecting the appropriate menus:
A) Employee-details report
B) Customer details report
C) Loans details report
D) Interest report
E) Customer-loan details report &
F) Payment details report. Etc.
SOFTWARE AND HARDWARE SPECIFICATIONS
SIDBI is a network-based application. When we talk about hardware and software, we have to mention requirements on both the Client and Server part.
¢ Internet connection with 33.6 KBPS Modem.
¢ Pentium 1.0 MHz. 60 GB HD, 512 MB RAM (Server).
¢ Any P.C with Windows/Unix compatibility, 128 MB RAM (Client).
¢ Tomcat Web Server, running on any platform.
¢ JDBC/ODBC drivers installed.
¢ Servlets 2.0 and JSP
¢ Functional Java enabled browser.
¢ Data Base (Oracle 9i).
¢ Operating System (Windows/Unix/Linux).