EDIT: The instructions for Views 3 have been moved to their own page. http://wiki.civicrm.org/confluence/display/CRMDOC40/Views3+Integration  

Some tips and tricks for integrating Views2 and CiviCRM

Diagram for civicrm_relationship table: