All Questions

Tagged with
Filter by
Sorted by
Tagged with
4
votes
2answers
4k views

Is my ER Diagram correct? Why use relationships?

This is the first time I've made an Entity Relationship Diagram (ERD) for database that will be built on MySQL. The business domain of relevance is about equipment issues management. Prior to this, I ...
0
votes
1answer
3k views

How do we express a weak entity to be dependent on another weak entity?

Perhaps I am looking at my entities as a hierarchy rather than a set of relationships; for sake of an example I have three tables: Authors Books Content Where Authors writes Books and Books contain ...
0
votes
1answer
2k views

How can I represent a one-to-many relationship with three tables?

I just started using MySQL Workbench drawing an entity-relationship diagram that I previously designed in paper. I want to represent a conceptual one-to-many relationship by means of three tables. ...
0
votes
1answer
55 views

Relationship issue

I'm working on a ERD with mysql workbench, and i have a little question. I have a Database with this tables: company_address country state city I want to store the address of the company with all ...
2
votes
0answers
1k views

The nature of the relationship between two tables in MySQL

Good day. I'm designing a database for a research project where we're predicting whether or not young female athletes will rupture their ACL(s) based on the nature of a test jump recorded with a ...