Make your own free website on

System Analysis            System Design             System Testing         System Introduction 




2.1 Preliminary Investigation

2.2 Methodology



2.1  Preliminary Investigation:

2.1.1 Objective

            The objective of the project is to develop Loan Management System for Bangladesh Shilpa Bank, which will maintain the total system in computerized way and generate required report that are very essential in every single manner. Beximco Computers assigned this module to me.

            One of the major activities of Bangladesh Shilpa Bank is to provide financial assistance to projects in different sector for industrialization. From different branches huge amount of loan information comes to the Loan Department (LD). LD maintains all the information. At present they are keeping the entire information manually. LD is using some application software’s like MS Excel, MS Word but the use is very limited and do not fulfill their all requirements. So the new system will flexible and time consuming.   

2.1.2 Scope:

My project is to develop a computerize Loan management System for BSB, which will automate the process of Loan Department.

The scope of the proposed solution contains:

q             Providing security to the loan information data.

q             Minimizing the large documentation.

q             Making calculations easy.

q             Easy maintains of Data 

q             Reducing the extra manpower and overhead work.

2.1.3 Constrains:

There are some constraint on this project, those are:

§         As the current system is completely manual, making it automated need lot of time by realizing the existing system. The time limitation is one of the greatest problems in this regard.

§         The system will process lots of transaction. So the calculation part must be reliable as much as possible.

§         In this organization, there are so many senior employee, who are not familiar with computerized system and they are not interested to develop a computerized system.

§         Most of the employee does not have good knowledge about computer. That’s why some of there expectations are unrealistic. 

§         It’s a government organization. So most of the information is scattered.

2.1.4 Functions of the information system:

              A system function is an activity or process. The proposed system is composed of the following components:


                  The loan department keeps detail information about loan. So the key input for the proposed system will be Loan number, Project information (Id, Name, Branch), Sanction amount, Disbursement information (Amount, Date), Cycle code, Interest amount, Repayment information (Amount, Date), Receive information (Amount, Date), Re-phased information (Old loan no, New Loan no, Debit amount, Credit Amount) etc. Which comes from the user.


                      After collecting data, they classify those data into separate files for each Loan. There are lots of calculations for every single transaction. If a transaction occur than they maintain the balance by debiting and crediting. They also perform calculation of sanction amount, receive amount etc and keep this information in day-to-day basis report and also create monthly and yearly reports.

·        Output:

                        Loan Department produces different types of daily, monthly, quarterly and yearly branch wise reports about How much money is given as loan, How much money will be received, how much money is received and how much money is left etc. 

·        Storage:

                       The system that I have designed is for network environment. So many user can use this application but the data storage will in the server pc only. The server pc will contain the database and the user will use their own password to enter the database from their pc for storing data.

·        Control:

                        In their information system they try their best to keep accurate data to maintain their standard and level. Also they provide a facility of data security and changing of data. They always verify the project’s information. Like they check whether the address or contact no of project is correct or valid. They also verify the transaction. They confirm that all the Balances are figured out accurately. They also ensured that information saved in files is kept consistent by some special naming system. They also make sure that important files are kept in a secured place.

2.2 Methodology

2.2.1 Introduction:

              Methodology is a systematic description of the sequence of activities required to solve a problem. In other word, Methodology is a collection of procedure, technique, tools and documentation aid which helps the system developers in their effort to implement a new information system.

            For the system development, I have used structured system development – Software Development Process. In system development I used the Structured Analysis methodology, which is based on process modeling. Here I used Fact Finding Techniques for requirement analysis. For process modeling Data Flow Diagram (DFD) was used. My DFD is based on Gene and Sarson method. I used Entity Relationship Diagram to do Data modeling.

2.2.2 System Development Process:

                        I have used the traditional system development technique. For my system development I have used different phases of system development process:

·        Preliminary Investigation

·        System Analysis

·        System Design

·        Coding

