1 Reply Latest reply: Jan 22, 2013 7:07 AM by Paul Horth RSS

    ER Diagram representing a recursive relationship in Designer ?

    986201
      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
          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.