Thanks to both of you. The question of normalization was one thing I was
considering, I just wasn't sure how it should be done. A separate table
with Artist ID and Artist Name fields could be useful. Would it be good to
make an equivalent table for the songs, or should the songs simply be
listed individually in the main table? I assume the dates and times have to
be individual entries each time.
However, while reading the Wikipedia page on normalization, I noticed that
some of the examples of a normalized table actually lists people's names as
separate entries in the table. Of course, the alternative was some kind of
nested tables, that looked messy, so perhaps the separate listings were the
first step toward normalization, the next step being multiple tables with
IDs for the names?
Thanks.
>
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
