Hey, this should be an ultra basic database question, but I've never known the answer and would love an explanation or point in the right direction. So, here it is:
When setting up a database schema - for storing related data (such as descriptive tags
) for a piece of content (such as an article
or photo
), which of the below is the smartest way?
item_id tags
1 alpha,beta,gamma
2 beta
3 alpha,gamma