Click here to Skip to main content
15,896,201 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
Hi Friends,

I need to create a loan application and also i should maintain min 3 years history in database using c#, oracle but even i can't figure out the design.

Can you tell me any sample project or forms available for reference give some suggestions?
Posted
Updated 15-Apr-11 16:41pm
v2

If you don't know that you should be asking your client all of these questions on how to design THEIR application that follows THEIR business processes, no sample app that anyone shows you is going to help.
 
Share this answer
 
Comments
Mwanzia_M 15-Apr-11 18:12pm    
Funny guy, do you reckon its an assignment?
Thanks Friends. i will meet you again.
 
Share this answer
 
Comments
Richard MacCutchan 16-Apr-11 7:57am    
Probably with the words "would you like fries with that?". :)

I have to agree with Dave, the only way you can design such an app is by first talking with your client and see what they need to automate their loan business. You need to know how the business works inside out so do a little research. Why not start by going to the premises and see how things are done? You may need to study the documents used in the business so as to get an understanding of the input requirements.
After doing an analysis of the business take time to design the database in terms of the tables that you will need to such as : payments table and borrowers table(containing info about borrowers such as name,contacts etc) to name just but the bare essential tables . Set up the relationships well then design any queries that you may need.
When your database is in order sketch designs of how input and output will be handled by the application before doing any coding.There is nothing as bad as discovering you've left out something and fixing it. somewhere may cause chaos.
Armed with your sketches create the user interface (don't be concerned with nice graphics coz you can play with this after your app works). Show your designs to the client to see if they r ok with it before you start coding, after all,why code something that they don't like? If you get the green light do the code and finish off with polishing the interface.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900