Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

data modeling using MS visio Expand / Collapse
Author
Message
Posted Wednesday, September 03, 2008 7:41 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, May 08, 2012 12:49 PM
Points: 339, Visits: 560
Hi there,

I am using MS VISIO 2007 for data modeling. It seems there isn't an option for creating many to many relationship between entities. Is it so?
If yes, then what one can do.

Please advise

Thanks
Post #562998
Posted Wednesday, September 03, 2008 10:02 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, April 07, 2014 4:35 PM
Points: 727, Visits: 1,392
There isn't that I am aware of because in good modeling, you are not suppose to have a many-to-many relationship. You should put an associate table between them.

Hope that helps
Post #563154
Posted Thursday, September 04, 2008 6:21 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, May 08, 2012 12:49 PM
Points: 339, Visits: 560
Its helpful.
I got your point

Thanks
Post #563720
Posted Thursday, September 04, 2008 7:23 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 5:35 AM
Points: 1,327, Visits: 4,483
Your logical data model can have many-to-many relationships, but they usually gets resolved with an associative table when you create the physical model.

BTW, I tried using Visio to model a database with > 150 tables, and Visio became so slow that it was unusable. If your company will pay for it, ask them to get ErWin or ER/Studio instead. They are both Sooo much easier to use... and they support many-to-many relationships in your logical model!



Post #563792
Posted Thursday, September 04, 2008 7:45 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, May 08, 2012 12:49 PM
Points: 339, Visits: 560
yeah, i am creating 'glue' tables for defining many to many relationship.
I think this approach makes model more flexible -- adaptive to future changes.

ERwin & Visio:
That is so true.
Erwin is tons better than Visio. Its a compact tool for DM having many nice n powerful features.
btw, I am using Visio professional and it doesn't has Fwd engineering i.e. creating DB from data model
Doing that wud be another pain
Post #563811
Posted Friday, November 27, 2009 12:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 01, 2009 4:37 AM
Points: 1, Visits: 1
Microsoft Visio toolbox Information Technology Professionals manage and execute a broad range of tasks
that are critical to the success of their enterprises. On this page we attempt to guide you to information that is most relevant to your business responsibilities.
Post #825468
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse