Data File Handling
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.
NO | MNAME | STREAM |
M001 | JAYA | SCIENCE |
M002 | ADIYTA | HUMANITIES |
M003 | HANSRAJ | SCIENCE |
M004 | SHIVAK | COMMERCE |
NO | MNAME | STREAM |
M002 | ADIYTA | HUMANITIES |
SELECTION
Degree of table RESULT=3
Cardinality of table RESULT = 2
Sponsor Area
Sponsor Area
Sponsor Area