Normalise this Table?
- by Abs
Hello all,
I am creating a social bookmarking app. I am having a re-thought of the DB design in the middle of development.
Should I normalise the bookmarks table and remove the tag columns that I have into a separate table. I have 10 tags per bookmark and therefore 10 columns per record (per bookmark).
It seems to me that breaking the table into two would just mean I would have to do a join but the way I currently have it, its a straight select - but the table doesn't feel right...?
Thanks all