Follow this step-by-step guide to install PostgreSQL, load data, connect to a database, and execute SQL queries including ... The connections between tables are the foreign key contraints.