Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

GATE | Sudo GATE 2020 Mock II (10 January 2019) | Question 36

  • Last Updated : 09 Jan, 2020

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 <- Πcommnameprofname(committee))
R3 <- Πcommname(committee) - R2
(committee / R2) - σprofname = Smith(committee ⋈ R3)

(B)

R2 <- Πcommnamecommname(committee))
R3 <- σprofname = Smith(committee) - R2
(committee / R2) - Πprofname(committee ⋈ R3)

(C)

R2 <- Πcommnameprofname = Smith(committee))
R3 <- Πcommname(committee) - R2
(committee / R2) - Πprofname(committee ⋈ R3)

(D) None of the above.


Answer: (C)

Explanation: Option (C) is correct.

R2 <- Πcommnameprofname = Smith(committee))
R3 <- Πcommname(committee) - R2
(committee / R2) - Πprofname(committee ⋈ R3) 


Quiz of this Question

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!