Question

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.