Here’s a hot tip, boys and girls: never try to normalize your data using text fields as your primary identifier. The computer won’t know that “Some Company, Inc” is supposed to be the same as “Some Company, Inc.” or “Some Company Inc”; likewise, “Department” is not the same as “Dept.” is not the same as “Dept” even if they represent the same entity – and the programmer will hate you when they also have to investigate manually find out that “SomeOtherCompany 2000, Inc” is different from “SomeOtherCompany2000, Inc”.
No, really. They will. Upper-case-H-A-T-E, hate you.