Modeling hierarchies

To model employees and access control groups, we need to first modify our existing data to account for hierarchies in regions, countries, and cities. We also need to add hotel chains and their hierarchies. We can then apply the same practices used in modeling hierarchies to model access groups.

Modeling geographical regions

We already have airports and cities, which are geographical entities. We can add a couple of other entities such as country and region.

Figure 7.1: Country and region

A country or a region is uniquely identified by its name.

We can represent the relationship between airports, cities, countries, and regions in the following way:

Figure 7.2: Regions, countries, cities, and airports

Note

The previous diagram representing Regions, countries, cities, and airports can be generalized to represent a hierarchy in Neo4j.

Adding countries and regions to Neo4j

We can add a constraint to ensure the uniqueness of a name across countries, shown as follows:

neo4j-sh (?)$ CREATE...