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.

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?

Transcribed Image Text:

Purchasing agent Order goods Merchandise inventory Vendor Receive goods Receiving clerk Pay for goods Cashier or A/P clerk Cash FIGURE 7-20 An E-R diagram for the purchasing system of Clooney and Bullock Manufacturing Purchase Order Number Date Customer Customer Number Name Customer Phone Number Item Item Number Description Cost Unit Ordered Unit Quantity 12345 01/03/2011 123-8209 Charles Dresser, (752)433-8733 X32655 Baseballs $33.69 dozen 20 Inc. X34598 Footballs 53.45 dozen 10 Z34523 Bbal Hoops 34.95 each 20 12346 01/03/2011 123-6733 Patrice (673)784-4451 X98673 Softballs 35.89 dozen 10 Schmidt's Sports Footballs 53.45 dozenf5 X67453 Soccer balls 45.36 dozen 10 FIGURE 7-21 Some purchasing data for Kick and Swing.