Application for loan, Visual Basic Programming

Scenario

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  

Example;  

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

 Aim

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.).

Guidance

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
A constant is a meaningful name which takes the place of a number or string and never alters. VBScript described a number of intrinsic constants. You can get thorough information r

Each piece of data is passed in your process using an argument. Arguments serve like placeholders for the data you wish to pass into your process. You can name your arguments along

1. Create a new solution file named Ch03HandsOnProject1. 2. Rename the form and set the filename of the form to frmMain and frmMain.vb, respectively. 3. Set the appropriate p

Device Contexts: The Device Context (DC) is represented by the data type Handle to Device Context (HDC). The HDC is a handle to somewhat you can draw on; it can be the whole s

ARCHITECTURE OF WIN 32 PROGRAM   Figure: working of Win 3 program The hardware events in the figure are the mouse associated events like the mouse move, left


THE PRECOMPILED HEADER FILE As soon as you generate a blank project, ahead of doing any coding you compile the project to generate .pch (that is the pre compiled header) file a

Enabling ODBC: 1. Select the control panel, programs, setting and then ODBC32 2. Double click on the ODBC32 3. The Settings for an operating system will take place. 4

The user has to enter a starting balance, the dollar amount of deposits, and the dollar amount of withdrawals. the program then has to calculate the balance

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