New answers tagged relational-theory
Doing a natural self-join is like joining on all the columns, so like joining on the primary key (as the set of all columns is certainly a superset of the primary key.) Every row of the left copy of the table will be joined to exactly one row (its copy) of the right copy of the table. Therefore, the size of the resulting set R NATURAL JOIN R will be exactly ...
Top 50 recent answers are included