Home » Database » Database miscellaneous » Question

Database miscellaneous

  1. Which of the following relational calculus expressions is not safe?
    1. { t | ∃u ∈ R1(u[A]) ∧ ̚ ∃s ∈ R2 (t[A] = s[A]) }
    2. { t | ∀u ∈ R1(u[A]) = "x" ⇒ ∃s ∈ R2 (t[A] s[A] ∧ s[A] = u[A])) }
    3. { t | ̚(t ∈ R1) }
    4. { t | ∃u ∈ R1(t[A]) = u[A] = u[A] ∧ ∃s ∈ R2 (t[A] = s[A])) }
Correct Option: C

{t | ̚ (t ∈ R)}
This option contradicts itself. We want a tuple t and t itself is in r1 and we want other tuples than t by using negation so it’s not safe.



Your comments will be displayed only after manual approval.