Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

In my company we use Excel/SQL Server/Access/VB.NET/C#/.... I want to remove many workarounds, but first i need to understand the whole thing.

I'm not an model expert, so i want some opinions (and patterns) from you guys.

For my Macro model, i'm thinking to use Aris Express and make something like this: enter image description here

For my Data Model Diagram i tried to use "New Database Diagram" from SQL Server but i got some problems using it. I can't create a Diagram with two Databases, (i need it because we split the databases in 'general company's database' and 'specific software database' ). For my Data Model Diagram i could use simply ER Model.

Does someone know a pattern/softwares to make my life better?

share|improve this question
1  
What are you asking for here? Help with modeling your processes? Software that allows you to diagram things? – Jon Seigel Aug 21 '12 at 2:59
I'm looking for a pattern (like ER/UML) to follow. – Makah Aug 21 '12 at 12:14
I think it isn't clear what is being asked here - closing pending an edit. – Jack Douglas♦ Aug 24 '12 at 16:51
The question is really clear. I have a complex IT infrastructure with Excel/Access/SQL/.NET and i want a pattern to build a model. – Makah Aug 24 '12 at 19:32

closed as not a real question by gbn, Jack Douglas♦ Aug 24 '12 at 16:51

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, see the FAQ.

Browse other questions tagged or ask your own question.