ExamCompetition Your Success, Our Mission
Login Register
Question discussion

Relation R(A, B) has 100 tuples and relation S(B, C) has 50 tuples. B is the primary key of S, and B in R is a foreign key (not null) refer…

2150Medium DSSSB TGT Computer Science 0 replies 1 views
0

Relation R(A, B) has 100 tuples and relation S(B, C) has 50 tuples. B is the primary key of S, and B in R is a foreign key (not null) referencing S. How many tuples does the natural join R ⋈ S contain?

  • A100
  • B50
  • C150
  • D5,000
Correct answer: A

Explanation

Each tuple of R matches exactly one tuple of S (the key B), so the join has exactly 100 tuples.
Join the discussion Report an error

Discussion 0

Nobody has replied yet. Start the discussion!