Using Toad for Data Modeller 5.4
I have created a self referencing refer to example
a FK was created. Should this FK be renamed as parent gl account number or subsidiary gl account number. if the later then how is this entity unique?
I read the FK as the subsidiary gl account number not the parent.
Hi,
please attach a sample model.
Thank you,
Vaclav
Thanks for the response. I did send one with the question. Obviously the site was unable to display it.
From: Vaclav Frolik [mailto:bounce-Vaclav_Frolik@toadworld.com]
Sent: Tuesday, 1 September 2015 4:57 PM
To: tdm@toadworld.com
Subject: RE: [Toad Data Modeler - Discussion Forum] Self Referencing and entity uniqueness
RE: Self Referencing and entity uniqueness
Reply by Vaclav Frolik
Hi,
please attach a sample model.
Thank you,
Vaclav
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad Data Modeler - General notifications altogether.
Toad Data Modeler - Discussion Forum
Flag
this post as spam/abuse.
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 **
Finance Finance
Treasury Finance
Accounting Finance
Human Resources
null
From: La Trobe Uni bounce-Salwa_Chamra@toadworld.com
Reply-To: "tdm@toadworld.com" tdm@toadworld.com
Date: Tuesday, September 1, 2015 at 6:21 PM
To: "tdm@toadworld.com" tdm@toadworld.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.
Or
Unsubscribe from Toad Data Modeler - General notifications altogether.
Toad Data Modeler - Discussion Forum
Flag
this post as spam/abuse.