I have a table "words" (wordId,word,translation) every word has to be associated with at least one category. I have an additional table "categories" (categoryId,categoryName) what is the best way to associate each word with all the categories it belongs?
one option: an additional table "wordsCategories" (wordId,categoryId)
second option: To add a colomn in the words table that will store all the categories ids that the word belongs, the categories ids will be seperated by a comma. table "words" (wordId,word,translation,categories) insert into words (wordId,word,translation,categories) values (7,"word","travail","9,12,23")
I am open to hear of a better option.