I would like to build a database of pictures. Each picture may have 1 or more tags, for example: `Paris`, `April 2010`, `David`.

How would you store this information ?
I thought to have a `Files` table with 1 row per file, and one of the columns would be Tags IDs separated by commas, for example: 2,4,14,15

In other table called `Tags` I thought to have 1 row per tag, like this:

```
Tag ID    Tag Name
------    --------
   1       April
   2       David
   3       Paris

```

Do you think this is a good idea to manage tags like that ?
For example, how would I easily get all tags names of specific picture ?