Main Article Content
relational database, accounts receivable, database design
Database designers face certain challenges in seeking to derive accounting numbers, such as accounts receivable, from an events-based relational database system. An ideal solution would record raw events uniquely in events tables, where the data are nonredundant and normalized. The actual implementation of this solution is not trivial, but it can be a rewarding exercise.