Custom Dynamic pages from DB result

Hi:

I have a site running on CodeIgniter right now, but I want to migrate it to WP. I’ve figured out all the other parts except the dynamic pages that I’m generating now.

I’m working on a singer website who has many albums and many songs (over 200). Some of the songs appear in multiple albums, ie “Best of” and Compilations.
I have 3 tables, albums, songs, songs_to_albums.
This gives me the posibility of assigning different songs to different albums.

All songs have lyrics, most have videos , either on youtube or on our server.

All songs and albums have star ratings and description.

I need an Albums page where it extracts all albums.

Each album is linked to an “Album-specific” page which extracts all the songs that are in the album, plus description, rating….

Each song within an album is linked to “Song-specific” page, which extracts specific song info from the db, ie title, description, and albums it appears on.

I need a page that lists all the songs dynamically, indicating on which albums they appear.

I don’t want to create static pages for albums and songs, they must be dynamic.

Currently all these pages, SQL queries, etc exist, so I need to know how to integrate them into WP.

I realize I have to create some custom solution in WP, but since I’m not @ that advanced in WP I don’t even know where to start !

Thank you in advance for your help.

Kamy