Observe the following table MEMBER carefully and write the name of the RDBMS operation out of
(i) SELECTION
(ii) PROJECTION
(iii) UNION
(iv) CARTESIAN PRODUCT,
which has been used to produce the output as shown in RESULT. Also, find the Degree and Cardinality of the RESULT:
MEMBER
NO |
MNAME |
STREAM |
M001 |
JAYA |
SCIENCE |
M002 |
ADITA |
HUMANITIES |
M003 |
HANSRAJ |
SCIENCE |
M004 |
SHIVAK |
COMMERCE |
RESULT
NO |
MNAME |
STREAM |
M002 |
ADITYA |
HUMANITIES |