the SQL Management Studio also provides the option to get a Databasediagram. There you can add several tables and the Management Studio will automatically report the relation in a ER Diagram. But be careful, it can take a huge amount of power, if you add all the Tables. The main table for the tickets will be the pm_process and subordinated are im_incident, cm_change, pr_problem, etc.
Otherwise I'd recommend Eric's Post.