Add the synonym field in the publishers table
synonymfield is a
stringcontaining values separeted by a comma.
- If a publisher does not exit have a look to the synonym. If nothing match, reject the record. Latter on, the user can add a new publisher or synonym in the database and catch the faulty record.
- Rename the field