Questions tagged [erd]
Entity Relationship Diagram
395 questions
0 votes
0 answers
40 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