ER Diagram representing a recursive relationship in Designer ?
986201Jan 21 2013 — edited Jan 22 2013Hello,
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