Open In App

GATE | GATE CS Mock 2018 | Question 59

Like Article
Like
Save
Share
Report

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 :

Capture3

Option (B) is correct.

Quiz of this Question


Last Updated : 10 Jan, 2018
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads