Skip to main content
14 votes
Accepted

What do the entity-relationship diagram (ERD) symbols used in DBeaver mean?

I found something while putting together this question. It seems the current standard used is IDEF1x, according to this github issue. I found a PDF cheat sheet with the following content showing all ...
Dawoodjee's user avatar
  • 498
10 votes
Accepted

What is the best way to create a database diagram for SQL Azure without having to install SQL Server?

UPDATE: The database diagrams were added back into SSMS 18.1(link) UPDATE: the database diagram feature Deprecated and removed features in 18.0 (GA) ... Database Diagrams https://learn....
user1843640's user avatar
7 votes
Accepted

How to model a Letter Transportation business context in a database diagram?

Although you stated that the structure depicted in your diagram is part of a university project, the objective should be to make it as realistic as possible, so I consider that carrying out an ...
MDCCL's user avatar
  • 8,520
6 votes
Accepted

Scripting Creation Of Database Diagrams

The Database Diagram objects are indeed created using T-SQL. You can see what SSMS does when creating, editing, and saving diagrams by running a T-SQL trace against your development SQL Server while ...
Hannah Vernon's user avatar
  • 70.2k
6 votes

Postgres 9.6 export the database structure as pdf

You need a Entity Relation Diagram (ERD) generator. The most popular and advanced one that I know of that is FOSS is SchemaCrawler. It does everything you want anyway. Though the diagrams are ...
Evan Carroll's user avatar
  • 63.7k
5 votes
Accepted

