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?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
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.
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.