Cell with multiple values?

[Holy Samosa]

I've only worked with very simple DataSets and database tables in the
past, so please forgive me if this is newbie question.

I'm trying to create a DataSet for items that can be associated with
any number of keyword tags (e.g. URL's tagged with keywords on
del.ico.us). Since a cell can't contain multiple values, what's the
proper way to represent the 1..n keywords for each row of the data?
Should the keywords be stored in a separate DataTable for each row?

I'm also very interested in using LINQ, if that would impact the
viable solutions.

Thanks!!

 

[Holy Samosa]

I've only worked with very simple DataSets and database tables in the
past, so please forgive me if this is newbie question.

I'm trying to create a DataSet for items that can be associated with
any number of keyword tags (e.g. URL's tagged with keywords on
del.ico.us).  Since a cell can't contain multiple values, what's the
proper way to represent the 1..n keywords for each row of the data?
Should the keywords be stored in a separate DataTable for each row?

I'm also very interested in using LINQ, if that would impact the
viable solutions.

Thanks!!

A few additional hours of research and I've worked this out.

I've opted to go with multiple tables related by a foreign key.

Check out http://www.whatspop.com/blog/2006/01/setting-up-database-for-tagging.cfm
for a nice discussion on database table design for a del.ico.us-style
tagging application.