Reorganize the data in first normal form

Assignment Help Financial Accounting

Reference no: EM131266381

Kick and Swing Inc. is a wholesaler of sporting goods equipment for retailers in a local metropolitan area. The company buys sporting goods equipment direct from manufacturers and then resells them to individual retail stores in the regional area. The raw data in Figure 7-21 illustrate some of the information required for the company’s purchase order system. As you can see, this information is characteristic of accounting purchase order systems but is not well organized. In fact, because of the repeating groups in the right-most columns, it cannot even be stored in a database. Question: Kick and Swing Inc. is a wholesaler of sporting go... Kick and Swing Inc. is a wholesaler of sporting goods equipment for retailers in a local metropolitan area. The company buys sporting goods equipment direct from manufacturers and then resells them to individual retail stores in the regional area. The raw data in Figure 7-21 illustrate some of the information required for the company’s purchase order system. As you can see, this information is characteristic of accounting purchase order systems but is not well organized. In fact, because of the repeating groups in the right-most columns, it cannot even be stored in a database. 466-B-A-I-S%20(7120)-1.png 466-B-A-I-S%20(7120)-2.png Requirements Store this data in a spreadsheet to make it easy to manipulate. Then perform each of the following tasks in turn: a. Reorganize the data in first normal form. Why is your data in first normal form? b. Reorganize the data from part 1 into second normal form. Why is your data in second normal form? c. Reorganize the data from part 2 into third normal form. Why is your data in third normal form?

Reference no: EM131266381

Questions Cloud

Compute the total variable cost and total fixed cost : Corio Corporation reports that at an activity level of 4,800 units, its total variable cost is $328,224 and its total fixed cost is $128,919. For the activity level of 4,900 units, compute: the total variable cost; the total fixed cost; the total cos..

Compute break-even number of barrels for the current year : Anheuser-Busch InBev Companies, Inc., reported the following operating information for a recent year (in millions of dollars): Net sales $39,758 Cost of goods sold $16,447 Selling, general and administration 10,578 $27,025 Income from operations $12,..

What will be her tax return for this year : Jane Brown married Jim four years ago. Two years ago Jim lost his job. After looking for work for several months, Jim left town to look for work, and Jane has not heard from him. She returned to work this year, and she earned $35,000. She has asked y..

Testimony includes sensory perceptions of fact witnesses : A forensic audit is more likely to use sampling than a GAAP compliance audit. Doors to interrogation rooms should be closed and locked during accusatory interviews. Hearsay testimony includes sensory perceptions of fact witnesses.

Reorganize the data in first normal form : Kick and Swing Inc. is a wholesaler of sporting goods equipment for retailers in a local metropolitan area. The company buys sporting goods equipment direct from manufacturers and then resells them to individual retail stores in the regional area. Re..

Means of verification of cash-inventory-office equipment : The best means of verification of cash, inventory, office equipment, and nearly all other assets is a physical count of the units; only a physical count gives the auditors complete assurance as to the accuracy of the amounts listed on the balance she..

What is the net realizable value of the receivables reported : Becky had net sales (all on account) in 2017 of $800,000. At December 31, 2016, before adjusting entries, the balances in selected accounts were: accounts receivable $1,000,000 debit, and allowance for doubtful accounts $2,000 debit. Becky estimates ..

Paid-in capital–stock options : Pastore Inc. granted options for 1 million shares of its $1 par common stock at the beginning of the current year. The exercise price is $32 per share, which was also the market value of the stock on the grant date. The fair value of the options was ..

Shopping for accounting principles : Discuss what is meant by the phrase “shopping for accounting principles.” What mechanisms have served to prevent this practice by management?

User Account

All Pages