Pls help me...

any suggestions guys?

you need to be a bit more specific in what you're after

can you help me

depends it's what you mean by lending as there are numerous possibilities

My Prof. says "just a simple one" not the lending program of the bank system...Im just a STUDENT right now... ^_^

Well it sounds like your prof hasn't much in the way of understanding how lending underwriting works and is looking for an amortisation payment system for calculating the monthly payment. If you do a search for a mortgage monthly payment calculator on the web You'll get this no problem, and the test is to see if you're guilty of overthinking a problem.

However if he's wanting a decision making process for lending in simple terms then you want:

Client details
The customer wizard is enough for this

case table
Clients can have multiple applications on multiple properties so the only single entry is the application.

Property table
The client can have multiple properties to applications

Age of applicant
is the applicant over 18 and will be below 75 at the end of the loan

Income multiplier / affordability
Is the amount to be borrowed less than 3.5 times joint income? or the monthly payment / disposable income below 50%

Loan to Value
Is the loan amount / property value below 90%

Amount to borrow
Is the amount asked for within allowed lending limits

Credit Score
Is the clients' credit score high enough (use between 0 - 500 with 300 being a pass mark)

thank you sir for you kind answer ^_^

any suggestion about lending system to include to our scope and limtations in our thesis ,,thnx