I am searching for a tool which can design ER diagram for my MySQL database automatically. If anybody used this kind of tool then please let me know.
Try Googling MySQL Workbench. It's free and pretty decent.
AT one point, PHPMyAdmin used to have a plug-in or something to do this automatically.
All you had to do is link your foreign/primary keys when you design your tables. (The data was stored in some other table, not in your database).
Anyone remember what was it called?