Copyright © 1996, 2013, Oracle and/or its affiliates. All rights reserved.
Legal Notices
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 warehouse can only be at one location.