ER diagram

[sep1]

hi,
which tools(software package) can help for
design ER diagram for database?
please tell me.

[olivthill]

Let's suppose that ER means Entity-Relationship.

You have 3 options:

1. Use a general-puprose drawing software, e.g. Visio

2. Use a database system that includes an option for drawing diagrams based on the tables previously defined in the database, e.g. MS-Access has an option in the menu bar, for drawing pictures containing tables and links between them.

3. Use a software designed for making diagrams for DB, but which is not tied to any particular DB. They are some, but I have never used them myself, and I don't even remember how they are called.

---
There are 3 kinds of people, 1. those who know arithmetics, and 2. those who don't.

[hmc]

Sybase Powerdesigner is a great tool for designing ERD. When you are finished with ERD it lets you create your database automatically. It knows a variety of databases such as MS Access, MySQL etc.