Ans:

System analysis: System analysis is a management technique which helps us in designing a new system or improving an exiting system. During analysis, data are collected on the available files, decision points and transactions handled by the present system. Some tools and techniques are used in analysis like data flow diagrams, interviews, on-site observations and questionnaires. System analysis was coupled to another practice known as structured Design (SD). Indeed, the two were often mentioned in the same breath as SASD.  SA described the data sets and data transformations implied by the requirements. As such, SA described what the system would do, albeit in very technical terms. On the other hand SD described the partitioning of the software into modules, and the flow of data between those modules. Therefore an SD was, more or less, a description of how a system would be structured to meet the requirements.

It is during this phase that the analysts the analysts and the user come to an agreement on what functions the proposed system has to perform. Following activities are performed during System Analysis.

• Inputs that must be received by the system.
• The outputs to be produced by the system.
• The data to be retained.
• The procedures to get the output from the given inputs.
• Audit and control requirements – This would specify the features/functions/procedures that are required for the user to monitor and ensure that the new system is working properly or not.
• System acceptance criteria – This would list the test that the user would actually perform to check if the system is acceptable or not.

This detailed document is called the Functional Specification or Proposed Produced. At the end of this phase the analysts should conduct a walkthrough with the user to review the specification for the various aspects of the analysis.

System design: System design is the process or art of defining the hardware and software architecture, components, modules, interfaces, and data for a computer system to satisfy specified requirements. One could see it as the application of systems theory to computing. Some overlap with the discipline of systems analysis appears inevitable. Based on the user requirements and the detailed analysis of a new system, the new system must be designed. It is a most crucial phase in the development of a system. Normally, the design proceeds in two stages:

• Preliminary or general design
• Structure or detailed design

Preliminary or general design: In the preliminary or general design, the features of the new system are specified. The costs of implementing these features and the benefits to be derived are estimated. If the project is still considered to be feasible, we move to the detailed design stage.

Structure or Detailed design: In the detailed design stage, computer oriented work begins in earnest. At this stage, the design of the system becomes more structured. Structure design is a blue print of a computer system solution to a given problem having the same components and inter-relationship among the same components as the original problem. Input, output and processing specifications are drawn up in detail. In the design stage, the programming language and the platform in which the new system will run are also decided. There are several tools and techniques used for designing. These tools and techniques are:

• Flowchart
• Data flow diagram (DFDs)
• Data dictionary
• Structured English
• Decision table
• Decision tree

Example of software design document for loan processing system with SRS

INTRODUCTION

• Requirements collection is crucial to the development of successful information systems. To achieve a high level of IS quality; it is essential that the SRS be developed in a systematic and comprehensive way. If this is done, the system meet the user’s needs, and will lead to user satisfaction. If it is not done, the software is likely to not meet the user’s reqruiemetns, even if the software conforms to the specification and ha few defects.

Purpose

The main purpose of developing the project is to computerize the Commercial bank’s-Home loans of a Commercial bank who provides a loan facility to common men in order to purchase their own houses. The main motive of making this software is to provide technical assistance and support to the Commercial bank employees. About the loan Plans, registration and calculations in order to sensation the loans. This software is important for Commercial bank, which provides loans to their clients. The House loan team will use the software as help by providing loan specifications, interest, customer and client testimonials and the survey conducted about the loan demand. The software also aims at providing the facilities like calculating monthly EMI, Repayment term monthly EMI on eligibility etc.

The information available on the software is confidential and thus it would be available only to the Commercial bank employees. Users and customers cannot directly interact with the software. In order to maintains the system security. Commercial bank employees will have the access rights to modify, delete and add any particular record. Commercial bank employees accepted the customer’s loan application by using the software that will have the loan application form. The forms data is transferred to the database in the form of record and an application number is generated by the system. The software would be implemented for Commercial bank’s internal use only and would be update from time to time.

Suggestion

• What are the factors that drive the Commercial bank Management people towards the computerized Commercial bank’s-Home loans?
• Does the computerized system of Loan assure an optimum standard of service tot he clients?
• What are different terms and conditions applied for taking loans?
• How EMI factor is maintained?
• How loan sanction is approved?

Outline Methodology

In this part of proposal we are going to highlight the methods adopted for obtaining the information necessary for the study. Research methods take many forms from analysis to it designing.

Analysis

In this part of proposal we are going to highlight the methods adopted for obtaining the information necessary for the study. Research methods take many forms from analysis to its designing.

Interviews

This stage will explore the Comical bank’s-Home loan’s requirements achieved by conducting informal interviews with different people of management at different levels.

Case study

In this stage the views collected during the interviews are studied as different cases for the possible implementation of a systematic loan system. Case study of the system leads to the proper system structuring and analysis together to review the collected information that is used during the designing. A detailed system design is performed using different design metrics to generate a flexible and quality product.

Planning In order to implements the design estimates are calculated over the work to be one over the Resources refried and over the time from start to finish.

Decomposing the techniques like performs estimates:

1. Estimating software size,
2. Estimating project activities
3. Stimulating software cost
4. Estimating manpower
5. Estimating software schedules

CONTEXT LEVEL DIAGRAM

Hardware Specification

• Random Access Memory : 250 MB.
• Hard Disk: 20 GB.
• Processor: P III, 1 GHZ.

Input / Output modules

Input / Output module	Description
Application form	Used as a loan application form filled by the clients via employees
Loan form	Used to handle the property details and loan amount
Guarantors details	Used as a security, filled with the guarantors details like income, address etc.
Loan eligibility calculation sheet	Cost sheet used to calculate the terms and conditions applied over the loan amount by taking certain EMI factors into consideration
Loan required	Used to take the amount of loan required
Check details	This particular module is used to check the over all details related to formalities required during the loan consignment whether they are completed or not
Searching	This module works as a search engine for this project where we can search the records using loan number and name as a search key

PROCESS LOGIC

Some of the important processing logic, which will be seen in this project, is as under:

• Proper connectivity between the Visual basic and the Oracle-8 in important.
• To build a huge database of the all the details like applicants, guarantors, property etc. all the database queries are based upon the database records. Multiple queries will be allowed.
• This processing logic we need to take care of validations. Validations are very important part of the project, without which the project is incomplete.
• Proper relationship between the fields has to be defined. Cascade updating and cascade deletion must also be present in this project.
• Graphical representation for the different entities will be shown.
• Printing care has to be taken.

Report Generation

Reports are generated based on the queries:

• Applicant details
• Property details
• Guarantors details
• Loan details
• Guarantors Commercial bank details
• Calculation of loan
• Loan sanction report
• Other based on queries.