I will show you below how to interpret this. -image by author


A tutorial using PostgreSQL, pgAdmin 4 and the Pagila Dataset.

Postgres is an open-source project under a liberal Open Source license. You can find the PostgreSQL licence here
  1. Download PostgreSQL and pgAdmin 4 to your own PC or environment.
  2. Connect to PostgreSQL server
  3. Download and load the Pagila database set (based on the famous Sakila training database).
  4. Provide resources and a link to a Github repository detailing these steps. The data and the question sets will be included.


  1. Using pgAdmin 4 and PostgreSQL this article will demonstrate how to Create an Entity Relationship Diagram (ERD) of the Pagila Database to gain a greater understanding of the data you will be working with and to create a reference for which to work off of.
  2. There will display two separate methods for ERD creation. One is manually done and is much more time intensive but a better learning experience, the other is automatically done by pgAdmin 4 and is orders of magnitude faster and easier for those that are…


With a function to make it easier to produce and analyze them


An interactive 3D geospatial tool


James Opacich

Interested in thoughts and data. Data Science Immersive Student at General Assembly

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store