Newbie question about design

Hi all

I don't have much experience with databases, so any help is appreciate. I have a class Link:

class Link {
  Collection<Tag> tags;
  ...
}

so, when user creates Link, she or he can add whatever number of tags. In database, I would have table Link, of course, and another table Tag. Table Tag would have three columns: id, tag name, and the foreign key which is id of a link (below is URL). For example:

table Tag:
id tag link
1 python http://www.python.org
2 python http://www.google.com

Is this good approach? Received on Tue May 01 2007 - 04:29:11 CDT