Martha Greengage Foundation Project

1
Martha Greengage Foundation Project

• Tim Thompson
• Robert Morrill
• CS 308
• November 3, 2008

2
Goals

• MSB is concerned with assisting consumers with
  the purchase of homes to improve their lives
  versus profit for the foundation.
• The business model will lend itself towards low
  overhead through the computerization of the
  foundation.
• Properly granting mortgages is the ultimate goal
  of this software

3
System Functions

• The application Process will utilize a web
  browser where the bowerer will enter his or her
  financial information and value of home and
  determine eligibility of applicant.
• Mortgage Account Creation will allow the mortgage
  account to be created once the home is closed
  upon.
• Mortgage Account Maintenance will allow the
  mortgage company to reflect payment, flag late
  accounts, and close the account when the balance
  is zero

4
Data Objects

• User is the base class for all level of users.
  This class will allow the user to interact with
  foundation database
• Employee is linked through inheritance to the
  user class. Can create new accounts, post
  payments, and close accounts.
• Applicant is linked to the inheritance to the
  user class. The information submitted is used to
  create an application object.
• Borrower is linked through inheritance to user
  class. Allows user to view information
  pertaining to their mortgage stored in the
  database

5
Data ObjectsContinued

• MSG Database keeps track of the amount of funds
  available to loan to applicants. When payments
  are made the payment is added to the available
  funds.
• Application Database will keep track of
  applications submitted, if loan is approved the
  employee class will be used to create the
  mortgage account in the database.
• Mortgage Database will keep track of current
  loans. The loans are stored in objects in
  structures. Will include flagging delinquent
  accounts and closing accounts when balance is zero

6
Class Diagram
7
Architecture Diagram
8
Architecture Design

• This software will implement a standalone java
  application and if time permits we will attempt
  to make a web application
• The database layer will make usage of the java
  database connectivity to connect to the database.
  Using this feature it will allow us to access
  SQL commands. We will use ODBC which is a
  standalone generic database connection which
  works with almost all databases.
• The application layer will be controlled by user
  interface, this portion will be independent of
  the databases.
• Access layer will be compatible with Windows,
  Linux, and Macintosh computer systems. Security
  will be maintained by software administrators
  including usage of user names and encrypted
  passwords.

9
Class Functions and Details

• User
• userType
• This variable keeps track of the user type.
• userName
• This variable keeps track of the user name.
• password
• This variable keeps track of the users password.
• Applicant
• enterIncome
• This function allows the user to enter their
  yearly income.
• enterPriceOfHome
• This function allows the user to enter the price
  of their desired property.
• enterName
• This function allows the user to enter their full
  name.
• enterTerm
• This function allows the user to select a term
  for the mortgage.

10
Class Function and Detail Cont.

• Borrower
• printStatement
• This function prints the monthly statement of an
  individual mortgage account.
• printAmortization
• This function prints the amortization for an
  individaul account.
• Employee
• createAccount
• This function allows the user to create a new
  mortgage account.
• postPayment
• This function allows the user to post a paymnet
  made by a borrower to their mortgae account
• closeAccount
• This function allows a user to close an account
  once the balance is zero.

11
Class Function and Detail Cont.

• MSGDB
• msgCapital
• This variable keeps track of how much money is
  avaiable to loan.
• checkCapital
• This function checks the avaiable funds to
  determine if sufficent funds exist to loan to a
  potential borrower.
• updateCapital
• This function updates (either due to cash inflow
  of outflow) the available capital.
• ApplicationDB
• processLoan
• This function compare the applicants income and
  price of desired home and deciedes if a loan is
  allowable. This function sets the approved
  variable in an Application object

12
Class Function and Detail Cont.

• LoanDB
• checkDeliquency
• This function checks once a day to determine
  which (if any accounts are deliquient.
• Loan
• dueDate
• This variable is the current due date for
  payment.
• balance
• This variable is the current balance of the
  account.
• userName
• This string holds the user name.
• deliquency
• This boolean vaule keeps track of the acounts
  late status.

13
Important Algorithms

• processApplication (years, yearly income, price
  of home, interest rate, insurance payment)
• approved false
•  
• monthly income yearly income/ 12
• monthly payment interest rate ( interst
  rate/ (1 rate(year12)) -1)
• monthly payment monthly payment insurance
  payment
• acceptable monthly income .28
•  
• if allowed gt monthly payment
• do approved true
•  
• printAmortization(years, principle, interest
  rate, monthly payment, date)
•  
• months years/12
• while (months gt 0)
• print due date date, balance balance

14
Important Algorithms Cont.

• checkDeliquency(due date, current date, Loan)
• If (current date gt due date)
• do deliquency true
•  

15
Database Design
16
Database Design
17
GUI Interfaces