Knowing recursive relationships in data modeling problem

Asked By nories 10 points N/A Posted on - 11/06/2011

Hello!

Good day!

I have wanted to know about recursive relationships in data modeling and also want to know how to eliminate the same. I have searched and searched through internet by Google but with no luck.

Your ideas and suggestions will be greatly appreciated.

Thank you…

• Status: Open
• Question Views: 836
• Answer Count: 1
• Vote Up 1 Vote Down

• Answer Accepted: No
• Question Category: Development Software

Answered By Clair Charles 15 points N/A #105821

Knowing recursive relationships in data modeling problem

Hello Nories,

The recursive relationship in modelling is important especially when you need to perform relational data modelling in cases where an entity bears a relationship to itself.

When modelling using recursive functions, the system architecture that is involved is as follows:

• First there must be an entity relation diagram, which in it you will create the entity name.
• You will then add an attribute which you will need to specify with a primary key.
• Thereafter you will need to draw a non-identifying relationship line which by default should be named 'requires' and it should originate from the entity itself.
• Then you will need to ensure that primary key in the foreign tab of the relationship definition dialog is listed in the Foreign keys and Roles list.
• You will then need to select the dictionary and then update the foreign keys.

See example image below for guidance.

__

Regards
Clair Charles

About Clair Charles

Questions
1

Answers
495

Best Answers
109

• Vote Up 0 Vote Down

• Posted on - 11/17/2011
• Question Category: Development Software