I enjoyed this article a lot. There's a lot to be gained from learning by making mistakes, so your intro to your series is good.

I'm looking forward to reading...

Great points in extending the data by everyone.

If we're working with just the tables in the question, you could replace the StateID column in the City table with a CountyID...