bootleg music database - help with structure of db

Hello fellow db-freaks.
I collect music bootlegs (this is not illegal, I only list from artist who agree to people taping their shows and distribute these bootlegs)
I want to build a database for my ever growing collection and I'm tired of hardcoding in html.

Now, the trouble with a bootleg music db is, that besides having tracks, who belong to albums, played by artists, there's also the specific date the track was palyed and the venue it was played at and the source, to take into consideration.

-Some bootlegs consists of a recording of only one show.
-Some bootlegs consists of a recording of only one show + fillers to use the empty space on a cd/dvd.
-Some bootlegs are complete compilations, consisting of one/many artist(s), playing the same/different songs, from same/different dates and same/ different venues.

Do you see the trouble piling up here :-)

I thought the db should center around:
a) the tracks
b) the album (Volumes)

The conditions for the db hence are:

• An artist can appear on multiple albums
• Multiple artists can appear on one album
• An artist can have multiple roles on a track (singer, guitar etc.)
• One album can have multiple physical discs
• An artist can appear on the same album in multiple roles
• A track can appear on multiple albums
• A track can appear multiple times on one album
• A track always has a date, a venue, a length, a source

Since an album (I think I'm going to call it a volume internally in the setup and then "album" to the public) may contain more than one physical disc, I'll have to somehow be able to have this information as well.

So I end up with the following tables:
The simple ones first:
Artist: id, name
Role: id, name (ie. singer, guitar, keyboard, etc.)
Venue: id, name, city, state, country
Track: id, name
Media: id, name (ie dvd, svcd, data-disc etc)
Source: id, name (ie soundboard, audience-recording etc.)

Now what bogs me is how I construct the rest.

What join tables do I need? How should the *track* and the *Volume* table be constructed?

Hope you find this interesting enough to help...
You can take a look at the hardcoded site if you're intereste at rustenrat.com (no advertising on site, it's my personal site - if this is against rules here, I'll glaldy remove the link)

Cheers, Thom

Do you have any php/mysql experince?

Yes, I can program in php and I more or less know how to make the relevant sql statements for my needs. It's just the design of the db I'm not so skilled with.

Hehe, you beat me to it. I was just gonna ask if TNF wouldn't be enough for this. Ok I'll get back here if it gets too long-haired for me.