Appendix K. Demo Database“Airlines”
Table of Contents
This is an overview of a demo database forPostgres Pro. This appendix describes the database schema, which consists of eight tables and several views. The subject field of this database is airline flights in Russia. You can download the database fromour website. SeeSection K.1 for details.
Figure K.1. Airlines in Russia
You can use this database for various purposes, such as:
When developing this demo database, we pursued several goals:
Database schema must be simple enough to be understood without extra explanations.
At the same time, database schema must be complex enough to allow writing meaningful queries.
The database must contain true-to-life data that will be interesting to work with.
This demo database is distributed under thePostgreSQL license.
You can send us your feedback toedu@postgrespro.ru.