I suspect that a data
base diagram is what is asked for.
Visio is not my favorite tool for database diagrams, it's better for flow charts etc (at least my version which is Standard 2003). ERwin and others are better for these kind of drawings.
Either tool does usually use an ODBC connection for importing data base information. I'm not sure how relationships will be deployed in the model. That is probably tool dependent. It might help if you have referential integrity defined on your tables.
Please share your experience if you'll have a go!
Regards,
Linus
Data never sleeps