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 natural language.
Let's use the following diagram: (Please don't get too caught up on the correctness of the actual entities, they are just for our example.)
Natural Language Sentence Examples
Company to Address
Would this be a correct way of talking about the relationship from Company to Address.
A company has 1 to many addresses. (shipping, billing, etc).
This indicates that the company must have at least one address, right?
Does that match the notation I have in the diagram?
Company to Connection
Each company has zero to many Connections.
Is that correct? Is that how I read that double-bar on the Company side?
How Are the Two Company-side Connectors Any Different?
Do the two company-side connectors indicate anything different at all?
Can you explain that?
General Help For Natural Language Translation?
Do you have a logical method with steps you could provide for examining each relationship and converting to natural language?
For example, with Company to Connection.
Where do I start reading?
How do I remember (or explain) that the crows foot on Connection indicates the number of Connections a Company has and not vice versa?