The Overall objective of the databse project is to recreate and explore the database development life cycle, from user stories to conceputal models to relational models to physical models to implementing querying code to execute user stories. This specific project explores Duolingo's database schema, starting from understanding their business model and value propositions and writing out appropriate user stories. These stories are then implemented in an incremental manner, from different stages of models to code that simulates querying the database. All model stages and further documentation are within the project report pdf file.
First initialize:
% psql -d postgres -U isdb -f initialize.sql
Then run individual user stories:
% python <user-story-name>.py
To see all tables:
% psql -d postgres -U isdb -f show_all.sql