MySQL Forums :: Database Design & Data Modelling :: Please explain identifying/non-identifying relationships


Advanced Search

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


Subject Written By Posted
Please explain identifying/non-identifying relationships Chris Bassett 07/11/2013 10:14PM
Re: Please explain identifying/non-identifying relationships Andrew Simkovsky 09/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.