Add the synonym field in the publishers table
- The
synonym
field is astring
containing 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
publisher
.