GATE | GATE CS Mock 2018 | Question 36
Consider the following collection of relation schemes:
professor(profname, deptname)
department(deptname, building)
committee(profname,commname)
Find all the professors who are in exactly (i.e., no more and no less) all those committees that Professor Smith is in.
(A)
R2 <- Πcommname(σprofname = Smith(committee))
R3 <- Î commname(committee) – R2
(committee / R2) – Î profname(committee ⋈ R3)
(B)
R2 <- Î commname(Î commname(committee))
R3 <- σprofname = Smith(committee) – R2
(committee / R2) – Î profname(committee ⋈ R3)
(C)
R2 <- Î commname(Î profname(committee))
R3 <- Î commname(committee) – R2
(committee / R2) – σprofname = Smith(committee ⋈ R3)
(D)
None of the above
Answer: (A)
Explanation:
Option (C) is correct.
R2 <- Πcommname(σprofname = Smith(committee))
R3 <- Î commname(committee) – R2
(committee / R2) – Î profname(committee ⋈ R3)
Quiz of this Question
Please comment below if you find anything wrong in the above post
Last Updated :
03 Jan, 2018
Like Article
Save Article
Share your thoughts in the comments
Please Login to comment...