Figure 16 shows how the hierarchical tables of the superstores_demo database are related. See The customer and location Tables for an explanation of the foreign key and primary relationships between those two tables, which are indicated by shaded arrows that point from the customer.custnum and customer.loc columns to the location.location_id columns in the following diagram.