Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [database-diagrams]

145 questions
17
votes
5 answers

How to represent foreign key in an ER diagram?

Suppose 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 the relation between the two tables and showing that the 'Customer ID' is the foreign key of…
MK Singh
  • 271
  • 1
  • 2
  • 3
13
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
  • 131
  • 1
  • 3
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
2 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
  • 398
  • 2
  • 9
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
  • 715
  • 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
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
  • 2
  • 12
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
  • 7
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
  • 3
  • 7
5
votes
1 answer

ERD for a web development company

I am working on an ERD which represents the relationships between entities in a Web development company behavioral model. There I have entities like: Customer Service ----------- (like: web development, web design, web consultation, ...) Order-item…
Pmpr
  • 157
  • 1
  • 9
4
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
  • 41
  • 2
4
votes
1 answer

Database design for an exam system

I am working on creating a simple exam system, in which you are going to be basically able to store students, classes, exams, questions and scores(and some other stuff that those depend on). I am also using Entity Framework code-first. I am using…
Phoenix
  • 143
  • 1
  • 4
4
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
  • 143
  • 1
  • 1
  • 6
1
2 3
…
9 10