Suppose that a Prolog database contains the following entries: eat(bear, fish) eat(fish, littlefish) eat(littlefish, algae) eat(raccoon, fish) eat(bear, raccoon) eat(bear, fox) eat(fox, rabbit) eat(rabbit, grass) eat(bear, deer) eat(deer, grass) eat(wildcat, deer) animal(bear) animal(fish) animal(littlefish) animal(raccoon) animal(fox) animal(rabbit) animal(deer) animal(wildcat) plant(grass) plant(algae) prey(X) <= eat(Y, X) and animal(X) Then the following dialog with Prolog could take place: ?animal(rabbit) yes ?eat(wildcat, grass) no ?eat(X, fish) bear гасcoon гасcoon ?eat(X, Y) and plant(Y) littlefish fox algae rabbit rabbit grass deer deer grass deer ?prey(X) Note that fish is listed twice as satisfying the last query because fish are eaten by bear (fact 1) and by raccoon (fact 3). Similarly, deer are eaten by both bear and wildcat. fish littlefish fish

Suppose that a Prolog database contains the following entries: eat(bear, fish) eat(fish, littlefish) eat(littlefish, algae) eat(raccoon, fish) eat(bear, raccoon) eat(bear, fox) eat(fox, rabbit) eat(rabbit, grass) eat(bear, deer) eat(deer, grass) eat(wildcat, deer) animal(bear) animal(fish) animal(littlefish) animal(raccoon) animal(fox) animal(rabbit) animal(deer) animal(wildcat) plant(grass) plant(algae) prey(X) <= eat(Y, X) and animal(X) Then the following dialog with Prolog could take place: ?animal(rabbit) yes ?eat(wildcat, grass) no ?eat(X, fish) bear гасcoon гасcoon ?eat(X, Y) and plant(Y) littlefish fox algae rabbit rabbit grass deer deer grass deer ?prey(X) Note that fish is listed twice as satisfying the last query because fish are eaten by bear (fact 1) and by raccoon (fact 3). Similarly, deer are eaten by both bear and wildcat. fish littlefish fish

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Please no written by hand and no emage D As Question 3 A correlated nested query O uses tables from both the inner and the outer queries is executed once for every tuple in the outer query table O both 1 and 2 O neither 1 and 2
Question p Full explain this question and text typing work only We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this line. .
SQL query using Rank() Retrieve the top-selling product of each day.Use the total sold quantity to determine the top-selling product.The top-selling product has the highest total sold quantity.If there is a tie, the solution must pick up the tie.Include the order date, product id, and the total sold quantity of the top-selling product of each day in the returned data.Sort the returned data by the order date.*/
List the names of all Staff members who hold a faculty position and have a salary of $45,000 or less. Show their names as their first name, followed by a space, and then their last name but sort the list alphabetically by last name and then first name. Hint: Check out the Position column in the Staff table. All staff members who do not hold a faculty position will get a bonus this year equal to 5% of their salary. List the names, current salary, and bonus amount for each Staff member (non-faculty) who is due a bonus. Show your list in order with the person receiving the highest bonus first.
I need help building a query that will return the following: - Average number of borrows by age Thanks!
What will be the result of the query based on the following criteria? <columnname> = ALL (<subquery>) Returns true if the value is equal to any value returned by the subquery. Returns true if the value is equal to every value returned by the subquery. Returns true if the value is not equal to any values returned by the subquery. Returns true if the value is not equal to any value returned by the subquery.
Please Type! what is an Isolation property of transactions in SQL (database)
DO NOT COPY FROM OTHER WEBSITES Correct and detailed answer will be Upvoted else downvoted. Also explain why other options are FALSE. Thank you!
in SQL Code: Explain the difference between number and binary integer and how it is used? Please provide a code example
The following database will be used in this question: SALESREP SalesRepNo 654 734 345 434 RepName Jones Smith Chen Johnson HireDate 01/02/2005 02/03/2007 01/25/2004 11/23/2004 CUSTOMER CustNo 9870 8590 7840 4870 CustName Winston Gonzales Harris Miles Balance 500 350 SalesRepNo 345 434 654 345 800 100
Create the ROOMS table using the specification below: Table Name: ROOMS Field Name/ Data Type Size Constraints column name RID Number 8 PRIMARY KEY RType Varchar2 25 NOT NULL Rate Number Bedroom Number 5 Room Status Varchar2 10 REFERENCES to CID in Clients Table CID Number
If v is a scalar and R is a relation, which statement holds? Select one: a. All of the above are true O b. v < ALL R means V is the minimum value in R С. v != ALL R means V not in R O d. V = ALL R means V in R Students Roster name lastname age ID ID major absence rim ismail 19 123 123 EE 4. sara kamel 18 134 134 EE 7 milad ghantous 21 1345 1345 CCE 2 tarek dib 18 12345 12345 ME 4 Complete the query that finds all student names and last names for those who are 18 years old and they're registered in EE major. Select one: SELECT name,lastname FROM students WHERE age=18 AND ID IN (SELECT ID FROM roster WHERE major='EE') SELECT ID FROM students WHERE ID IN (SELECT ID FROM roster WHERE major ='EE') SELECT name, lastname FROM students WHERE age=D18 and ID= SELECT ID from roster WHERE major='EE')