A database project for a university course. For more details : pdf report, web report
Course constraint :
Code everything in psql.
Don't use pgsql functions to extract the data.
make update_pdf # update XXX_YYY_report.pdf and open it
make update_web # update docs/
make preview_web # start web server and open web report
Start psql in src folder.
cd src
psql -d <database> username
Create tables and populate them with :
\i XXX_YYY_tables.sql
See a preview of the data with :
\i XXX_YYY_data.sql