• Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Data Modellng tools?

You're doing fine, I think what your missing is an Entity Relationship Diagram.

Once you have that your Dataflow will make more sense.

Then you need to link your data flows to the ERD.

Fancy tools won't help, you'll just spend more time fighting with the tools than understanding the problem.

Data Flows alone work if the data is fairly simple, but otherwise you need to start with your ERD first.

I think it's fine to use Visio for the overview and Word and Excel for the nitty gritty.
 
Last edited: 09:44
Talking about relational dBs, and applying the Merise approach, I would generally recommend AnalyseSI, or a better option could be Mocodo.

If you need to represent some more object-oriented scenarii and cases (applying UML), I can think of Rational Rose.
 
You're doing fine, I think what your missing is an Entity Relationship Diagram.

Once you have that your Dataflow will make more sense.

Then you need to link your data flows to the ERD.

Fancy tools won't help, you'll just spend more time fighting with the tools than understanding the problem.

Data Flows alone work if the data is fairly simple, but otherwise you need to start with your ERD first.

I think it's fine to use Visio for the overview and Word and Excel for the nitty gritty.
An ER diagram is what I would think of as a data model.

You can get by with Excel and Visio for a while, but if you are building complex data models you will want a proper modelling tool eventually, if only to generate the DDL properly.
 
Visual Studio 2010 has tools built in for designing, deploying and version controlling a database.
I've not used it myself but it could be worthwhile looking in to
 

Advertisers

Back
Top