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?
MySQL Workbench make entity-relation schema of your database.