Question discussion

R(A,B) has 100 tuples and S(B,C) has 200 tuples, where B is a foreign key in S referencing the candidate key B in R (every tuple in S has a…

519Medium DSSSB TGT Computer Science 0 replies 1 views
0
R(A,B) has 100 tuples and S(B,C) has 200 tuples, where B is a foreign key in S referencing the candidate key B in R (every tuple in S has a matching, non-null value in R). How many tuples will the natural join R ⋈ S contain?
  • A100
  • B150
  • C200
  • D20,000
Correct answer: C

Discussion 0

Nobody has replied yet. Start the discussion!