Question

Suppose R1(A, B) and R2(C, D) are two relation schemas. Let r1 and r2 be the corresponding relation instances. B is a foreign key that refers to C in R2. If data in r1 and r2 satisfy referential integrity constraints, which of the following is ALWAYS TRUE

  • πB(r1) - πC(r2) = Ø
  • πC(r2) - πB(r1) = Ø
  • πB(r1) = πC(r2)

Answer is "pB(r1) - pC(r2) = Ø"

2 Answer and explanations

You don't need to login to post your comment
96
Muskaan

please post an explanation

106
Deeksha

anyone have any solutions

Post your answer

You don't need to login to post answer






Ask Question


Note: Options are optional, you can leave them blank