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

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.

Step by Step Solution

★★★★★

3.33 Rating (174 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Explanation A MM relation exists between the Sales invoice table and the General Ledger table as fol... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

319-B-A-I-S (3536).docx

120 KBs Word File

Students Have Also Explored These Related Accounting Questions!

The following are general ledger accounts extracted from the records of Bernard Inc. at December 31, 2016, its year-end ('UB' = unadjusted balance): Required: Prepare in general journal format the...

Prepare budgetary entries, using general ledger accounts only, for each of the following unrelated situations: a. Anticipated revenues are $10 million; anticipated expenditures and encumbrances are...

The general ledger clerk receives summary data from which departments? What form of summary data?

I need help creating this; and I have already reviewed the one that is online through Chegg. Please don't copy that one because it appears that parts are missing; Defining Entities and Data...

Could you please help me with my assignment(I need both the flow chart and the business process diagram due on 9.12.2016 (6 pm) MS Television, Inc. Expenditure Cycle Flowchart MS Television, Inc....

Read the case below and answer the questions following it. DURAPLAST Company Ltd. DURAPLAST has experienced fierce competition from the large online discount stores such as related to its archaic...

In this class you will be required to create a course map as we move through the semester. Your course mapping project will essentially be the most important accounting concepts covered in this...

~~~~~please post an image of a complete Flowchart and BPD (business process diagram)~~~~~~ MS Television, Inc. Expenditure Cycle Flowchart MS Television, Inc. (MS) sells televisions, projectors,...

Brilliant Book Stores Berhad (BBB) is one of the leading books wholesaler in Malaysia. It is best known for its book supplies in bulk quantities as well as being involved in the printing, publishing...

A new school district is opening and recently hired a large group of new staff. The HR specialist is concerned that the hiring trends may have violated the 4/5 rule. The district hired 26...

5) You want to buy a new house. The bank is willing to make you a 30-year loan at 8% compounded monthly for 90% of the value of the house. How much is your down-payment if the mortgage payments are...

Describe the structure of carbon dioxide

: Responding to Inequity Think about a time when you experienced inequity in a work situation. How did you respond to the inequity? Could you or the organization have addressed the inequity in other...

Describe an internal control that would prevent the charging of depreciation expense to the maintenance department for a sweeper that is now located in and used by the engineering department.

What negative consequences result when fixed asset records include assets that the firm no longer owns?

The Gilead Science Corporation spent several years working on developing a product that can be used to provide a healthy supplement to a variety of food products. The benefits of a new supplement...

answer all pls! Question 31 What are the dividend yield, capital gains yield, and total required rate of return based on the following. PO = $14.00, D1 = $1.20, P1 = $16.00 6.15%, 15.38.%, 21.53.%...

An independent distributor bought a new vending machine for $ 2 , 3 0 0 . It had a probable scrap value of $ 4 0 0 at the end of its expected 1 0 - year life. The value V at the end of n years is...