PDA

View Full Version : Identifying Relationship impact


ABC123

jchasko
08-28-2011, 05:39 PM
I'm confused about Identifying Relationships in MySQL.

Just how does the database function change when you specify that an FK is an Identifying Relationship?

Ted Giles
08-30-2011, 06:58 AM
http://www.datanamic.com/support/relationshiptypes.html

jchasko
08-30-2011, 10:24 AM
Thank you. I understand the concept, but not the impact. How does this change the database function? I couldn't find anything on that.

Ted Giles
08-30-2011, 03:15 PM
I think you need an SQL forum rahter than Alpha for that level of detail.

jchasko
08-30-2011, 05:23 PM
It's not about SQL, per se. What does it mean to choose "Identifying Relationship" for a foreign key. Not why you do it. What does it affect?

Ted Giles
08-31-2011, 06:50 AM
Display the attached Set
Disect it to see the different relationships