·        Testing Preliminary Investigation:

                    At this Stage I had to perceive the problem and opportunities. I went to the Loan Department to review existing system. I had to find out initially what the Loan Department’s activities and problem have been, and whether those could be resolved through available techniques known to me. Then I established the scope, preliminary requirement and constraints of the proposed system and project schedule. I found out that, such proposed system would be possible to make within given scope and it might be a feasible solution for the company. System Analysis

                      At this stage of System Development Process I studied the existing system and tried to find out the requirements of the proposed system in details. I found out what is the purpose of the Loan department’s activity, what are the steps performed in loan department, how, where, how long and how often are they performed, how great the volume of transaction, who use the resulting information, what are the constraints, what is the input of each process and what are the outputs. I found out whether the proposed system would be feasible or not, what will be user requirements, report requirements. There are three types of fact-finding techniques-

1.      Interview

2.      Record review

3.      Observation

 To perform requirement analysis, I used the first two fact-finding techniques.



1. Interviews:

                      Interview is a formal meeting where the analysis can obtain information about the operation of the present system and the requirement for the new system. This is the most common method used to verify the proposed system design and gather fact about the procedure. For interview I went to the Loan department section and asked my selected question to different employee of that section.

                My candidates to be interviewed were senior officer, General Manager and Deputy General Manager. For the interview purpose I used both structured and unstructured questions. I used both structured and unstructured questions based on my system. I had to carefully ask the question so that they must relevant to the interviewee and appropriate to his level and status. My supervisor and the project manager provided different kinds of information and requirements during the interview.

Meeting Minutes for interview is given in Appendix A at the end.

2.  Record Review:

      Record review is to review the documents that represent formal information flow in the organization. Record includes written policy manuals, regulations and standard operating procedures. The loan department is divided into two main section they are the not due section and over due section, both section maintain ledger book to keep regular entry. I reviewed both the ledger book and also reviewed some report, which they produced by Ms Access or Ms. Excel

· Not Due Loan Ledger

            This ledger book keeps most of the information of Not Due section. The project name, address, loan no, Amount sanctioned, Repayment schedule information, Disbursed information all are recorded in this ledger book. This section maintains one ledger book for one branch. Same kind of ledger book is used for foreign currency and Taka loan.

        ·Over Due Ledger Card

     This ledger Card is used in Over Due Section. All kinds of pay-received information are recorded in this ledger card like- Principal receive, Other charge receive, Interest on loan balance, Value date, Transaction date etc.

    ·Section Summery Repot:         

                     This is a computerized report, which shows the sections wise balance of amount due. They produce it using Ms. Excel.

        ·Balance Conformation Certificates:                  

          This is an annual conformation, which is send to the client. It contains both not due and over due balance of closing date. 

        ·Currency Disbursement Report:

          Its shows Branch wise Local Currency Disbursement. Ms. Excel is used to generate this report.

Some Record review documents are given in Appendix A at the end. System Design:

After finishing the analysis part, I started the designing phase of System Development Process. In this part I used both logical and physical design. For logical design – I used process modeling by DFD (Data Flow Diagram) and data modeling by ER-D (Entity-Relationship Diagram). I also used Data Dictionary and Rich Picture for my design part.

Here I tried to implement my findings, which I got in System Analysis phase by DFD and ER-D. How the system would work and how the output will be given was the main concern at this level. In logical design part-for the-I used Oracle 8i for the database design and for front-end design, I used developer 6i. Coding:

           Coding is the heart of software development. After the designing phase, I got up to coding. For Development of my project I choose Oracle, as it is very much suitable for building database applications quickly and effectively. The total project took up 18 windows forms. Testing

            After the development of the software had been finished, it went for testing. There are two types of testing-White Box and Black Box testing. I had done only Black Box testing for my software. After testing I found a test report and later on, I fixed those error according to report. Some new requirements were imposed and enhancement request was made. My development process was stopped after testing.