Accounting Database Design
by Derek Liew
Discover the engine within the accounting system that runs the flow of transaction from data entry level to execution of stored procedure that controls your business logic. The professional accountant, database designer, application developer and software architect should discover these technical insights in order to design, develop and deploy a workable application across the organization.
The design and development of a practical accounting or business application is not impossible, but in fact, quite possible, if you know what are the nuts and bolts needed to execute the accounting system. The concept is similar for all business or accounting application, as generally all individual components or modules integrates and syncrhonize directly to the general ledger tables. Read below commentary for further details.
Learn the powerful knowledge of using queries (sql) to generate conventional profit and loss, balance sheet, cash flow or even bank reconciliation on the fly. There are no other technical books that provide the equilibrium knowledge of both accounting and sql programming needed in developing an in house customized business or accounting application. The chapters in the book are concise and practical. You will discover realistic tables required in a relational database structure, that stores important transactional information for your payables, receivables, assets, banking and journals. You will learn normalization concepts to building accounting tables, and identifying redundant fields in third phase of the normalization process.
Why is this book Important?
If you are the person who ask questions like, "What type of programming language is needed in order to develop my own accounting software or system", or "How to design tables for an accounting system", then you are looking at the right website. This book will widen up your knowledge in designing normalized accounting tables, to integrating them as a whole, thru referential keys. If you have been looking for answer for these two question within your social community or software development forum, just download a copy of the ebook format from the author's official website and go straight to the relevant chapters to find the solutions to your problems.
The tips and coding presented in each chapters is included for each sub modules, covering payable, receivable, cash management, inventory, asset management and general ledger. The author also encourage his reader to download the DES 1.2 software from his official wbesite (accountingdes.com) to try out the interface for each of the sub modules, in order to validate the integrity and effectiveness of the designed accounting database. User or readers should ensure they have SQL Server 2000 or SQL Express as the default DBMS before testing any of the examples documented in the book. If the user or reader has any queries to the book, the author welcome you to write in at email@example.com.
- Derek Liew, October 2010
- Download options:
- EPUB 2 (DRM-Free)
You can read this item using any of the following Kobo apps and devices: