Reletionships [message #23413] |
Thu, 05 December 2002 21:17 |
Suresh
Messages: 189 Registered: December 1998
|
Senior Member |
|
|
Hi,
Can anyone please give a real time example of non-identifying and subtype relationships?
Thanks in Advance.
Regards
Suresh
|
|
|
Re: Reletionships [message #23425 is a reply to message #23413] |
Fri, 06 December 2002 14:58 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
A non-identifying relationship is when a foreign key on a table is not part of the primary key (a composite pk) of that table.
An identifying repationship which is part of a PK can't be modifed (because the PK is constant for the life of the row by definition). A foreign key which forms an identifying relationship is non-transferable (you can't link it to a different parent record). A Non-identifying relationship is transferable (because it is outside of the PK).
http://www.quest.com/whitepapers/Reality_Requires-QDesigner.pdf
|
|
|