I used the reverse-engineer function to generate an EER diagram of the Yelp dataset as per this question here. It looks like this:
Does anyone know exactly how to interpret it? What do the arrow tips mean, eg the one with 3 tips and a line, the one with 2 parallel lines. Then there are some without any tips.
Then, does the point at which the arrow enter or leave a table mean anything, eg one leaves the tip table around text and enters the checkin table around count, or is that irrelevant?
Another detail I noticed in there is that the yellow lightbulb is probably a primary key and the red diamond, a foreign key. Still can't see from the diagram however how the coloured symbols and arrows connect.
Cardinality and ordinalitiy:
Source: https://www.lucidchart.com/pages/ER-diagram-symbols-and-meaning
In addition to InfZero's answer:
The point at which the connections touch a table figure is random. It's usually the point that produces the shortest connection and is centered on a figure's side. If more than one connection go out on the same side they are evenly spread accross this side There's a special mode where you can have connections touch where columns are:
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With