Question: 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) */ Translate

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) */

Translate the following Relational Algebra statements into Datalog Queries

1.) select pubs from likes,frequents where likes.drinker=frequents.drinker and frequents.drinker=joe 2.) select drinker from likes,frequents,serves where likes.drinker=frequents.drinker and serves.cost<3 3.) select drinker from likes,frequents where likes.drinker!=frequents.drinker 4.) pub likes,frequents,serves like.drinker =frequents.drinker and>

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

If you can also write the solution in actual Algebra form instead of Ascii it'd be appreciated! Consider a database with the following schema. LIKES (drinker,beer); /* key: all columns*/...

Q:

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) */ Write the...

Q:

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 */...

Q:

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

Q:

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

Q:

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) */ Write the...

Q:

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 */...

Q:

RELATIONAL QUERY WRITING in ALGEBRA Write relational algebra queries for all of the following Consider a database with the following schema. LIKES(drinker,beer); /* key: all columns */...

Q:

Comprehensive Each part of the comprehensive problem is based on Big Marker (www.bigmarker.com). Problem Part 2 of 5 Consider the narrative in Part 1 as you respond to the following questions on...

Q:

Database Schema STUDENT(SID, Name, Maior, Bdate) COURSE(Course#, Cname, Dept) ENROLL(SlD, Course#, Quarter, Grade) i. Write DDL statements to create relations STUDENT, COURSE and ENROLL as given in...

Q:

1. Develop an MPS schedule, that includes Available to Promise, based on the forecast and order data provided. 2. Develop a rough-cut capacity plan based on the MPS schedule and the data provided. 3....

Q:

Do you think the tone at the top of organizations like Enron and WorldCom led to their demise? In support of your answer, identify specific actions of top managers at each of these companies. In...

Q:

Which of the following statements regarding the income tax treatment of a principal residence is NOT correct? If an individual owns two residences, the decision to designate a particular property as...

Q:

Situation analysis questions in marketing

Q:

examine a variety of flexible working arrangements and assess their usefulness and impact for employers and employees

Q:

understand the basis of the contract of employment and know what should be in a contract of employment

Q:

describe the main employment rights as stated in the law