Second normal form: the whole key

A column that is a fact about half of a composite key, as Kent's warehouse address is, and the split that gives it a key of its own, moving the rows with INSERT ... SELECT DISTINCT.