This would be renamed with the parent. Dummy rows in a non-identifying relationship where the parent is not mandatory might look like the below. One parent can have multiple children, but a child can have at most one parent. This is the nature of a recursive relationship. If a child can have multiple parents, you would need to create a many to many relationship using an associative table instead.
Org Unit **Org Unit Parent **
From: La Trobe Uni bounce-Salwa_Chamra@toadworld.com
Reply-To: "firstname.lastname@example.org" email@example.com
Date: Tuesday, September 1, 2015 at 6:21 PM
To: "firstname.lastname@example.org" email@example.com
Subject: RE: [Toad Data Modeler - Discussion Forum] Self Referencing and entity uniqueness
RE: Self Referencing and entity uniqueness
Reply by La Trobe Uni
Thanks for the response. I did send one with the question. Obviously the site was unable to display it.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Toad Data Modeler - General notifications altogether.
Toad Data Modeler - Discussion Forum
this post as spam/abuse.