How do I read ERD Notation (crow's feet) to convert to Natural Language?

I'd like to answer this more definitively now using the following image (from https://www.lucidchart.com/pages/ER-diagram-symbols-and-meaning) Using the definitions of these symbols you can see that ...
raddevus's user avatar
  • 201
4 votes
Accepted

How can I represent the entity types depicted in an ERD as relations with attribute names?

Considering the Course entity type that you describe, I have made the following assumptions: A Course is primarily identified by its CourseNumber A Course is alternately identified by its Name A ...
MDCCL's user avatar
  • 8,520
4 votes

How to represent foreign key in an ER diagram?

Many years later, please mind the different notations of ER diagrams, the question is thus not precise enough. Have a look at all answers at: Is ERD considered a kind of UML diagram? Which one is an ...
questionto42's user avatar
4 votes
Accepted

Replacing the removed database diagrams feature

Update to the latest version of SSMS. The database diagrams feature was reinstated starting with version 18.1.
osiris_v6's user avatar
  • 184
3 votes
Accepted

Understanding Table design in database

The database is an encoding of the business rules. Without understanding the rules there is no way of making sense of the database. Take it piece-by-piece, focusing on one area until you have a ...
Michael Green's user avatar
3 votes

Automatically create ER diagram from database schema

It may be more trouble than its worth but there is a paper on reverse engineering relational database schemas: Clustering relations into abstract ER schemas for database reverse engineering This ...
Rankinstein's user avatar
3 votes

What does the Union sign in EER diagrams mean?

It means that the publication can be of type chapter, article, or book. That makes publication different from overlap and disjoint. When it comes to disjoint or overlap of entities, the topic ...
vidya's user avatar
  • 51
3 votes
Accepted

Is it possible to change the color of relationship lines in MySQL Workbench diagrams?

I found a solution to help. Close Workbench. Change the theme of your mac in clear mode. Restarts Workbench and saves again in pdf.
nMulot's user avatar
  • 46
3 votes

Error 1005 when Forward Engineering EER diagram

Error 150: Plan A: Rearrange the order of CREATE TABLEs Plan B: Disable FKs, create the tables, enable FKs. Plan C: Create the tables without FKs, then add ALTERs to add the FKs.
Rick James's user avatar
  • 78.5k
3 votes

What do the entity-relationship diagram (ERD) symbols used in DBeaver mean?

A link to the IDEF1X notation is actually provided in DBeaver's online docs: https://dbeaver.com/docs/wiki/ER-Diagrams/
datsb's user avatar
  • 185
3 votes

What do the entity-relationship diagram (ERD) symbols used in DBeaver mean?

Here is an image from DBeaver Documentation showing relationship notations This is the link: https://dbeaver.com/docs/wiki/Database-Structure-Diagrams/
Mohammad Sharara's user avatar
3 votes

Database diagram for linked server tables

There's no way to do this with the native tools within SQL Server Management Studio. You could get a third party tool like ER/Studio, but even that won't automatically model the linked tables. You'll ...
Grant Fritchey's user avatar
3 votes
Accepted

What is the Relationship between Instagram users and user followers

The relationship between Instagram user and follower is many to many because: One user can have multiple followers. One follower can have multiple "followed users". Useful: Always name the entities ...
Hashir's user avatar
  • 146
3 votes

How do I produce the relationship diagram in Microsoft Sql Server?

it is called EER can be foundin SSMS 18 under Visual database tools Design Database Diagrams. you find it in the SQL Server Management Studio (SSMS) https://learn.microsoft.com/en-us/sql/ssms/visual-...
nbk's user avatar
  • 8,434
2 votes

I can't save Database Diagrams

I was in a similar situation, unable to save a new diagram even though I had several others. In SSMS I manually added a new row to the sysdiagram table with the name of my new yet unsaved table. Then ...
RogerB's user avatar
  • 121
2 votes

Feedback on an entity-relationship diagram for a movie theater business domain

The following are examples used to convey the point, there are multiple instances of each of these examples within your ERD. Naming Consistency is key. Some table names are pluralised (Seats) some ...
Ben's user avatar
  • 462
2 votes
Accepted

Modeling an entity-relationship diagram about Clients, Orders, Payments and Bills

First of all you have to define your entities. So I see 4 entities: Client Order Product Payment With these 4 entities you can create your bill from the information that is already stored in the ...
Treasa Ní Mhaoltuile's user avatar
2 votes

How can I represent the entity types depicted in an ERD as relations with attribute names?

In general, you need predicates (relations) and constraints. Start with a predicate, .. P1 Course named (C_NAME), assigned a course number (C_NUM), exists. .. and constraints c1.1 For each course ...
Damir Sudarevic's user avatar
2 votes
Accepted

SQL Server Database Diagram

Database diagrams have been re-added as of 18.1 in SSMS.
LowlyDBA - John M's user avatar
2 votes
Accepted

Setting up relationships on a gaming schema with multiple locales

Your approach is the correct one if the typical workload consists of small transactions that access only a few rows at a time (OLTP). The extra join won't hurt, because it will be a nested loop join. ...
Laurenz Albe's user avatar
  • 53.4k
2 votes
Accepted

Chat/conversation history, entity relationship diagram

Some loose opinions which may be useful but may be completely off: The model looks OK and should be scalable as far as I can tell. Relational model (3NF) is the king of storage size, and data ...
filiprem's user avatar
  • 6,579
2 votes
Accepted

How do I represent foreign key in an Extended ER Model in Chen notation?

I think I found the answer, it is more or less not possible and anyway not intended in an ERM. There is a small workaround left in using double underlining. There is simply no FK to mark in an ...
questionto42's user avatar
2 votes

what is best way to handle history tables in postgresql?

I suggest exploring database normalization and how it drives schema design, and look at how sakila/pagila implements the movie store concept. As for the proposed design, get rid of the subscription ...
dwhitemv's user avatar
  • 1,567
2 votes
Accepted

Database Design For Realty Website Review

The structure seems reasonable. The datatypes have some issues. "2-1/2 bathrooms" in an INT? Maybe DECIMAL(3,1). BIGINT is excessive for most cases. INT won't work for latitude and ...
Rick James's user avatar
  • 78.5k

Only top scored, non community-wiki answers of a minimum length are eligible