Using an example = in each case, explain the significant difference between homonyms and synonyms and explain why should they be avoided in database design?

Homonyms and Synonyms adds confusion to the database. So, they should be avoided in database designing.

Homonyms refer to the multiple fields having same name but representing different data. Synonyms refer to multiple fields having different name but representing same data. The names used in database should be clear to use and specific. They add confusion. So, they should be avoided.