Application for loan, Visual Basic Programming


GetLoan is a new company that will provide a loan of money to individual members of the public.  

There are two types of loan to be offered:

  • Secured Loan where the sum loaned is secured by either an asset that the customer can provide or by a person who will act as a guarantor for the loan.
  • Unsecured Loan where the customer does not have a means to secure the loan but as a consequence the interest rate of the loan will be higher.

A secured loan can be had on either a long term or short term basis.

Long term means 2 years up to 10 years, short term means less than 2 years

An unsecured loan can be had only on a short term basis.  

Rates of Interest

The rate of interest can vary  on all loans throughout the period of repayment however all rates are computed from a monthly base rate (B%) as defined by the management of GetLoan.  

Secured loan

Y = The year number of the repayment period.  

The monthly rate of interest is computed as 5*B/Y  


B = 1.2%

Y = 3 (In the third year of the loan period)  

Actual monthly rate = (5*1.2/3)% = 2.0%  

Thus if at that time the amount of the loan outstanding is $3745.00 then the interest payment for that month is 2.0% of $3745.00= $74.9  

Unsecured loan

Here the monthly rate does not decrease with time.  

The monthly rate is always 6*B.  

Hence for the example above the monthly rate would be 7.2% throughout the period of the loan.  

NOTE the management may wish at any time to change constants in the formulae that compute these rates.

Thus these constants should be part of the definition of the type of loan and be editable by maintenance processes.

Repayment of Capital

The customer will agree to pay off a fixed amount of the capital each month. Hence the actual payment per month will be this fixed amount plus the actual interest for that month.  If the monthly base rate is constant and the customer pays all that is due then each month the actual payment per month will reduce for both types of loan.   

If the customer defaults on a monthly payment then the default amount is added to the outstanding capital. An increased monthly capital payoff amount will then be computed. (You are not concerned how the detail of the change is communicated to the customer.)   

GetLoan will require a computerised database system to run this business.  

The database will require at least three tables:  

  • Types of Loan
  • Customer Detail
  • Loan Account


To produce robust software that meets the requirements detailed in the Introduction. Although the recommended textbook gives adequate coverage of the fundamentals of Visual Basic any particular assignment may require candidates to investigate other aspects of the language by using the Help facility provided by the Integrated Development Environment of Visual Basic or other references.  

Notes on design and implementation

The database will be served by a number of user interfaces.

These interfaces will include: 

  • Registering a new customer.
  • Maintaining customer details.
  • Setting up the details of a type of loan.
  • Maintaining the types of loan.
  • Viewing selections from the Loan Account table.
  • Entering payments.

All these user interfaces will involve comprehensive data validation.  

Note that this validation must be achieved via VB program code and not set by criteria in the DBMS used.

The Loan Account table will have to involve some computed fields. Careful consideration is required concerning the types of selection that will be required from the Loan Account table. Security will have to be considered.

Although the recommended textbook gives adequate coverage of the fundamentals of VB 2005 any particular assignment may require candidates to investigate other aspects of the language by using the Help facility provided by the Integrated Development Environment of VB 2005.  

Task 1

Design the database structure required.

Using either Microsoft Access or SQL Server set up this structure.

Alternatively you could produce a simple file based system  

Task 2

Design the user interfaces required.

Include the design of the algorithms of all the data validation required.

Include the design of the algorithms required for selection and security.  

Task 3

Implement and test the designs detailed in Task 2.

 Task 4

Design suitable test data for all the elements of the database.

 Using the user interfaces already implemented populate the database with the test data.

 Task 5

Carry out comprehensive system testing. Produce evidence of this testing including screen shots.

 Task 6

Produce a publishable working copy of a compiled version of the completed assignment together with some installation notes. The installation notes should include the system requirements.

This publishable copy, that includes a setup file, should be on an appropriate medium (zip disk, CD-ROM, DVD etc.).


The assessment of your project will to a large extent depend upon the quality of the documentation that you have produced. Thus, for each stage of the development of software:

  • Give a detailed design including, where appropriate, the design of any algorithms
  • Build in error handling to involve meaningful messages that would ease any future maintenance of the software
  • Annotate all implementation
  • Design a testing strategy
  • Design comprehensive test data
  • Show evidence of testing
  • Where appropriate, detail any major remedial action that you have taken in the light of the testing process.


Posted Date: 2/27/2013 1:14:15 AM | Location : United States

Related Discussions:- Application for loan, Assignment Help, Ask Question on Application for loan, Get Answer, Expert's Help, Application for loan Discussions

Write discussion on Application for loan
Your posts are moderated
Related Questions
INTRINSIC CONTROLS   The Intrinsic controls are the built-in controls. Few of the controls are Combo box, Check box, Command Button, Label etc. The controls have properties re

FEATURES OF USER INTERFACE DESIGN The features like how will the software's are used? Who will be the users? What will be the life of the software? During its lifetime how ofte

A Project to Display a Database: 1. Suppose that there are 5 fields describing a customer. Id, address, name, city & state. 2. Put 5 text boxes on the form to exhibit the r

VISUAL INTERFACE DESIGN Instead of the graphic nature of the program, only the visualness of the inter action is important. The program must not focus on the GUI. On the other

Using Visual Studio 2010 C++ 1) Using Windows Explorer, make a copy of Irvine\examples\Project_sample folder in the folder where you keep your materials for this course.

Create a project that draw a rectangle shape which may be either (*) or (+) according to the selected radio button. The number of rows in the shape will be taken from the 1 st

MULTIPLE DOCUMENT INTERFACE (MDI) WINDOWS   The SDI (Single document interface) supports one open window or document at a particular time. Microsoft's notepad and paint are il

to dial a person''s 10 digit number and assign it to their name

A triangle is equilateral if all three sides are equal, isosceles if any two (but no more than two) sides are equal, and scalene if no two sides are equal. A triangle will be input

Problem 1. Describe the importance and usage of .net framework in visual Studio 2. Write a program to sort and display an array of integers in ascending order using the conc