Skip to content

Ophiase/DataBase-Project-IFEBY140

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

56 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

DataBase-Project-IFEBY140

Introduction

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.

Execution

Report

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

PSQL

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

About

Normalized (BCNF) database modelization for the "QueFaireAParis" Dataset.

Topics

Resources

License

Stars

Watchers

Forks