Weak (Non-Identifying) Relationship Entity is existence-independent of other enties PK of Child doesn’t contain PK component of Parent Entity Strong (Identifying) Relationship Child entity is existence-dependent on parent PK of Child Entity contains PK component of Parent Entity Usually occurs utilizing a composite key for primary key, which means one of this composite key components … Read more
DataGrip/ IntelliJ IDEA Ultimate Edition If you are already a user of Jetbrains tools, you may try DataGrip (or the database plugin, when you are an IntelliJ IDEA Ultimate edition user). This is quite new, but suitable for most use cases. https://www.jetbrains.com/datagrip/ DBVisualizer DBVisualizer is a very good solution for connecting to “any” DBMS with … Read more
I’ve also been looking for a single-page “quick reference” PDF for ERD relationship symbols (i.e. “Crows Feet”). I haven’t found anything I’ve liked, so I created this. I’ve posted the Full Page, Printable PDF on my blog. Hope this helps!
This is a little bit dated question, but for completeness. What about PgModeler? According to their github repo it’s under GPL3. Schema creation works well.
This is a little bit dated question, but for completeness. What about PgModeler? According to their github repo it’s under GPL3. Schema creation works well.
You can use dbeaver to do this. It allows you to export the ER diagram as png/svg etc. DBeaver – https://dbeaver.io/ Double click on a schema (eg, Schemas->public->Tables) and open the “ER Diagram” tab (next to “Properties” tab)
Survey Database Design Last Update: 5/3/2015 Diagram and SQL files now available at https://github.com/durrantm/survey If you use this (top) answer or any element, please add feedback on improvements !!! This is a real classic, done by thousands. They always seems ‘fairly simple’ to start with but to be good it’s actually pretty complex. To do … Read more
I have another idea. I think we should look in-depth. When we are talking about ERD (Entity Relationship Diagram), we are talking about Entity Relationship Modeling. It is firstly introduced by Peter Chen (1976). He has two famous articles on Entity Relationship Modeling (see first and second articles) He talked about Entity-Relationship Modeling (not Entity-Relationship … Read more
It looks like you asked a similar question on Quora. As mentioned there, the ERD is simply a mapping of the data you intend to store and the relations amongst that data. You can still make an ERD with MongoDB as you still want to track the data and the relations. The big difference is … Read more
Use MySQL Workbench. create SQL dump file of your database Follow below steps: Click File->Import->Reverse Engineer MySQL Create Script Click Browse and select your SQL create script. Make Sure “Place Imported Objects on a diagram” is checked. Click Execute Button. You are done.