EER diagram in mysql workbench

Question

I need to make an EER diagram of my database. When I connect my database to MySQL Workbench it puts lines only between two tables with a FK on them. Do I need to manually put in the other lines where I don't have FK's but I connect two tables with a third middle one?

Is this EER diagram a logical (conceptual) database or a physical database? What exactly is a logical database? A logical database is a blueprint of the database. But how do I describe tables?

score 1 · Accepted Answer · answered Jan 21 '15 at 05:02

1

MySQL Workbench make entity-relation schema of your database.

Here you can find some good info and here in wikipedia

answered Jan 21 '15 at 05:02

Goro

499
1
13
31

score 1 · Answer 2 · answered Dec 01 '16 at 08:34

1

In MySQL Workbench you can create a logical diagram. It is misnamed in MySQL Workbench as an "EER diagram" as far as I know. A logical diagram such as in MySQL can be created on the basis of an EER diagram.

An example of an EER diagram from Wiki is:

answered Dec 01 '16 at 08:34

Jurgenfd

230
3
13

Thank's for the answer. It will be handy for other users. – S.I. Dec 01 '16 at 09:44

EER diagram in mysql workbench

2 Answers2