Click here to Skip to main content
14,603,917 members
Rate this:
Please Sign up or sign in to vote.
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?
Updated 15-Apr-11 16:41pm
Rate this:
Please Sign up or sign in to vote.

Solution 1

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.
Mwanzia_M 15-Apr-11 18:12pm
Funny guy, do you reckon its an assignment?
Rate this:
Please Sign up or sign in to vote.

Solution 3

Thanks Friends. i will meet you again.
Richard MacCutchan 16-Apr-11 7:57am
Probably with the words "would you like fries with that?". :)
Rate this:
Please Sign up or sign in to vote.

Solution 2

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.

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

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100