Lab: Create a star schema from 3NF schema on DVD rental Pagila dataset

Objective

Create a star schema from 3NF schema on DVD rental Pagila dataset

Build a Postgres data model of Pagila dataset

Introduction

Pagila is a dataset representing a DVD rental store (remember those?!), containing information about films (like title, category, actresses), rental stores (like address, staff members, customers) and rentals, where a customer rents a film from a store through its staff.

With all these relational information, Pagila is a perfect fit to play around with PostgreSQL and the SQL language.

In this lab, we will use this Pagila dataset to build a data model in Postgres.

3NF Schema

Star Schema

Files

├── [ 41K]  01-sa-relational-datamodel.ipynb
├── [ 44K]  02-sa-relational-to-star-schema.ipynb
├── [ 51K]  03-sa-olap-cubes.ipynb
├── [1.3K]  README.md
├── [ 171]  data
│   └── [  75]  download.sh
└── [ 51K]  src
    ├── [5.7K]  data\ warehouse.sql
    └── [ 45K]  restore.sql

 189K used in 2 directories, 7 files

Notebooks