If I have tblBookInfo (bookId, title… etc.) and I want it to have categories column, what is the best way to do it?
If I have tblBookInfo (bookId, title… etc.) and I want it to have categories column, what is the best way to do it? If I have tblBookInfo (bookId, title... etc.) and I want it to have categories column, what is the best way to do it? categories table will have FK related to bookId like this bookId title 1 test title 2 test title 2 bookId name 1 Science fiction 1 Mystery 1 Horror 2 Science fiction 2 Mystery In this case, category name will be repeated many times and it's ugly Store an array of int in btlBookInfo like this bookId title categories 1 test title [1,2,3] 2 test title 2 [1,2] I heard storing array in a column is not a best practice as asked here Leave the categories table as it is like this id name 1 Science finction 2 Mystery 3 Horror And add a FK to tblBookInfo like this bookId title categoryId 1 test title 1 2 ...