Russian Airlines Demo Database Query Russia airline flight records in this demo postgres database. Entity Relationship (ER) Diagram. Setup Database You can install this demo postgres database at the postgrespro site. Explore Database Basic Queries. Basic Queries. Basic Query. How to Create a Function. How to Create a Procedure. How to Create a Run Log. Create a report to show the status of all flights from the previous day based on how many seats were occupied and the flight delays.