Suppose T1(P, Q) and T2(R, S) are two relation schemas. Let t1 and t2 be the corresponding relation instances. R is a foreign key that refers to P inT1. If data in t1 and t2 satisfy referential integrity constraints, which of the following is/are always true?
I. ∏R (t2) – ∏P(t1) = Φ
II. ∏P(t1) ≠ ∏R(t2)
III. ∏P (t1) – ∏R (t2) = Φ1
Only I
2
Only I and II
3
Only II and III
4
I, II and III