(Solved) : Looking Help Question Thanks Help Ve Asked Help Fix Legacy Database Might Issues Causing D Q27985352 . . . .

Looking for help of this question!!

Thanks for any help!!

You’ve been asked to help fix a legacy database where theremight be some issues causing data integrity problems. For eachtable below identify the normal form of the data shown andexplain how you made your determination. If there are otherproblems evident in the table that you would need to fix to reach3NF, note these as well. In the table headings, * denotes primarykey and † denotes a foreign key in the legacy database. (20points)

T_Bear

BearID*

BearSubSpecies

BearCommon

BearRange

1

Ursus americanus altifrontalis

Olympic black bear

BC, CA, ID, OR, WA

2

Ursus americanus amblyceps

New Mexico black bear

AZ, CO, NM, TX, UT

3

Ursus americanus americanus

Eastern