Please explain identifying/non-identifying relationships
Can someone please explain to me the need for identying relationships and also how they differ from non-identifying?
I'm aware that they you create an identifying relationship, the FK of the other table becomes part of the PK of the current table (so it would then have a multi-column PK). But what does this do? Does this ensure that the "parent" element exists before the "child" element can exist?
Does this enforce integrity?
I'm building a product matrix that has various levels (sort of like a system where you can "Drill down" on a particular product from generic to specific) and have a bad feeling that this issue may be important, and don't want to find out that I did it wrong later on...
Subject
Written By
Posted
Please explain identifying/non-identifying relationships
July 11, 2013 10:14PM
September 05, 2013 05:16PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.