Download or read book Accounting Database Design written by Derek Liew and published by Authored by Derek Liew. This book was released on 2010-10-19 with total page 160 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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.