Which of the following statement(s) is/are true with respect to derivation of operator using basic unary() and binary() operators.

• S1: join operator can be derived using projection (Π), selection(σ) and minus(-).
• S2: division operator can be derived using projection (Π), selection(σ) and minus(-).
• S3: intersection operator can be derived using selection(σ) and minus(-).

(A) S1 and S2
(B) S2 and S3
(C) S1 and S3
(D) None of the statement is correct.


Answer: (D)

Explanation: Join Operator require projection (Π), selection(σ) and cartesian product X,
Division operator can be derived using projection (Π), cartesian product X and minus(-),
Intersection operator can be derived using the set difference, i.e., A ∩ B = A – (A – B).
So, none statement is correct.

Quiz of this Question