Follow this step-by-step guide to install PostgreSQL, load data ... that site is no longer active. Entity-relationship diagrams like this one come out of tools; this image looks a lot like ...