I'm writing a java code using ormlite. I was wondering if it's possible to generate an ERD from the JPA annotations in my code. Basically, I need the reverse of this: How can I transform Entity-Bas...

I have the ability to generate an ERD from an entire DB. My DB is huge and I want to focus on a subset of table relationships. Is this supported in PGAdmin?

I created two tables and built a foreign key between them, now I want to reorganize position of the tables in ERD (pgAdmin4 - version 6.14). I'm try reorganize, but I cannot, see image-01: My expe...

When do we need to use a 1-to-1 relationship in database design? In my opinion, if two tables are in a 1-to-1 relationship, they can be combined into one table. Is this true?

I've got my graph database, populated with nodes, relationships, properties etc. I'd like to see an overview of how the whole database is connected, each relationship to each node, properties of a ...

I want to reverse engineer (import into diagram form) the database definition dump of a database I have, then since no foreign keys are defined in this particular database, I want to be able ...

I can't seem to style any elements within my ERD. Having an entity called PERSON, any of the following code results in a syntax error: style PERSON fill:#f9f; or classDef className fill:#f9f; cla...

I've downloaded MySQL workbench and can create a EER diagram. What's the difference between this and a UML diagram? Where does a ERD come into this?

There are a lot of resources on internet about how to import tables into ER diagram on Draw.io using sql script. For example here (but I find plenty of resources googling): https://www.drawio.com/d...

In an ERD, a weak/non-identifying relationship is one that connects two strong entities, and is indicated with a dashed line. A strong/identifying relationship is one that connects a strong entity ...

I want to use Oracle SQL Developer to generate an ER diagram for my DB tables but I am new to Oracle and this tool. What is the process for creating an ER diagram in SQL Developer?

I would like to know that can i draw UML diagrams for my web application which has back end Mongodb? Or is there any other diagrams for NoSql?

A dashed line means that the relationship is strong, whereas a solid line means that the relationship is weak. On the following diagram how do we decide that the relationship between the Room and C...

When I run rake db:migrate I get this error rake aborted! Saving diagram failed! Verify that Graphviz is installed and in your path, or use filetype=dot. Full log: rake db:migrate Loading appl...

Is there a standard (non-graphical) notation for Entity Relationships? right now I'm using my own janky notation: User >> Photo , (1-many) User > Profile , (1-1 hasOne) Profile < User , (1-1 ...

I would like to generate an entity-relationship diagram (ERD) from an existing PostgreSQL database. What is the recommended approach to do this? Are there any built-in tools to do it? Or thi...

I have a relatively small database that I would like to generate a diagram for and then create a pdf of that diagram. I have the diagram created in SQL Server (all tables would fit on one page of a...

I am using MySQL. There are 28 tables in my database. I've tried to use MySQL Workbench to create E-R diagram. As there are 28 tables, everything is messed up in diagram using MySQL Workbench. Is t...

I've created a 'document' entity: e.g. @Entity() export class Document { @PrimaryGeneratedColumn() id: number; @Column() name: string; @Column() path: string; ... } Multiple document...

What do single line with an arrow mark in ER diagram represent?

What would be the equivalent of ERD for a NoSQL database such as MongoDB?

In order to create an ERD diagram for new projects I have been using Visual Studio's entity framework designer. Essentially I'm creating a "dummy project", adding entity framework via Nuget and dia...

Are Entity Relationship Diagrams(ERD's) considered a type of UML diagram or are they a separate thing?

Here is the situation:- I have a table called Users. This contains user data for students and tutors as most of the data required is the same. Having completed the system I am now told that the c...

Legend: PK (Blue): Primary key FK (Green): Foreign key PFK (Blue): Primary Key and Foreign Key at the same time How to model a diamond like (if term is correct) relationship? Better to expla...