GATE | GATE CS Mock 2018 | Question 59
Consider a database with the following schema:
Person ( name, age, gender )
name is a key
Frequents ( name, pizzeria )
(name, pizzeria) is a key
Eats ( name, pizza )
(name, pizza) is a key
Serves ( pizzeria, pizza, price )
(pizzeria, pizza) is a key
Relational algebra expression for query “Names of all people who frequent only pizzeria’s serving at least one pizza they eat” is
(D) None of the above
Explanation: Find names of all people who frequent only pizzerias serving at least one pizza they eat :
Option (B) is correct.
Quiz of this Question
Level Up Your GATE Prep!
Embark on a transformative journey towards GATE success by choosing Data Science & AI
as your second paper choice with our specialized course. If you find yourself lost in the vast landscape of the GATE syllabus, our program is the compass you need.