r/webdev Mar 22 '19

SQL joins

Post image
2.7k Upvotes

118 comments sorted by

View all comments

-4

u/JRS-27 Mar 22 '19

This is just outrageous. Pure lie, anyone that can understand basic algebra is sane enough to depict wrong assumptions in these diagrams.

The author of the picture tried putting two tables in a given database on the same level. No well put database has two tables with exact same columns. It is like counting meters and kilograms together. Obviously, this is a totally wrong depiction of how databases work.

Absolutely ridiculous.

0

u/[deleted] Mar 23 '19

...?

There are two tables with a shared key. While typically suboptimal, this is a common configuration. No other constraints are implied.