L4.23 | GATE 2004 Maximum and Minimum Number of Tuples Natural Join | Relational Algebra operation
GATE 2004 Maximum and Minimum Number of Tuples Natural Join | Relational Algebra operation
Video Highlights:
Consider the following relation schema pertaining to a students database:
Student (rollno, name, address)
Enroll (rollno, courseno, coursename)
where the primary keys are shown underlined. The number of tuples in the Student and Enroll tables are 120 and 8 respectively. What are the maximum and minimum number of tuples that can be present in (Student * Enroll), where ‘*’ denotes natural join ?
(A) 8, 8
(B) 120, 8
(C) 960, 8
(D) 960, 120
#DBMSbyVinodYadav
#SuccessGATEway
#DBMS_Lecture_Series
#GATE_CS_Lectures
#DBMS
#placement
#GATE
#universityexams
#Database_management_system_success_gateway