= Database creation, seeding and views



== DDL script for database initialization

[[attachment: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 https://github.com/AleksandarAngelevski/database-seeder]