CODEWITHSUNDEEP
mysqlsqlentity-relationshiperdworkbench
Miguel Martins
Miguel Martins

Reputation: 31

How to generate an ER diagram WITHOUT foreign keys (MySQL)?

I have to generate an ERD from my database to a school project. My teachers want the ER to not have foreign keys, only various relationships between the various entities. I have tried Visual Paradigm and now MySQL workbench using the reverse engineering option, but all of them generate the diagram with foreign keys, and I can't delete them.

Is there any option or other programs that generate the diagram according to these rules?

Upvotes: 2

Views: 4385

Answers (1)

rob2universe
rob2universe

Reputation: 7583

Consider distinguishing between ERD (conceptual or logical level) and Data Structured Diagram or physical ERD.

A logical ERD is functional specification. It does not show / specify database columns but entities, their attributes and relationships. A possibly purely technical attribute like a foreign key is not required on this specification level. The relationship between the entities are already represented by lines.

Adding the foreign keys is only require to specify the additional DB columns on the physical level for the mapping of the model to a database schema.

Upvotes: 1

Related Questions