I am not sure what your question is? However, the only idea I can surmise is you are missing a Locations table in your list and the location code "LocationID" should be a fixed char(6) field and not a varchar(10). Then you contacts table should have a LocationID foreign key to identify the location of each contact.
"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." -- Martin Fowler