Paul Bunyan is the owner of a wooden toy distributor named Blue Ox Distribution. He has decided to store his data in an electronic, relational database in order to ensure that it is current and accurate. Currently, he stores his data in a simple table, as shown on the last page of this handout.

1. Examine the sample data from the table. Using Figure 7.27 from the text as a template, identify the functional determinants and their associated dependencies. (25 points)
2. Using Figure 7.30 from the text as a template, convert the unnormalized table into First Normal Form (1NF). Explain the conversion process. HINT: When done, you will still have just a single table. (25 points)

Salesperson Number Salesperson Name Salesperson Number Commission Percentage Salesperson Number Year of Hire Salesperson Number Department Number Salesperson Number Manager Name Product Number Product Name Product Number Unit Price Department Number Manager Name Salesperson Number, Product Number Quantity Salesperson Number Product Number Manager Nome Product Name Urit Price Quantity 137 137 137 186 186 186 186 204 204 361 361 361 19440 24013 26722 16386 19440 21765 24013 21765 26722 16336 21765 26722 Salesperson Name Baker Baker Baker Adams Adams Adams Adams Dickens Dickens Carlyle Carlyle Carlyle SALESPERSON/PRODUCT table Commission Year of Department Percentage Hire Number 10 1995 73 10 1995 73 10 1995 73 15 2001 59 15 2001 59 15 2001 59 15 2001 59 10 1998 73 10 1998 73 2001 73 2001 73 20 2001 Scott Scott Scott Lopez Lopez Lopez Lopez Scott Scott Scott Scott Scott Hammer Saw Pliers Wrench Hammer Drill Saw Drill Pliers Wrench Drill Pliers 17.50 26.25 11.50 12.95 17.50 32.99 26.25 32.99 11.50 12.95 32.99 11.50 473 170 688 1475 2529 1962 3071 809 734 3729 3110 2738 20 20 73