11.5. Summary of Binary Set Operators

The table below shows the various circumstances for all of the binary set operators illustrated in this chapter. We can think of this as the framework for how the set operations work.

With 2 input relations, A and B, we introduce new considerations:

We do not yet consider what columns are ‘worked on’ with these set operators, because it is always all of them. This why we call these ‘primitive’ binary operators.


The Primitive Binary Set Operator Framework

You can download The Primitive Set Ops Framework Document and keep a copy for your own reference. It is useful to refer to how each operator should work as you practice on the previous examples or on your own data.

You have attempted of activities on this page