 | |
#11
 
| |||
| |||
|
Re: Visio and Oracle? -
10-26-2007
, 03:43 AM
|
On Oct 23, 8:59 am, "Shakespeare" <what... (AT) xs4all (DOT) nl> wrote: "Brian Peasland" <d... (AT) nospam (DOT) peasland.net> schreef in berichtnews:471dfb7b$0$26455$88260bb3 (AT) free (DOT) teranews.com... Henrootje wrote: I did not say that Visio is free. I am legally using Visio, that is why I wanted to use it. I am doing a degree in ICT (Bachelor of ICT) besides my job. One of the courses is desiging databases. That is why I want to analyze existing database structures. But according to the reactions here Visio is not the right tool to do this. Then I have to look for an alternative but budget is limited. I hoped there would be some tool(s) I could use to help me analyse existing databases. If you know of any good tools, I would like to know which those would be. Maybe I can find some student licensing program. But since I just started things do no t need to be overly complicated. Is there anything you can point me too? TIA, Henro One of the tools I've used in the past is Happy Fish (weird name...). You can find this tool here: http://www.polderij.nl/happyfish/ The tool is not free, but it is relatively inexpensive. HTH, Brian -- ================================================== ================= Brian Peasland d... (AT) nospam (DOT) peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - Unknown -- Posted via a free Usenet account fromhttp://www.teranews.com I wonder how a tool can create an ERD from a database, since the steps from ERD to Datamodel are not 1 on 1..... Some decisions like resolving arcs, m-n relationships, (de)normalization etc will "disappear" in the process. quote Happy Fish combines ERD design with live database access to query or maintain an already developed database. end quote I think they confuse an ERD with a Data Model Diagram.... Still looks useful though...... Shakespeare (What's in an ERD) And other things will mysteriously appear, for example, constraints between relationships. ("What's not in an ERD", so to speak). I think that's all just showing the limitations inherent in moving from design to implementation, then going into reverse. If you have something poorly designed and/or implemented, there's going to be some real doozies. For ongoing maintenance, there's going to be a need for this type of tool, regardless. The more automated it can be, and the bigger the system, the more helpful. If reversing into design can't be made to work, that's a good sign to junk it all and start over. jg -- @home.com is bogus. http://www.signonsandiego.com/firemap/ |
I agree!
BTW: I checked it out (had some spare time) and indeed, it's not an ERD but
a database diagram...
Shakespeare
#12
| |||
| |||
|
|
If you know of any good tools, I would like to know which those would be. Maybe I can find some student licensing program. |
http://www.databaseanswers.com/modelling_tools.htm
Gints Plivna
http://www.gplivna.eu
#13
| |||
| |||
|
|
If you know of any good tools, I would like to know which those would be. Maybe I can find some student licensing program. check this listhttp://www.databaseanswers.com/modelling_tools.htm Gints Plivnahttp://www.gplivna.eu |
Thanx to all the people taking time to think this over!
Henro
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.