data modeling using MS visio

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Database Design » Design Ideas and Questions » data modeling using MS visio

data modeling using MS visio

Rate Topic

Display Mode

Topic Options

Author

Message

sql-oholic

Posted Wednesday, September 03, 2008 7:41 AM

Old 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

Fraggle-805517

Posted Wednesday, September 03, 2008 10:02 AM

Right there with Babe

Group: General Forum Members
Last Login: Today @ 9:49 AM
Points: 721, Visits: 1,326

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

sql-oholic

Posted Thursday, September 04, 2008 6:21 AM

Old 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

Ian Scarlett

Posted Thursday, September 04, 2008 7:23 AM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 1:02 AM
Points: 1,322, Visits: 4,404

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

sql-oholic

Posted Thursday, September 04, 2008 7:45 AM

Old 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 Sad

Doing that wud be another pain

Post #563811

bettycarson09

Posted Friday, November 27, 2009 12:15 AM

Forum 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 »

Permissions