This illustration shows the following table relationships:

• The 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.
• The 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.
• The 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.