Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [database-diagrams]

157 questions
19
votes
5 answers

How to represent foreign key in an ER diagram?

I have a Transactions table which has a column Customer ID (foreign Key) and a Customer table having ID (primary key). How do I show in an the relation between the two tables showing that the Customer ID is the foreign key of Transactions which is…
MK Singh
  • 299
  • 1
  • 2
  • 3
15
votes
3 answers

Modeling a scenario in which each Music Artist is either a Group or a Solo Performer

I have to design an entity-relationship diagram (ERD) for a business context that involves the delineation of music artists, as I will detail below. Scenario description An Artist has a Name, and must be either a Group or a Solo Performer (but not…
Boshir
  • 151
  • 1
  • 3
12
votes
3 answers

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

I don't understand the ERDs used by DBeaver. The diamonds and dots at the ends of the line arent the crow's foot I'm used to. I've googled the subject and checked the docs but can't find a straight-forward answer. Is there a reference for the style…
Dawoodjee
  • 498
  • 1
  • 4
  • 12
11
votes
2 answers

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

I have a database on SQL Azure and want to create a database diagram for that, but don't want to have to install SQL server and copy the database etc. Is there any way that I can do it that anyone knows of?
Y8sy
  • 113
  • 1
  • 1
  • 6
8
votes
1 answer

Ternary relationship: what's the difference between having single table and having multiple tables?

Consider the following ternary relationship: Suppose that all entities have only two attributes (PK and Name). Here are the tables I derived (5 tables): Sector ------------------------- ID_Sector …
feelthhis
  • 265
  • 1
  • 3
  • 10
7
votes
1 answer

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

I am trying to crate entity-relationship diagram for a transport company database. This database should store information about letters, deliveries, moving letters from one warehouse to another, and historical information. It should allow tracking…
Igor
  • 173
  • 6
7
votes
4 answers

Is it critical for a database to have a relationship table/diagram or not?

Got a question and wanted to get the best practices or thoughts on this. I have an application that was developed with a SQL Server back end (site is Entity framework, vb.net, asp.net). The original design does not have a database…
Valien
  • 745
  • 3
  • 7
  • 14
6
votes
2 answers

How to generate the E-R Diagram of Wordpress using mySQL Workbench

I am trying to generate the E-R Diagram of Wordpress using the 'Reverse Engineer' feature. There is a slight obstacle though. The diagram does not show the relationships between the entities. Is this the way it's supposed to work or am I missing…
Anon
  • 163
  • 1
  • 5
6
votes
5 answers

Automatically create ER diagram from database schema

I have a database with 193 tables and I need to create an entity-relationship diagram from them. There are no formal relationships between the tables with respect to FKs. The relationships are mapped with 1-* tables. The database in question is the…
Michael
  • 163
  • 1
  • 1
  • 6
6
votes
1 answer

Postgres 9.6 export the database structure as pdf

Is there any tool/software the can export all the tables structure (column names , its datatype ) in the database as a pdf/excel/word. additional diagram export will be added advantage.
Abhijit Gujar
  • 279
  • 1
  • 3
  • 12
5
votes
1 answer

How to model an “is a” relationship in an ERD using Crow’s foot notation?

I have to create an entity-relationship diagram (ERD) for an assignment. I am doing this in a particular drawing tool with the Crow’s Foot notation. There is however one thing I cannot figure out: How would you present an “is a” hierarchy in Crow’s…
Some_student
  • 51
  • 2
5
votes
2 answers

Financial database design

I am working on an application to store financial data and need to model the tables where the data for several financial statements will be stored. I came up with the following two designs but I can't decide on which one to use. Appreciate your…
Nabegh
  • 153
  • 1
  • 1
  • 5
5
votes
2 answers

Can relationships have relationships?

I have the following requirements (as part of a larger system). In the database, I need to maintain a list of parts, suppliers who sell those parts. Many suppliers can sell the same part and each part can be sold by many suppliers. However, the…
CodyBugstein
  • 253
  • 1
  • 3
  • 10
5
votes
2 answers

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

I have created the entity-relationship diagram (ERD) shown below (for brevity, each individual bubble-shaped box portrays multiple attributes): Considering such an ERD, I have to convert each entity type or associative entity type depicted there…
shinzou
  • 253
  • 1
  • 9
5
votes
3 answers

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

Background I am attempting to insure I understand how to read ERD (Entity Relationship Diagram) notation so I can convert it to a natural language explanation. I'm trying to insure I can explain a method of converting what I see in the diagram to…
raddevus
  • 201
  • 1
  • 3
  • 7
1
2 3
…
10 11