Natural Join Operation, Assignment Operation in Python

Natural Join Operation ( |X| ):

This operation combines one tuple from relation-1 with another tuple from relation-2, only when the common attribute values of both the relations are the same.

Consider the following relation :

Example-1 :  Combine the above two relations with the Natural Join operator.

                    STUD  |X|   DEPT

Output :   Here the first tuple in STUD is combined with the first tuple in DEPT.

                     There will be a total of 5 tuples and 4 attributes.

Assignment Operation  ( ß ):      

 This operation finds the result on RHS and keeps it in LHS.

Example-2 :  Execute the following SQL expression for the following table

XXX ß    sDNo = 25  (Faculty-1)

Output :                                        XXX