Questions tagged [erd]
Entity Relationship Diagram (ERD) or Entity Relationship Model is a visual representation of the organization of data within databases or information systems
1,207
questions
443
votes
9
answers
705k
views
How to generate an entity-relationship (ER) diagram using Oracle SQL Developer
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?
- 4,531
257
votes
13
answers
307k
views
How to visualize the relationships between tables of a database schema? [closed]
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 third-party ...
- 10.5k
81
votes
2
answers
56k
views
Django - Model graphic representation (ERD) [closed]
I'm searching a way to represent my Django project model graphically.
Is there a "native" way to do this kind of ERD (diagram) ?
Update following @Etienne instructions
Here is an example of ...
- 45.6k
62
votes
4
answers
208k
views
Generate ER Diagram from existing MySQL database, created for CakePHP [closed]
For CakePHP application, I created MySQL database.
Which tool to be used to create ER Diagram of database? Fields and relations between tables are created in a way cakePHP likes.
thank you in ...
- 11.1k
57
votes
6
answers
35k
views
Is ERD considered a kind of UML diagram?
Are Entity Relationship Diagrams(ERD's) considered a type of UML diagram or are they a separate thing?
- 868
54
votes
6
answers
56k
views
Equivalent of ERD for MongoDB?
What would be the equivalent of ERD for a NoSQL database such as MongoDB?
- 681
44
votes
4
answers
42k
views
What mysql database tables and relationships would support a Q&A survey with conditional questions? [closed]
I'm working on a fairly simple survey system right now. The database schema is going to be simple: a Survey table, in a one-to-many relation with Question table, which is in a one-to-many relation ...
- 86.4k
42
votes
4
answers
43k
views
High-quality ERD generator for PostgresQL under Linux? [closed]
Background
MySQL Workbench can produce appealing and high-quality ERDs such as:
Research
What PostgreSQL ERD tools are available that meet the requirements? The following are unsuitable:
...
- 30.9k
38
votes
2
answers
42k
views
Anyone have an ERD symbols quick reference? [closed]
I'm looking for a one-page quick-reference or cheatsheet (preferably in PDF) to the meanings of the various ERD symbols in Crowsfoot/Martin notation.
I've done a lot of googling, but have not found a ...
- 13.6k
38
votes
4
answers
23k
views
Pgadmin III Alternative - Windows [closed]
I am looking for an alternative to the free pgAdmin III that works on windows. I basically need it for managing my tables / views / SP / etc. If it did ER diagrams, that is a huge plus, and I like ...
- 2,895
37
votes
5
answers
193k
views
How to identify a strong vs weak relationship on ERD?
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 ...
- 1,673
36
votes
5
answers
62k
views
Difference between ER diagram and Class diagram
I have been given a description and need to draw ER diagram and Class diagram for the description.
Now I am having issue with understanding the differences between these 2 diagrams.
When I draw the ...
- 3,295
30
votes
5
answers
61k
views
What GOOD tools are available for generating ERD from a SQL Server Database? [closed]
I am trying to generate an Entity Relationship Diagram from an existing MS SQLServer 2005 database. What tools are available? Specifically,I am not only interested in ERD's more directly I am looking ...
- 1,287
28
votes
12
answers
77k
views
What's a Good Database ERD Tool for Linux? [closed]
I've recently switched to Linux on my work machine and, new to the Linux desktop environment, I'd like to find a decent ERD tool for database design. Booting back into my Windows partition every time ...
- 40.9k
27
votes
3
answers
56k
views
Difference between ER diagram and EER diagram
What is the difference between ERD (Entity relationship diagram) and EERD (enhanced entity relationship diagram)?
- 299
26
votes
8
answers
71k
views
How to create a PDF database diagram in SQL Server?
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 ...
- 2,587
23
votes
5
answers
46k
views
Database design for a recursive relationship
Consider this case where I'm trying to model a database for a company:
Entities: Employees, Managers, Departments.
An Employee works in only 1 Department while a Department may have many Employees ...
- 5,688
22
votes
4
answers
11k
views
Create ERD type diagrams from Rails code
I'm beginning to learn Ruby on Rails, and looking at other peoples code. Is there any way to take an exisiting codebase and create object relationship diagrams or Entity relationship diagrams (ERD's) ...
- 8,109
20
votes
5
answers
20k
views
Neo4j - is it possible to visualise a simple overview of my database?
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 ...
- 1,604
20
votes
2
answers
73k
views
How to create an ERD using phpmyadmin
is it possible to create an ERD using phpmyadmin?
I see people posting the following link : http://goo.gl/0z3vFE
But this does not work for me, for some reason I don't have that option in the 'MORE' ...
user3481441
19
votes
9
answers
93k
views
Tools to generate a database diagram/ER diagram from existing Oracle database? [closed]
Looking for tools (windows platform) to genereate ER diagram (or similar) from an existing Oracle database.
Any good tools out there that are free to use or low cost?
- 7,340
19
votes
1
answer
51k
views
Generating ERD diagrams within Visual Studio
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 ...
- 8,323
18
votes
4
answers
26k
views
How are super- and subtype relationships in ER diagrams represented as tables?
I am learning how to interpret Entity Relationship Diagrams into SQL DDL statements and I am confused by differences in notation. Consider a disjoint relationship as in the following diagram:
Would ...
- 312
18
votes
2
answers
6k
views
Is it possible to style an Entity Relation Diagram with Mermaid.js like Flowcharts to indicate a difference in entities?
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;
class ...
17
votes
6
answers
35k
views
Differences between a conceptual UML class diagram and an ERD?
If I create a conceptual class diagram such that each class captures 'name' and 'attributes' but not 'operations', have I not basically created what would be otherwise considered an ERD? I'm trying ...
- 203
16
votes
1
answer
24k
views
Tool to generate a ERD (entity-relation diagram) based on JPA annotations
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-Based ...
- 4,656
15
votes
5
answers
5k
views
SQL - Query - max(count())
I'm studying for my Database Systems Exam (tomorrow) and I'm having trouble in exercises where I'm asked to write queries. Here's an example:
I am being asked to write a query to answer the following ...
- 468
14
votes
2
answers
15k
views
How to import your existing table structure in EER diagram using MySQL Workbench?
I just want to ask about my problem. Right now I have an existing database and tables. And I want to get the structures of every table. I just need to get their column name for comparison for other ...
- 7,352
14
votes
4
answers
8k
views
Which should be created first ER Diagram OR Class Diagram?
The very first step i created a DFD. Then i moved on to create a Class Diagram. And while doing that i felt that i should create the ER diagram first. As there were many details which could not be ...
- 1,621
13
votes
4
answers
49k
views
Single line with an arrow mark in Entity Relattionship diagram
What do single line with an arrow mark in ER diagram represent?
- 151
13
votes
2
answers
35k
views
Inheritance relationship in ERD diagrams
I have question about inheritance representation in ERD-diagram.
The following example:
I have plane, and I have also two types of planes
1-PersonsPlane
2-CargoPlane
I am confused about which ...
user3151426
13
votes
1
answer
16k
views
What do the mysql workbench column icons mean in ER Diagram?
Can any one help me in explaining about the icons in the ER Diagram of Database created in MySQL Workbench.
Blue Diamond (Filled);
Blue Diamond (unfilled);
Red Diamond, et cetera;
Thanks!
- 143
13
votes
2
answers
23k
views
When to use UML Association Classes?
Can I improve my design on these 2 diagrams below? If so, how?
I am confused by the use of association classes in my diagrams. Should I use them?
Figure 1
Figure 2
- 328
12
votes
3
answers
24k
views
How to decide whether to use ER or UML for modelling?
A UML diagram can be used both to model database designs and class designs, but an ER diagram should be used exclusively in database problems. How do you pick one graphical representation over the ...
- 1,939
12
votes
3
answers
11k
views
How represent multiple similar foreign keys in ERD database diagram?
I'm making an ERD of my database, and am stuck with a little dilemma.
Consider the tables foo and bar. foo has three columns that are foreign keys, referencing to bar's primary key. My question is: ...
- 3,640
12
votes
4
answers
12k
views
ER Diagram - Showing Deliveries to Office and to its Branches
For a small project, I am creating an entity relationship diagram for a simple stock-tracking app.
User Story
Products are sold by product suppliers. Products are ordered by an office and ...
- 411
11
votes
2
answers
19k
views
One to many relationship on the same table
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 ...
- 213
10
votes
3
answers
6k
views
Saving diagram failed! Verify that Graphviz is installed and in your path, or use filetype=dot
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 ...
user1670773
10
votes
2
answers
12k
views
MySQL Workbench - Rearranging Schema Diagram - Autolayout not working
I am using MySQl Work-bench 2 to construct a schema diagram., by reverse engineering the database. However, when I included 450 tables., the tables are getting overlapped with one another and its ...
- 3,229
10
votes
2
answers
21k
views
Use Draw.io to generate SQL / DDL scripts?
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://desk.draw.io/...
- 1,528
10
votes
2
answers
25k
views
How to Draw UML Diagram for NoSql Like MongoDB? [duplicate]
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?
- 119
10
votes
0
answers
845
views
How to adjust the relationship line between tables when the position of tables are changed in pgAdmin4?
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 ...
- 101
9
votes
1
answer
10k
views
Modeling 3 entities with relationships
Say we have three entities in our environment, Teacher, Student and Course.
Every teacher has (teaches) 1 or more Courses and each Course is offered by 0 or more teachers
Every Student has taken 1 or ...
- 2,392
9
votes
1
answer
5k
views
TypeORM: how to implement bidirectional relationship, multiple fields --> one entity type
I've created a 'document' entity:
e.g.
@Entity()
export class Document {
@PrimaryGeneratedColumn()
id: number;
@Column()
name: string;
@Column()
path: string;
...
}
Multiple ...
- 775
8
votes
7
answers
26k
views
Open source ER diagramming tool for mysql [closed]
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 to ...
- 25.1k
8
votes
5
answers
6k
views
How to present a database design?
I am doing a project in the university and it includes a MySQL database. I have a design for the database in terms of a list of tables and their respective fields.
In what form should I present this ...
- 78.1k
8
votes
2
answers
9k
views
Avoid Circular Dependency
I am developing a travel management application. The design in question is something like following :
Each person in a tour is designated as a Traveler.
Each Traveler has a Passport.
Now, a Traveler ...
- 1,511
8
votes
2
answers
4k
views
Database design normalization help needed (5nf)
Can you guys show me how to get this ERD in 5th normal form? We did a class assignment yesterday where we had a real client come in and explain to us his need my group came up with this model I am ...
- 1,141
8
votes
1
answer
2k
views
PGAdmin create ERD from explicitly selected tables?
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?
- 441
7
votes
2
answers
12k
views
what is the differences between that line in oracle ERD?
What is the differences between that relationship lines in oracle ERD?
- 698