DB relationships in Microsoft CRM 2011

Is there an easier way for tracking down the relationships between tables in MS CRM 2011 than using the ER diagram from http://www.microsoft.com/en-us/download/details.aspx?id=2640?

More particularly, I entered a note for a Contact and I need to build a Select that shows me the note and the Contact’s name.
So I have to go from dbo.Annotation to dbo.Contact.

I also tried View Dependencies from SQL Management studio but it only shows me BusinessUnitBase and OwnerBase.