Accounting Information Systems 8th Edition by James Hall

Exercise 35

DEFINING ENTITIES AND DATAMODELING- GENERAL LEDGER
Required
Prepare an ER diagram that illustrates a normalized data model for a general ledger update process. Base the model on a sales order system that updates sales transactions to the GL in real time from sales invoices. The model should allow an audit trail that links the summary accounts in the GL to specific transaction records. Show all attributes, primary keys, and secondary keys.