Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

RELATIONAL QUERY WRITING in ALGEBRA (AND DATALOG) Consider a database with the following schema. LIKES(drinker,beer); /* key: all columns */ FREQUENTS(drinker,pub); /* key: all columns

RELATIONAL QUERY WRITING in ALGEBRA (AND DATALOG)

Consider a database with the following schema.

LIKES(drinker,beer); /* key: all columns */

FREQUENTS(drinker,pub); /* key: all columns */

SERVES(_pub,beer_,cost); /* key: (pub,beer) */

Consider the following queries:

1. Find drinkers who like at least one expensive (over $8) beer that Joe likes.

2. Find pubs that serve every beer that Joe likes.

3. Find all drinkers who frequent a pub that serves at least 2 beers they like, and one of them for at most $3.

(i) Write RELATIONAL ALGEBRA queries for all of the above

(ii) Also, write DATALOG QUERIES for number 1 and 2.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Databases And Information Systems 23rd European Conference Adbis 2019 Bled Slovenia September 8 11 2019 Proceedings Lncs 11695

Authors: Tatjana Welzer ,Johann Eder ,Vili Podgorelec ,Aida Kamisalic Latific

1st Edition

3030287297, 978-3030287290

More Books

Students also viewed these Databases questions

Question

2. Identify conflict triggers in yourself and others

Answered: 1 week ago