Asking for help to refactor SQLite database design

Question

I have two tables : products and tags.

products

key | name | description | url

tags

key2 | tag | tag description

Association

• One tag can be associated with many products.
• each product has one or more tags associated with it.

eg a product "plate" has the tags "ceramic", "white", "delicate", etc associated with it.

I don't know however how to create a many-to-many representation.

What's the best way to store these tag associations? Create a tags field in products? Or another table? Thanks!

Edit: tags are many-to-many, thanks S.Lott

Answer 1

One tag can be associated with many products and each product has one or more tags associated with it.

That's not a one-to-many. That's many-to-many.

Google "Association Table" or "Junction Table" for numerous examples.

http://en.wikipedia.org/wiki/Junction_table

http://www.youtube.com/watch?v=P_nhBKs25DQ

Answer 2

I would go with an additional table named (productTags: key, productKey, tagKey) that would map the two tables together.