asked on

which database modeling tool I need use

Dear all database experts here:

I am a beginner of database design. I want to have a tool to draw ER - Diagram and make script to create Mysql or Oracle database. Which tool is good for it?

1. Navicat http://www.navicat.com/download/navicat-premium

2. Enterprise Architect: http://www.sparxsystems.com/products/ea/purchase.html

3. DBDesigner 4 http://www.fabforce.net/dbdesigner4/

Also, I am asking if I draw the ER diagram and normalize them, how could I verify my design is a good design?

ASKER CERTIFIED SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jason Yu

ASKER

Thank you a lot, it's really a good answer, but I am willing to hear more answers if possible. Any comments will be appreciated and encouraged.

Thanks in advance.

slightwv (䄆 Netminder)

>> I am willing to hear more answers if possible

I'm sure you will get additional posts. EE is world wide so it will take some Experts time to see this thread. Also, many Experts aren't as active around the week ends. Give this a few days and I'm sure there will be more activity.

SOLUTION

crystal (strive4peace) - Microsoft MVP, Access

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

David VanZandt

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jason Yu

ASKER

Thank you guys, I got a basic idea of what a data modeler is and will start from here with my database design journal.

Have a nice thanksgiving for all of you!