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

Related questions

Q: The query should list all employees whose Position begins with the word greenhouse and whose weekly…

A: These question answer is as follows,

Q: am including the previous query, Do i revise a query? 13. Display the total number of flights that…

A: the solution is an given below :

Q: Write SQL query to find total number of students in table : Class11(RollNo.,Name, Section, Marks)

A: Given Table: Class11(RollNo.,Name, Section, Marks) To Find: Total number of students in table.…

Q: --List all products whose unit price is less than the average price. --List the shipper id,…

A: Given: consider the tables as. product { productID, productNAME, price_per_unit, category_product }…

Q: Query: I need help with the SQL query for the following question: 1. Get top 5 list of most liked…

A: create table Reviews(product_name varchar(20),product_category varchar(20),product_price…

Q: No plagarism please! Write your own answer. Correct and detailed answer will be Upvoted else…

A: Let’s take few data samples to work on this query . Here is customer table with some data . Our…

Q: MongoDB query: show the most popular restaurant in different cities using regex "Restaurants"…

A: Here below i am writing simple mangodb query in which show cities that have popular restaurants:…

Q: Write the SQL statement that shows the count of invoices, the highest invoice total, the lowest…

A: Since schema of the table is not mentioned, I am assuming that table has invoices column. The query…

Q: Design a query of Stores with the following: Store Name, Store Size, Sum of order amounts, Percent…

A: JOIN Based on a common column between two or more tables, a JOIN clause is used to merge rows from…

Q: A query can have no more than three common interpretations. a) True b) False

A: The question is asking whether a query, in the context of computer science and specifically…

Q: Remove from students table those with algebra_grade below 70.

A: The DELETE statement is used to delete rows/records in a table. Syntax: DELETE FROM tableName…

Q: That is not the answer to the above question. Please create CKY tables for the question that was…

A: 0 1 2 3 0 S - - - 1 NP VP - - 2 - V - NP 3 - - Det Noun 4 - - a View S -> NP VP…

Q: Each month, a customer needs to pay whichever amount is smaller: the account balance or the minimum…

A: Each month, a customer needs to pay whichever amount is smaller: the account balance or the minimum…

Q: SELECT name FROM instructor WHERE name LIKE % dar_ Which of the instructor names will NOT be…

A: The names “Alimdarr” and “Alimdar” will NOT be included in the result of given query. Hence the…

Q: Display only unique last_name from students table.

A: This question comes from Database Management System which is a paper of Computer Science. Let's…

Q: Write an appropriate SQL query to determine it there are any students that are not registered tor…

A: ANSWER IN STEP 2:

Q: write a query to see the table structure. Table Name:- Customer.

A: SQL stands for Structured Query

Q: 4. Determine which books customer Jake Lucas has purchased. Perform the search using the customer…

A: This question is from the subject database design and implementation. Using Sql we can solve this…

Q: u please tell me how to make this query tru

A: here in this question you have given SQL command and ask to debug it, in the following section you…

Q: Write SQL query. Table:- Employees Columns:- ID,NAME,SALARY, DEPT_NAME Find department name where…

A: Given:-Write SQL query.Table:- EmployeesColumns:- ID,NAME,SALARY, DEPT_NAMFind department name where…

Q: create a subquery. (sql) Query employee name, phone number, job name, salary. In addition, get…

Q: consists of ten doctors, six nurses, five office secretaries, two administrative assistants and one…

A: Answer: Given description of ABC clinic and based on given data we will find the table and based on…

Q: Write a SOQL query to find all the account

A: Hello Student. Greeting from my side. Hope you are doing great. I will try my best to answer your…

Q: Display last_names of students whose values are Villegas, Villamonte and Villas.

A: select last_name from students where last_name = “Villegas” or last_name = “Villamonte” or last_name…

Q: Answer the query using SQL. For each department that controls more than 3 projects, retrieve the…

A: Introduction of DBMS: A database is a collection of data that are used to produce useful information…

Q: Create a query to show the subject and the quantity of books in each category. Sort the results in…

A: Introduction: Important information to remember: Hey! I hope you're doing well! Thank you for your…

Q: You are in the Marketing Department and are reviewing sales of coffee and espresso products. You are…

A: In the required SQL query, following clauses are used: AS clause to temporarily allocate a new name…

Q: Find the max profit of books in each category. 2- Find out how many books are in each order, sort…

A: SELECT CATEGORY, MAX(PROFIT) FROM BOOKS GROUP BY CATEGORY

Q: As Question 3 A correlated nested query O uses tables from both the inner and the outer queries is…

A: A correlated nested query is a type of SQL subquery that uses tables from both the inner and the…

Q: The clause is used to list the attributes desired in the result of a query. Select one: O a Distinct…

A: The select clause is used in RDBMS to list the attributes in result of a query.

Q: Create a report of items where total quantity sold was less than 25. Include the item name, average…

A: In this question we have to understand and write a correct query for the given SQL query…

Concept explainers

Single Table

In a database management system, a single table is designed to obtain data of heterogeneous items. A single-table design with DynamoDB resolves the issue of raising multiple requests for the relevant data of an entity.

Question

find the results of the query in each case.

?eat(raccoon, X )

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

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

Step 2

Step 3

Step 4

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Q7. What are some common clauses used with SELECT query in SQL?
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.*/
From the following query, identify the value of City: INSERT INTO Customers ( CustomerName, ContactName, Address, City, PostalCode, Country) VALUES (‘Cardinal,”Tom B. Erichsen”,”Skagen 21”, “Stavanger,” “4006Norway’);
I need help building a query that will return the following: - Average number of borrows by age Thanks!
DO NOT COPY FROM OTHER WEBSITES Correct and detailed answer will be Upvoted else downvoted. Also explain why other options are FALSE. Thank you!
Write a query to determine how many products you can find in the Production.Product table. This is an SQL Table.
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
For each customer who has a post-paid service, show how many of these customers have opted to have their bills emailed compared to those who have theirs by postal mail. Name this query Q3- PPBills.
QI/ Using the following schema, answer the following SQL queries: Product(P_code,P_name, P_price, P_quantity, vend_name) Vender(vend code, vend fname, vend_areacode, vend salary, vend_nationality) find the names of products that owned by vender "smith" and not owend by vender "dan." 1- find the name, price and quantity of product that has code 34657 and owned by spanish venders. 2- 3- Find the name of iraqi venders who has salary less than the average salary of venders. Find the prodect name that their quantity greater than 17 and oreder them by vender name. 4- 5-add new column to the product table called p_company.
Alert dont submit AI generated answer.
How to code this query using mysql.
write a soql query to find the Account in which name is sample.