USE 3NF to make it become relational schema .

2. You've been asked to help fix a legacy database where there might be some issues causing data integrity problems. For each table below identify the normal form of the data shown and explai how you made your determination. If there are other problems evident in the table that you wo need to fix to reach 3NF, note these as well. In the table headings, * denotes primary key and t denotes a foreign key in the legacy database. (20 points)4 T Bear BC, CA, ID, OR, WA AZ, CO, NM, TX, UT Canada, OR, WA, CA, ID, MT, CO, UT, WY, AZ, NM, TX, AR, MO, LA, AL, MSFL, GA, SC, NC, VA, WV, PA, NY, NJ, DE, VT, NH, MA, CT, OK, MI, WI, MN 1yrus.amerisanu altifrentalis Olympic black bear New Mexico black bear Eastern black bear 5 reus.aunetisaaya saliteroisosis California black bear. CA, OR AK, BC ID, MT, OR, UT, WA, WY Haida waii black bear inoamgumCinnamon bear 10yHs.amerisanEeDsii Glacier Bear. Mexican black bear Florida black bear Newfoundland black bear Spirit bear Louisiana black bear. West Mexico black bear Kenai black bear Dall black bear Vancouver Island black bear N.M., Tx. AL, FL, GA NL 12yreus.amerisanue filoridanus 15rus.amerisanus Jutealus LA, MS, TX N. Mex.. 20 yrus.amerisanuE vapsouve Normal Form: Explanation: T Food Availability 1Grubs 2 Salmon 4 Trout 5 Cedar Bark. 6 Grass 8 Roots 9 Honey 10 Bees Normal Form: Explanation