Normalize the table to be in second normal form.
Employee Department DeptLocation
Joe Smith 1234 3333 Mocking Bird Lane, London, England
Mary Miller 1234 3333 Mocking Bird Lane, London, England
Tom Hanson 1072 1071 5th Avenue, New York, NY 10128
Sue Hass 0943 PO Box 1880, Tombstone, AZ 85638