Canada Moose€™s Supplies 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 3-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 rightmost columns, it cannot even be stored in a database system.

Requirements
Store this data in a spreadsheet to make it easy to manipulate. Then perform each of the following tasks in turn:
1. Reorganize the data in first normal form and print your spreadsheet. Why is your data in first normal form?

2. Reorganize the data from requirement 1 into second normal form and print your spreadsheet. Why is your data in second normal form?
3. Reorganize the data from requirement 2 into third normal form and print your spreadsheet. Why is your data in third normal form?

Transcribed Image Text:

Purchase Order Number Date Customer Phone Number Customer Customer Number Item Item Unit Quantity Ordered Name Number Description Cost Unit (752)433-8733 X32655 Baseballs 12345 01/03/2014 123-8209 Charles Dresser, Inc. $33.69 dozen 20 X34598 Footballs 53.45 Z34523 BballHoops 34.95 35.89 53.45 X67453 Soccer balls 45.36 dozen 10 each 20 dozen 10 01/03/2014 123-6733 Patrice Schmidt's Sports (673)784-4451 X98673 Softballs X34598 Footballs 12346 dozen 5 dozen 10