If Airbnb used a RDMS

This database project implements a relational database for an Airbnb case study.

Setup & Run

Given a PostgresSQL database with the user isdb, run the following: % psql -d postgres -U isdb -f project_reset.sql

The database project will be created and loaded.

You can then run the various query files with python, for example: % python simple_query_1_us1.py

Name		Name	Last commit message	Last commit date
Latest commit History 14 Commits
LICENSE		LICENSE
README.md		README.md
analytical_query_1_us8.py		analytical_query_1_us8.py
analytical_query_2_us12.py		analytical_query_2_us12.py
analytical_query_3_us13.py		analytical_query_3_us13.py
complex_query_1_us3.py		complex_query_1_us3.py
complex_query_2_us4.py		complex_query_2_us4.py
complex_query_3_us10.py		complex_query_3_us10.py
complex_query_4_us11.py		complex_query_4_us11.py
project_create.sql		project_create.sql
project_load.sql		project_load.sql
project_reset.sql		project_reset.sql
project_showall.sql		project_showall.sql
report.pdf		report.pdf
report_conceptualmodel.pdf		report_conceptualmodel.pdf
simple_query_1_us1.py		simple_query_1_us1.py
simple_query_2_us2.py		simple_query_2_us2.py
simple_query_3_us5.py		simple_query_3_us5.py
simple_query_4_us6.py		simple_query_4_us6.py
simple_query_5_us7.py		simple_query_5_us7.py
simple_query_6_us9.py		simple_query_6_us9.py