Referential Integrity is enforced by the application. In database, do not define FK constraints. Indexes are created on most of Foreign Key columns to increase performance.
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.