This illustration shows the following table relationships:
product_information
table has a one to many relationship
with the inventories
table through the product_id
column, because one product can be in many inventories.warehouses
table has a one to many relationship with the
inventories
table through the warehouse_id
column,
because one warehouse can be in many inventories.locations
table has a one to one relationship with the
warehouses
table through the location_id
column,
because a warehous can only be at one location.