Sign in to follow this  
NewBreed

Database design software.

Recommended Posts

Personally I use the pen and paper approach most often. Depending on the project. If the project requires me to document it all I prefer to use Visio for that, although the symbols needed can also be found in WORD (I think).

For actually managing the tables in the database, that depends on your personall preference and the database you are using. Excel doesn't really need an external tool for that. SQLDeveloper from Oracle can connect to Oracle (Duh..), Access and MySQL. The best feature support is with Oracle though.
If you are running mySQL on a server where you also have a PHP capable webserver I would go with phpMyAdmin to manage it.

Share this post


Link to post
Share on other sites
Quote:
Original post by BLiTZWiNG
Hmmm Visio is pretty good, but it really depends on what you actually want to design. Pen and paper is pretty good too. So is Excel.

Hm, I haven't had a look at Visio - I'll do that thanks. I'm not too keen on Excel as I find it pretty difficult to shift information about as required while still keeping the graphical arrows there pointing to the correct information.

Quote:
Original post by ApochPiQ
What database engine are you planning on using? Most engines come with decent visual design tools, or have open-source tools available.

I'm not using any particular database engine - it is a home brewed one, I'm just after something to help me piece it all together.

Quote:
Original post by ractoc
Personally I use the pen and paper approach most often. Depending on the project. If the project requires me to document it all I prefer to use Visio for that, although the symbols needed can also be found in WORD (I think).

For actually managing the tables in the database, that depends on your personall preference and the database you are using. Excel doesn't really need an external tool for that. SQLDeveloper from Oracle can connect to Oracle (Duh..), Access and MySQL. The best feature support is with Oracle though.
If you are running mySQL on a server where you also have a PHP capable webserver I would go with phpMyAdmin to manage it.

I've tried the pen and paper method but things get so messy the amount of times I change things... :( I'll have a look at Visio, maybe it could help.

Thanks all,
NB.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this