Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
* At the begging I have named the table items, so I refered to it's rows with item_id and after that I have decided that the tag name will be more convinient, so I renamed it and forgot to rename the refered row, that's a good remark. *Each photo should have a title alongside with it's tags of course yes, it's not duplicated ( I have read more about on database normalization as you have said to me last question ;) ). *I have seen that people sometimes recommend to name the linking table with the name of the tables they are linking, but also other people recommend naming it with what it hold