Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am building an application which has deposit and loan accounts management, for which i have to develop ledger accounts and then generate balance sheet. Being new to database design, i am having a hard time in designing the database model best suited. Is there any standard model for the database design of accounts(especially ledger) which can used?

share|improve this question
3  
AFAIK ledgers are quite special in a few ways (storing decimal values comes to mind first). Are you sure you want to develop an _n+1_st ledger having all the other _n_s around? Since this is a rather sensitive field (an error could cost someone much money), with no DB design experience I would not dive into this. Maybe you'd better hire someone with sufficient experience? –  dezso Jan 25 '13 at 5:30
add comment

2 Answers

As to what dezso said, ledgers are quite special depending on the business that is using them. You can try looking at other opensource applications with the same features and functions as your program if you're looking for a basis for your database.

You can look for some opensource projects at Ohloh.net and Github.com

But as a fellow application developer, I would suggest you take the time to read up on some basic database design best practices and principles. And a bit of normalization, at least up to the Third Normal Form. Having a faulty database can give you a lot of headaches in the long run when maintaining your application. Refactoring database changes aren't that easy with a mature program.

share|improve this answer
add comment
up vote 0 down vote accepted

I got a file on the web which solved my problem with quite ease. Check this link out this might be useful to anyone who has this same prob Database for Accounting.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.