Questions tagged [database-diagrams]
The database-diagrams tag has no usage guidance.
0
votes
0answers
18 views
Is it possible to change the color of relationship lines in MySQL Workbench diagrams?
I have MySQL Workbench Community Edition 8.0.15 installed on my Mac OS 10.14.3. I'm currently working on making an ERD with Workbench's EER Diagram.
My problem is that whenever I export my diagram, ...
0
votes
1answer
49 views
Creating and querying a database to set hierarchical associations between Groups, Users, Items and Points
I am working with three entity types, Group, User and Item. A Group consists of Users, and a User consists of Items.
Now, I have to work with a fourth entity type: Point. I want to be able to ...
0
votes
0answers
18 views
Relationship constrains in EER
When designing a EER diagram, how do you state or show a specific relationship constraint between entities (or can this even be done).
We have a relationship between two entities E and F, but for a ...
0
votes
0answers
66 views
Multiple tables for different types of transactions?
Considering a trading system as an example. Would it make sense to have two different tables for credit transactions and asset transactions?
creditTrans : table
id
userId
transType
status
amount
...
0
votes
1answer
87 views
How to maintain customer addresses for Orders?
The database I am designing is part of a project I am working on. I have come up with 3 simple "business rules":
Customers must either be Individuals or Businesses (a business belongs to a certain ...
1
vote
0answers
182 views
Gaming shop database schema
I'm trying to design schema for my personal project that would be an online gaming shop. I would like to ask you guys for any suggestions/tips on how could I maybe improve my current draft.
Concerns:
...
2
votes
0answers
98 views
Modelling a database for a simple IT device tracking scenario
Sorry, my English is not that good.
I need a simple IT device tracking sytem at work.
For each device I need to know its current location, status and ownership (employee to which it is assigned).
...
1
vote
0answers
125 views
Modelling an entity-relationship diagram for a scenario involving companies, services, and clients
I am creating an entity-relationship diagram (ERD) for managing workflow and other details of Company X in which I am maintaining details of the following objects:
Employees of Company X
Services ...
1
vote
0answers
36 views
Creating an entity-relationship diagram about an art fairs and galleries business environment
Scenario description
The charactheristics of the business domain under consideration are:
Each and every art item has a unique identifying number, and also a name and asking price.
Art galleries ...
2
votes
1answer
311 views
Do you know if this are examples of non-identifying or identifying relationships?
Im using MySQLWorkbench to model a diagram. But Im with some doubts about identifying and non-identifying relationships. It seems that all relationships of the project are identifying.
For example, a ...
0
votes
2answers
38 views
payment table in relational datase
I have to model a database table for payments. These need to have two fields payment from and payment to and this needs to link to two tables one is clientA and clientB as in the representation below. ...
1
vote
1answer
22 views
How to express a “some of which are” and “not all are” relationship with enhanced entity-relationship diagrams?
For example:
Gardens have attribute gate, Condos have attribute door. Some of the Gardens and Condos are Private_Properties. On the other hand, Private_Properties are not restricted to only Gardens ...
0
votes
1answer
987 views
MySQL WorkBench SQL : Cannot Add Foreign Key Constraint (Error 1215) while creating database
Problem:
I am receiving the
Error 1215: Cannot add foreign key constraint
error while running my MySQL schema code generated from the EER Diagram I used to model my database.
The Error occurs ...
0
votes
1answer
441 views
How do I change where database diagram relationship lines attach in MySQL Workbench?
Sometimes, MySQL Workbench makes some strange choices about where table relationship lines get attached. For example, two vertical lines would be better in the following:
For a while, these boxes (...
1
vote
1answer
84 views
Representing a many-to-one relationship in a database diagram
I have two tables loadingDetail, and stowageDetail:
loadingDetail | stowageDetail
[PK] loadingID (int) | [PK] StowageID (int)
[PK] transactionID (in) | [PK] room (int)
...
2
votes
1answer
129 views
Scripting Creation Of Database Diagrams
Is it possible to script the creation of a database diagram using T-SQL?
If not, what is the Database Diagram Designer doing when you use it to save / edit a diagram (is it using PowerShell or some ...
1
vote
0answers
160 views
Basic ERD analysis for a martial arts business domain
I am working on a basic website in order to support querying results from martial arts tournament data. We use participation data to determine things like who gets to host tournaments, regional awards,...
0
votes
0answers
44 views
Issue with diagrams in sql management studio 2014
I have this issue with sql management studio 2014.
When creating a new database diagram and when I add existing table to a new diagram, the data inside a table is obsolete. I tried both dragging a ...
3
votes
0answers
27 views
How to design a database for my entity-relationship diagram about Projects, Tasks and Developers
I'm new to database and my entity-relationship diagram is as follows:
According to that I designed my SQL-DDL database statements as shown below:
CREATE TABLE Developer (
DeveloperID int NOT ...
1
vote
1answer
700 views
Feedback on an entity-relationship diagram for a movie theater business domain
I have an assignment due next week, and for that assignment I am supposed to learn MySQL and create an entity-relationship diagram (ERD).
My current attempt
Now I've made this ERD
The issue
I ...
0
votes
0answers
154 views
Representing a bus maintenance business domain in an entity-relationship diagram
I'm having problem representing scenario using an entity-relationship diagram (ERD). I will post what I was asked to do and what I tried, hoping you could share your expertise and help me correct it.
...
1
vote
1answer
621 views
Modeling an entity-relationship diagram about Clients, Orders, Payments and Bills
There is a part of an entity-relationship diagram creation that troubles me, I don't know if it's ok. I tried to follow these instructions:
A client makes an order (which has products).
When the ...
0
votes
0answers
433 views
In an ER diagram, do all entities need to be connected?
I am building a model DB of an online store. I have obvious tables such as Customers, Stores, Products, etc...
I made an ER diagram, but I realized that my Employees table is sitting out by itself ...
1
vote
0answers
24 views
PostgreSQL table relationship clarification
I am in the process of setting up table relationships, using a relational diagram provided by our vendor, in PostgreSQL 9.5.3 and am seeking clarification on how to relate a child table that serves ...
2
votes
3answers
1k views
How to interpret ternary relationship
I have tried to search online on how to interpret these ternary relationships but haven't found any clear answer. Since I don't understand how to interpret it I am having trouble changing it into ...
1
vote
1answer
182 views
Modeling a Recursive Association for Linking an Entity Type to Itself
I am designing a simple database as follows:
The database should contains an evolving set of standards;
each standard has a library of controls;
A single control in each standard may map to one or ...
0
votes
2answers
221 views
Entity-Relationship Conceptual Data Model [closed]
So I am busy learning databases for an rpg I have been thinking of to learn more specialized techniques with game development itself. Now I am trying to draw a conceptual data model to get things ...
0
votes
1answer
26 views
M:M Relationships
I have question regarding joining tables using composite keys.
If I have two tables: "Sales" and "Items" with a M:M relationship between them and my data schema included a joining table called "...
6
votes
1answer
900 views
Postgres 9.6 export the database structure as pdf [closed]
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.
2
votes
1answer
78 views
Understanding Table design in database [closed]
I have 3 years of SQL Server development work experience. Now I am moving to a new company (first jump). I heard in my new company they deal with too many tables.
What is the best way to understand ...
2
votes
0answers
74 views
How can you use an entity-relationship diagram to document business processes?
Past exam question: How can you use an entity relationship diagram to document business processes?
As far as I know, I would use an entity-relationship diagram (ERD) to document the relationships ...
-1
votes
1answer
2k views
How to generate Database Diagram using script?
I need to create a SQL script to generate a Database diagram.
It should accept two parameters:
DB name
Schema
It should create a database diagram in Database Diagrams folder with the underlying ...
0
votes
1answer
85 views
EER Design specification
I just started learning about Databases, and my first assignment has information about an Art Museum that we are supposed to use to define a DB for, demonstrated with an EER Diagram.
One ...
2
votes
2answers
78 views
Two paths between two entities
In my db the entities are:
designed_object: a generic designed object
designed_object_param: a parameter related to the designed object with the type (param_type), the default value (param_value), ...
0
votes
1answer
113 views
Query For All Constraints in a SQL Database Diagram
Is there a way to show constraints in a SQL Server db diagram?
Like for example, in a card number, it shows there is a CHECK constraint etc..
5
votes
2answers
257 views
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 ...
8
votes
1answer
800 views
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 ...
0
votes
1answer
622 views
Generate database diagram from SQL Server with no proper integrity
So... I've ended up in a project, which by far is the worst quality POS I've seen in a long while. It is basically a Visual Basic .NET windows client application used for various administrative tasks ...
3
votes
1answer
707 views
Ternary Relationship or (n-ary)
I'm trying to find the difference in terms of modeling a ternary relationship v/s a binary relationship in the following case. Any piece of advise would help me a lot.
Company has editors who are ...
0
votes
1answer
1k views
I Need Help With My Database Design for Product Management
I'm designing a MySQL database and the front end for my work. The database will store all of the products that we sell on our marketplaces and their relevant data. We will be able to lookup products ...
2
votes
0answers
486 views
What is the difference between (Superclass/Subclass) Total and Partial Specialization?
What is the difference between total and partial specialization of superclass/subclass (or supertype-subtype) structures in enhanced entity-relationship modeling?
3
votes
0answers
639 views
ERD for a Contract between a Writer and a Publisher: Is it correct, can it be simpler?
I created an entity-relationship diagram (ERD) for a book publishing business context that I will detail bellow.
Entity types
The entity types of interest are:
Writer
Work (as a book)
Publisher
...
1
vote
0answers
235 views
ER Diagram - Choose One or Both of the Entities
So I am attempting to create an ER Digram for a certain catering service. Two of the entities are "Lunch Menu" and "Dinner Menu". Each catering reservation (entity) must contain either one of the two, ...
2
votes
1answer
51 views
Can someone please tell me where I went wrong for an exercise submission?
I recently submitted an assignment in a group for our databases class and we lost points on one of the exercises and the correction is unclear. If someone could examine the question, the submission ...
5
votes
3answers
4k views
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 ...
1
vote
3answers
2k views
I can't save Database Diagrams
I'm trying to save a database diagram but I'm getting an error. How can I fix this?
Cannot insert the value NULL into column 'diagram_id', table
'SOFT.dbo.sysdiagrams'; column does not allow ...
5
votes
1answer
1k views
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 ...
1
vote
0answers
144 views
ERD Diagram based on Crow's Foot model for Milky Way Jewelry
this was on my final exam this past winter exam season, in search for the answer since i got it wrong:
Draw an ERD diagram based on the Crow's Foot model for a database to support the basic ...
4
votes
1answer
586 views
Modeling Subclass (or Subtype) Constraints in an Entity-Relationship Diagram
Scenario description
Can someone help me out on how to model the situation that follows:
There is a superclass (or supertype) called PRODUCTS, which has the subclasses (or subtypes) named FOOD and ...
2
votes
2answers
6k views
What does the Union sign in EER diagrams mean?
I know disjoint and overlapping, but what does the union like sign mean in an enhanced entity-relationship (EER) diagram...? For example:
In other words, what does this diagram mean?
