Set Difference, Set Intersection, Cartesian Product Operations in Python

Lets us understand these operations with some examples: 

Consider the following table: 

R1 :    FACULTY-1

Set Difference Operation ( U ):  

‘Set difference’ operation eliminates second relation data from first relation data.

Example-1 :  Find the tuples only in Dno = 23,  but they should not be in DNo = 25.

         sDNo = 23 (Faculty-1)  –  sDNo = 25 (Faculty-1)

 Output :   

Set Intersection Operation ( Ç ):  

‘Set intersection’ operation takes only common tuples from both the relations.

Example-1:  Find the tuples which are in both Dno = 23 and DNo = 25.

        sDNo = 23 (Faculty-1)  Ç  sDNo = 25  (Faculty-1)

Output :   No Output

Cartesian Product Operation ( X ):

This operation combines every tuple from relation-1 with every tuple from relation-2.

Consider the following relations :

Example-2 :  Combine the above two relations with Cartesian product operators.

                                               STUD   X   DEPT

Output :   Here every tuple in STUD is combined with every tuple in DEPT. There will be a total of 25 tuples and 5 attributes.