Database creation, seeding and views

DDL script for database initialization

schema.sql​

DML Script for seeding the database

For database seeding (populating the database), we used a Python-based scripting approach. The script generates the data dynamically and inserts it into the database using the psycopg2 library. Before running the seeding process, an active SSH tunnel to the server must be established. Below is the link to the repository containing the database seeding script.

​https://github.com/AleksandarAngelevski/database-seeder