Tags: create, entities, er-diagram, following, helloplease, microsoft, mn-relationship, mn-relationshipbetween, msdn, software, visio, visio-er-diagram, visio_2002

m:n-Relationship in Visio-ER-diagram?

On Microsoft » Microsoft Visio

1,822 words with 2 Comments; publish: Fri, 30 May 2008 21:17:00 GMT; (300125.00, « »)

Hello!

Please let me know if it is possible to create an m:n-Relationship

between two entities in an ER-diagram in Visio_2002.

I only get following possibilities:

0:1

0:n

1:n

1:n

Will I have to make it with a 3rd entity?

Sorry for my bad English and thank You for helping me,

Christian Grohl

__

(___()'`; o__

/,XXX /` _.>/ _

___\\"--\\________(_) \(_)_____

All Comments

Leave a comment...

  • 2 Comments
    • Visio ER does not support explicit M:M relationships. The obvious

      workaround is to create a bridge table where it has 1:N relationships to the

      two entities that need M:N relationship.

      ~~~~~~~~~~~

      The information provided is AS-IS with no express warranty.

      Chang Oh

      Dev Lead

      Enterprise Frameworks & Tools

      "Christian Grohl" <christiangrohl.ms-visio.todaysummary.com.nospam.invalid> wrote in message

      news:2umsivF2bvqmdU1.ms-visio.todaysummary.com.uni-berlin.de...

      > Hello!

      >

      > Please let me know if it is possible to create an m:n-Relationship

      > between two entities in an ER-diagram in Visio_2002.

      > I only get following possibilities:

      > 0:1

      > 0:n

      > 1:n

      > 1:n

      > Will I have to make it with a 3rd entity?

      >

      > Sorry for my bad English and thank You for helping me,

      > Christian Grohl

      > --

      > __

      > (___()'`; o__

      > /, /` _.>/ _

      > ___\\"--\\________(_) \(_)_____

      #1; Fri, 30 May 2008 21:18:00 GMT
    • Es formulierte "Chang Oh" folgenden Schrieb:

      > Visio ER does not support explicit M:M relationships. The obvious

      > workaround is to create a bridge table where it has 1:N relationships to the

      > two entities that need M:N relationship.

      >

      Thank You...

      __

      (___()'`; o__

      /,XXX /` _.>/ _

      ___\\"--\\________(_) \(_)_____

      #2; Fri, 30 May 2008 21:19:00 GMT