Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
2.4k views
in Computer by (45.3k points)
closed by

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

1 Answer

+1 vote
by (50.9k points)
selected by
 
Best answer

(i) SELECTION

Degree of table RESULT = 3

Cardinality of table RESULT = 2

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...