This discussion is archived
1 Reply Latest reply: Jan 22, 2013 5:07 AM by Paul Horth RSS

ER Diagram representing a recursive relationship in Designer ?

986201 Newbie
Currently Being Moderated
Hello,

I couldn't find this info about Oracle Designer, I'm drawing an Entity relationship diagram to represent a company.

I have to *represent a recursive 1-to-many relationship* (HeadOffice is of type branch and heads all the company Branches).


Is there an appropriate icon to use in the Designer tool or should this be done in SQL later in the process?
Could you give an example??

Thanks and regards,
Helene
  • 1. Re: ER Diagram representing a recursive relationship in Designer ?
    Paul Horth Expert
    Currently Being Moderated
    983198 wrote:
    Hello,

    I couldn't find this info about Oracle Designer, I'm drawing an Entity relationship diagram to represent a company.

    I have to *represent a recursive 1-to-many relationship* (HeadOffice is of type branch and heads all the company Branches).


    Is there an appropriate icon to use in the Designer tool or should this be done in SQL later in the process?
    Could you give an example??

    Thanks and regards,
    Helene
    If I understand you correctly, simply use the normal 1-to-many icon in the diagrammer. Click within the entity and then click again the same entity: you
    will get a recursive relationship.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points