Question
Download Solution PDFGiven two table R1 (x, y) and R2(y, z) with 50 and 30 number of tuples respectively. Find maximum number of tuples in the output of natural join between tables R1 and R2 i.e. R1 * R2? (* - Natural Join)
Answer (Detailed Solution Below)
Detailed Solution
Download Solution PDFConcept:
A natural join is based on common attributes or common columns to join two tables or relations.
Explanation:
Consider an example, suppose there are two tables Employee(Eid, Ename) consists of 5 tuples and department(Eid, Did) consists of 3 tuples only.
|
Eid |
Ename |
|
1 |
E1 |
|
1 |
E2 |
|
1 |
E3 |
|
1 |
E4 |
|
1 |
E5 |
|
Eid |
Did |
|
1 |
D1 |
|
1 |
D2 |
|
1 |
D3 |
Natural join of employee and department(Employee * Department) gives:
So, maximum number of tuples in natural join are from the relation having minimum tuples. So, in given question, R2 contains 30 tuples, so , maximum number of tuples in the output of natural join between tables R1 and R2 i.e. R1 * R2 = 50 × 30 = 1500.
Last updated on Jul 6, 2025
-> The UGC NET Answer Key 2025 June was released on the official website ugcnet.nta.ac.in on 06th July 2025.
-> The UGC NET June 2025 exam will be conducted from 25th to 29th June 2025.
-> The UGC-NET exam takes place for 85 subjects, to determine the eligibility for 'Junior Research Fellowship’ and ‘Assistant Professor’ posts, as well as for PhD. admissions.
-> The exam is conducted bi-annually - in June and December cycles.
-> The exam comprises two papers - Paper I and Paper II. Paper I consists of 50 questions and Paper II consists of 100 questions.
-> The candidates who are preparing for the exam can check the UGC NET Previous Year Papers and UGC NET Test Series to boost their preparations.