I am working on a project where a user can select multiple categories of interest, while they will create their profile. How should i do that?
Should i make 3 tables eg. one for user_details(User id, username), a table with list of categories(categoryID and category name) and a bridge table(user id and category id)?
Should i make 2 tables eg. one for user_details(User id, username and a table with list of categoryies(Userid, cat1, cat2, cat3, cat4........., cat25), here userid will be the candidate key, and all the selected categories will be true or false.
Please let me know which is better approach and Why?