Open In App
Related Articles

GATE | GATE CS Mock 2018 | Question 59

Improve Article
Save Article
Like Article

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

(A) 1

(B) Capture2
(C) Capture3
(D) None of the above

Answer: (B)

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.

Last Updated : 10 Jan, 2018
Like Article
Save Article
Similar Reads