Understanding the relationships between the various system tables (not to mention even knowing what all tables are there), is a cumbersome task. Fear not, because Microsoft has released a PDF version of a “map” of all the system tables in SQL Server 2005 and you can find it here:
SQL Server 2005 System Table Map.