Computer Sciences > Gate 2022 > 1
Consider the following three relations in a relational database. Employee (eId, Name ), Brand (bId, bName), Own (eId, bId ) Which of the following relational algebra expressions return the set of eIds who own all the brands?
A
πeld(πeld,bld(own)/πbrand))
B
πeld(own)-πeld((πeld(own)xπbld(brand))-πbld,eld(own))
C
πeld(πeld,bld(own)/πown))
D
πeld((πeld(own)xπbld(own))/πbld(brand))

Correct : a,b

Similar Questions

Consider the following recurrence: f(1) = 1; f(2n) = 2f(n) -1, for n≥1; f(2n+1) = 2f(n) +1, for n≥1; Then, which of the following statements is/are TRUE?
#321 MSQ
Consider the following languages: L1 = {ww | w ∈ {a, b}* } L2 = {anbncn | m, n≥ 0} L3 = {ambncn | m, n≥ 0} Which of the following statements is/are FALSE?
#322 MSQ
Which of the following statements is/are TRUE with respect to deadlocks?
#323 MCQ

Related Topics

relational algebra database relations GATE computer science 2022 relational operations eId own all brands brand relation employee relation GATE CS 2022 relational algebra expressions

Unique Visitor Count

Total Unique Visitors

Loading......

Question Options

Contributed by: