2 Replies Latest reply: Nov 14, 2012 1:29 PM by user4197738 RSS

    Relationship with Attribute

    user4197738
      Is it possible to show M:N relationship with attributes? I am using Data Modeler 3.1.4.

      Thanks.
        • 1. Re: Relationship with Attribute
          Philip Stoyanov-Oracle
          Hi,

          you need Data Modeler 3.3 for that - you can create relationship attributes using relationship dialog. Use diagram's context menu "Show>Relationship attributes" in order to show/hide them on diagram.
          You also can engineer intersection table to relationship (need to set "Engineer as relationship" in table dialog) - following rules should be matched for intersection table:
          - 2 foreign keys
          - foreign key columns are part of primary key

          Philip
          • 2. Re: Relationship with Attribute
            user4197738
            Philip Stoyanov wrote:
            Hi,

            you need Data Modeler 3.3 for that - you can create relationship attributes using relationship dialog. Use diagram's context menu "Show>Relationship attributes" in order to show/hide them on diagram.
            You also can engineer intersection table to relationship (need to set "Engineer as relationship" in table dialog) - following rules should be matched for intersection table:
            - 2 foreign keys
            - foreign key columns are part of primary key

            Philip
            Yes, it works. Thanks.