Write the return relations for the following Set Operators:

TableA UNION TableB

TableA INTERSECT TableB

First list the relation for the TableA DIFFERENCE TableB

Then list the relation for the TableB DIFFERENCE TableA

Write the return relations to represent the result sets for the following JOIN (Equi-Join) operations;

TableA INNER JOIN TableB ON TableA.CustNum = TableB.CustNum

TableA LEFT OUTER JOIN TableB ON TableA.CustNum = TableB.CustNum

TableA RIGHT OUTER JOIN TableB ON TableA.CustNum = TableB.CustNum

TableA FULL OUTER JOIN TableB ON TableA.CustNum = TableB.CustNum

This assignment is not a SELECT Query Assignment. Your answers should the row/tuples that will placed in the result set of the operation being performed on both tables. Similar to the process we reviewed in class when examining the result sets that the Relational Algebra Operations would produce on Tables R and S in the PDF document on Relational Algebra that we studied in class. TableA stName Ai's Appliance and 148 Sport 282 Brookings Direct 356 Fegusons 408 The Everything Shop 463 Bargains Galore 524 Klines 725 Deerfields Water 842 Allseason's travel 701 Peter's Construction TableB CustNum CustName 148 Ai's Appliance and Sport 300 Brookings Direct 356 Fegusons 400 The Everything Shop 463 Bargains Galore 524 Klines