data modeling using MS visio

Question

data modeling using MS visio

MuditGupta

SSCrazy

Points: 2596
More actions
September 3, 2008 at 7:41 am

#190092

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

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Fraggle-805517 SSCrazy Eights Points: 8907 More actions · Answer 1

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

MuditGupta SSCrazy Points: 2596 More actions · Answer 2

MuditGupta

SSCrazy

Points: 2596

September 4, 2008 at 6:21 am

#867059

Its helpful.

I got your point

Thanks

Ian Scarlett SSC-Insane Points: 23197 More actions · Answer 3

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!

MuditGupta SSCrazy Points: 2596 More actions · Answer 4

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

bettycarson09 SSC Rookie Points: 47 More actions · Answer 5

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.