PostGIS aviation_database and introduction to real world examples

I have covered some basic but indispensable functionality (distance, coordinate, bearing, local coordinates etc.) so far. I have also developed some tools (QGIS plugins) that allows us to easily create features that are common in aviation world:

• polygons based on circles and circle parts (useful to create airspaces)
• creating points based on bearing, distance, offset against reference point - which is common way of defining location in aviation

Now, it's time to move on and show how those tools can be used in order to create and manage data with aeronautical content. It will require to create a spatial database and new tools.
IMPORTANT NOTE (friendly remainder)
Condition of use this blog
1. All examples, including tools (python scripts and etc.) in this blog are only for training and educational purposes, hence they are can not be used for navigation purposes and etc.
2. I also can't  guarantee that tools I've created or I will create and share on this blog are free of any errors or bugs and can be used for navigation purposes or any other use.
3. I won't take any responsibility of any damage and etc. that are result of using tools shared on this blog.
4. Reading this blog means that you accept this terms of use.

As I mention on introductory post, there are a lot of publications where you can find data that describes anything that is relevant in terms of aviation.
aviation_database will contain some selected data in limited scope:

• aerodromes,
• terminal procedures,
• waypoints,
• airways,
• navigation aids,
• obstacles,
• Notice to AirMen (NOTAM)

I used following documents to design database structure:
AIP (Aeronautical Information Publication)
AIXM
related to  FAA files that describe DOF, NASR data

Becuuse I am going to use test data from various countries, publications each of table will contain additional columns that keep information related to publication.