Jump to content

mysql database design tool ?


RJ

Recommended Posts

This may be a good tutorial on how to optimize your tables (normalization):

 

http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html

 

You want to think of each table as a box that sorts things such as toys. Lets say you have three boxes:

 

- Box 1 holds dolls

- Box 2 holds balls

- Box 3 holds legos

 

You have now sorted all the toys, and it is easy for my mysql to search that box to find a specific toy!

MySQL Workbench is pretty good and its free.  As mentioned above TOAD is a pretty awesome app, I use it to administer Oracle which is their target audience ie TOAD = (Tool for Oracle Application Development). But their mysql version is pretty solid.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.