Answer to Question #219056 in Databases | SQL | Oracle | MS Access for stan

Question

Explain the significant differences between homonyms and synonyms and with examples, explain why they should be avoided in database design?

Answer 1

The main difference between between homonym and synonym is that homonym is used to indicate the use of the same name to label different attributes while synonym is used to indicate the use of different name to describe the same attribute.

They should be avoided in database design because they cause confusion.