S.I. S.I. - 4 days ago 5
MySQL Question

EER diagram in mysql workbench

I'm sorry about my 'nuewbie' question!

I must make EER diagram of my database but I have an question about it because it is not so clear for me. When I connect my database to MySQL Workbench it puts lines only on tables between two tables.. those with FK on them. Now do I need manualy to put the other lines where I don't have FK's because I connect two tables with third middle one?

Also is this EER diagram is logical (conceptual) database or this is physical database? What exactly is logical database? I mean I think I know what is logical database. This is blueprint of the database. But how to describe tables?

Answer

MySQL Workbench make entity-relation schema of your database.

Here you can find some good info and here in wikipedia

Comments