Questions tagged [erd]
Entity Relationship Diagram
395 questions
0
votes
0
answers
41
views
Database schema for different types of posts - SQL SERVER
I'm designing a database for a platform where users can post different types of content.
Database Engine: SQL Server
The system includes:
Proposals
Experiences
Events
##Current Schema Design##
...
- 1
2
votes
0
answers
68
views
Is this a good entity-relationsip model for my event organization website?
I am building a database for a website that will help me at organizing local tabletop gaming conventions.
This being the first time I create a database where the same data will be part of multiple ...
- 121
0
votes
1
answer
100
views
Could a Tool Like ChartDB Work for MongoDB Schema Visualization?
I’m one of the developers behind ChartDB, an open-source tool for database schema visualization, particularly useful for relational databases (RDBMS). Our tool helps users generate ER diagrams to map ...
- 11
2
votes
1
answer
212
views
Please help me understand this problem about cardinality
Me and my friend are in the process of creating an ER diagram for a professional soccer league, we are both very new to Database so we aren't sure if everything we do is correct.
When creating a ...
- 23
1
vote
1
answer
3k
views
How do you open a *.pgerd file and view the database diagram?
I have a *.pgerd file that I want to open an view the database diagram. What free tools can I use? I also have access to IntellJ Ultimate Edition, so if anyone knows of plugins I can use, this would ...
- 463
0
votes
1
answer
66
views
Chen ERD: What improvement could I make? Can relationship `RECEIVES` be omitted since entity `INVOICE` is a weak entity of `CAR`?
Assumptions:
A salesperson may sell many cars, but each car is sold by only one salesperson.
A customer may buy many cars, but each car is bought by only one customer.
A salesperson writes a single ...
- 1
0
votes
1
answer
86
views
Recommended way to build database to contain users and chatgpt data
I am looking to create a Rails application to interface between users and Azure ChatGPT. I will include my ERD diagram showing a couple of options in building the database tables and table ...
- 101
0
votes
1
answer
53
views
How to implement historical data with this EERD?
I am looking for a way to implement historical data with the following EERD (what I have tried, below the image):
What have I tried?
Temporal tables
Didn't work because I use MySQL and it has no ...
0
votes
0
answers
50
views
Associative relationship for "manager working term"
I am creating ERD following some database design requirements.
This specific part on the ERD is what I am trying to represent.
I made the MANAGEMENT entity because it's related to DATE_ACCEPTANCE, ...
- 1
1
vote
1
answer
462
views
Should I Use a Composite Key or a Single-Column Primary Key in my Entity Relationship Diagram? [duplicate]
I am designing an Entity Relationship Diagram (ERD) for a database that includes a table with variants annotated by different tools. In this table, each variant is annotated by a specific tool, and ...
user285147
-1
votes
3
answers
200
views
2nd Normal Form ERD thoughts
This ERD has completed 2nd Normal Form normalisation, as every table has a primary key, the data is atomic, there are no repeated groups, and there is no partial key dependency.
What are your thoughts?...
1
vote
1
answer
448
views
pgAdmin 4 ... is not present in the table
Hello
Here is my erd and the below my creating table codes;
-- This script was generated by the ERD tool in pgAdmin 4.
-- Please log an issue at https://redmine.postgresql.org/projects/pgadmin4/...
- 13
0
votes
0
answers
63
views
feedback and improvements for London Autos ERD
London Autos has several locations within London and its surroundings, from its humble beginning a decade ago in an east London garage, the business has expanded into a multi-million-pound business. ...
amz
0
votes
2
answers
48
views
in ERD of a system in which teachers evaluating other teachers of their departments how can i connect Teacher, evaluation_result entiy,
A teacher could be an evaluator and also be an evaluatee. How can I achieve this?
2
votes
1
answer
251
views
Deleting a row in one table should also delete the corresponding rows in another table
I have these tables: station and water_types. The user may only have one station, and if the user wants to delete the station, the corresponding water_types must also be deleted. In a station, there ...
- 125