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