This preview shows page 1. Sign up to view the full content.
Unformatted text preview: 1. (30 points) Express in relational algebra the following queries: 1. find the restaurants that serve a meal that patron John Doe likes; 2. find the meals served at restaurants that patron John Doe frequents; 3. find the patrons that frequent at least one restaurant that serves a meal they like; 4. find the patrons that like at least three different meals. 5. find all patrons that frequent a restaurant that serves a meal that John Doe likes 2. (40 points) Exercise 7.24 from the textbook. 3. (30 points) Exercise 7.27 from the textbook. Y. Alp Aslandogan 2001-09-24...
View Full Document
- Spring '09