Please explain identifying/non-identifying relationships
Posted by: Chris Bassett
Date: July 11, 2013 10:14PM

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

Options: ReplyQuote

Written By
Please explain identifying/non-identifying relationships
July 11, 2013 10:14PM

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.