Database Design Help
Posted: Tue Nov 19, 2002 1:40 pm
Hello,
Im trying to create a mysql db of a music collection. I've come up with the following table structure
-Artist
Artist_ID,
Artist_Name,
-Album
Album_ID,
Artist_ID,
Album_running_time,
Album_Record_Label,
Album_Format
-Tracks
Album_ID,
Artist_ID,
Track_album_no,
Track_running time
The problem is the collection has alot of double/complication albums and I would want to be able to run a query and list an album with the names of the tracks on each cd of the album. I'm not sure how to alter or add to my structure to do this. Would adding a cd number column to Tracks table be sufficient?
Thanks
J
Im trying to create a mysql db of a music collection. I've come up with the following table structure
-Artist
Artist_ID,
Artist_Name,
-Album
Album_ID,
Artist_ID,
Album_running_time,
Album_Record_Label,
Album_Format
-Tracks
Album_ID,
Artist_ID,
Track_album_no,
Track_running time
The problem is the collection has alot of double/complication albums and I would want to be able to run a query and list an album with the names of the tracks on each cd of the album. I'm not sure how to alter or add to my structure to do this. Would adding a cd number column to Tracks table be sufficient?
Thanks
J