All we need in the primary table is the state and county foreign keys.[1] It looks like someone had just taken a class in normalization and went a little bit crazy.




[1] Actually just the county one, because the state is encapsulated within it, but I don't want to get Scott started again. ;)