There is a great post by Travis Wright on the Service Manager model-based database on the SM team blog:

http://blogs.technet.com/servicemanager/archive/2009/01/27/the-system-center-platform-in-service-manager-part-2-the-model-based-database.aspx