Self Referencing and entity uniqueness

Salwa_Chamra · August 31, 2015, 7:14pm

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.

Vaclav_Frolik · August 31, 2015, 11:55pm

Hi,

please attach a sample model.

Thank you,

Vaclav

Salwa_Chamra · September 1, 2015, 3:21pm

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.

lisa.garner · September 2, 2015, 7:25am

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