Ah terminology. It can so get in the way of communicating some times.
I think much of the concerns are answered above, but I thought I would just throw in a little of my interpretation as I thought it may help, in this case and in others. Of course, my terminology will also be foreign, but let's give it a go.
First, while the MC Library
is a Database, I like to think of it as an Index of all the Media Files I have told it about, or let it find. A Library doesn't hold any media itself, just
Index Records that point to the media on disks somewhere.
In a similar way, Playlists aren't lists of media files on a disk, but are lists of Index Records.
Now as Glynor says, if you;
Turn off Fix Broken Links in Auto-Import. Then the files won't be removed from the Library even if they don't exist on disk.
If you turn off "Fix Broken Links", then the Index of your Media Files isn't updated when a Media File is deleted from a disk drive. (Or moved around on the drive I believe.) So your Playlist can still include the songs that just got deleted, because the Index Record of that song still exists in the Library. When an
Index Record is no longer in the Library, then that song can no longer appear in a Playlist. That sounds like the solution you want Elvis. Correct?
On the question of rating at the Album level, instead of the media file level, I can understand a desire to do that. It is actually a pretty logical and good idea. Glynor has given you a way to try to do that. But I think most people do want to rate individual songs as well, and if this is done it is pretty easy to set up a Smartlist to show only Albums with an average song rating of say 3.5, and then just play those Albums. But of course many people also want to play their favourite Albums, but only play the songs with a rating of 4 or higher. After all, who wants to listen to all those crappy filler songs included to make up the numbers in Albums? With individual song ratings that is also easy. Using just an Album rating, and playing only Albums with a rating of 4 or higher, means that you will still be listening to those crappy filler songs. So rating at the song level is far more flexible than rating at the Album level. Maybe you could try to create some Smartlists that meet your needs.
But just to clarify, as I'm not sure from what you said, do you create
one Playlist for
each Album in your Library? Because if so, that is a lot of work, and it would probably defeat much of the brilliant searching, sorting, and selecting functionality in MC. It would also make navigation down a list of Playlists in MC Standard View a very cumbersome process. So I don't understand what you mean by "I use playlists for all my albums." Perhaps you could explain.
Finally, when you wrote "when you have may clients, you can be unlucky, you reinstall windows, forget to map up drives, or restore the wrong library" I thought "That sounds a bit strange."
In fact, I'm wondering if you have just one MC server and multiple MC Clients synchronising with that server, of if you have something like a NAS with all your files on it, and you run multiple MC servers, each connecting to the NAS and managing its own Library?
You see, the MC Media Network is designed such that one MC server is used to create and mange one Library, which is then synchronised to all MC Clients. That way, if you do have to reinstall windows (and MC), all you do is point the new MC Client installation to the MC server, and let it synchronise to the server. You should never really backup copies of the Server Library on the Client, or be restoring Libraries on the Client at all. So how could you restore "the wrong library"? The same with mapping drives. The MC Server knows where the Media Files are, and will serve them up to any MC Client that requests them. There is no need to map the drives where the Media Files reside on the MC Client (although you may want to, and there are some reasons for doing it, but it is generally not required.)
I may have just read far too much into your brief comment, but it set alarm bells off for me.
Oh, and "Workflow" is just the way you do things. How you set up MC, how you rip CDs and set up Playlist, how you choose to play you media files. "Workflow" doesn't have to mean some formal procedures you follow all the time, or anything like that. So if you say that when you rip CD Albums, you then create a Playlist for each Album, many people would call that a Workflow.
Disclaimer: I'm still no expert, I haven't tested everything I just talked about, and I could be completely wrong.