Normalise this Table?

Posted by Abs on Stack Overflow See other posts from Stack Overflow or by Abs
Published on 2010-03-29T21:58:48Z Indexed on 2010/03/29 22:03 UTC
Read the original article Hit count: 264

Filed under:
|

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

© Stack Overflow or respective owner

Related posts about mysql

Related posts about database-design