profile-img
Eduncle Asked an Mcq
February 22, 2020 11:01 am

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)

Choose Your Answer:
  • 0 Attempts
  • 0 Likes
  • 1 Comments
  • 0 Shares
  • Eduncle Best Answer

    NATURAL JOIN requires that the two join attributes (or each pair of join attributes) have the same name in both relations. Relation R2 is having 30 tuples, which is minimum, so ...

    Show more
    Likes(0) Reply(0)
Head Office :
MPA 44, 2nd floor, Rangbari Main Road,
Mahaveer Nagar II, Kota (Raj.) – 324005

Corporate Office:
212, F-1, 2nd Floor, Evershine Tower,
Amrapali Marg,
Vaishali Nagar, Jaipur (Raj.) – 302021

Mail: info@eduncle.com
All Rights Reserved © Eduncle.com