Over normalized. When normalizing, keep going until all redundant data is removed. Then look at results to see if usage would be enhanced/performance increased by some "denormalization".

If you always need the county AND state then they both should be in the data table instead of requiring a lookup to find the state.

Looks like the developer didn't perform final analysis.