Consider the following genealogical tree:father (a,b).father (a,c).father (b, d).father (b,e).father (c, f).whose graphical representation is:bde fWrite a prolog program for this genealogy. Say which answers, and inwhich order, are generated by your definitions for the queries:?- brother (X,Y).?- cousin (X,Y).?- grandson (X,Y).?- descendant (X,Y).

i. grandson(X,Y) = father(Z, X), father(Y,Z) grandson(X,Y) % 8 ii. brother(X, Y) =…

Answered: which order, are generated by your…

which order, are generated by your definitions for the queries: ?- brother (X,Y). ?- cousin (X,Y). ?- grandson (X,Y). ?- descendant (X,Y).

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: THIS MODULE IS ABOUT SUBQUERIES, SO YOU MUST USE SUBQUERIES INSTEAD OF TABLE JOINS IN THIS…

A: In SQL we use the sub queries along with the IN clause to get the set of records for which we need…

Q: What are rhe types of subquery?

A: INTRODUCTION: A subquery is a query that is contained within a larger query statement. Subqueries…

Q: Write correlated and noncorrelated subqueries and understand when to use each.

A: This question argues about correlated and noncorrelated subqueries and understand when to use each.

Q: Based on the stage 2, write queries for the following questions: Sample output are provided for some…

A: As per our guidelines we are supposed to answer only one question. Kindly repost other questions as…

Q: What will be the output of the given queries on the given table shown below: Student(SID,…

A: Find the output of the given SQL query after the execution on the given table Student(SID, NAME,…

Q: Write a SQL query that selects OrderID and OrderDate from the Orders table and OrderDetailID from…

A: Introduction: A JOIN clause is used to merge data from more than "2" tables based on a standard…

Q: Describe a situation in which you would need to write a query using the HAVING clause.

A: Consider a situation in which the database administrator needs to group the table column or…

Q: What are some of the uses you might have for correlated subqueries?

A: Intro Correlated subqueries_ are used for row-by-row processing_. Each subquery is executed once…

Q: True or False? An action query is accomplished by putting AS and an alternative name after the table…

A: We are given a statement in sql query and we are going to see if the statement is correct or not.

Q: a distinct difference between subqueries correlated and uncorrelated

A: Solution :- In the above question, the statement is mention in the above given question Need to…

Q: What’s the difference between correlated and uncorrelated subqueries?

A: Difference between correlated and uncorrelated sub queries A non correlated sub query is executed…

Q: Write the query that will show only the duplicate customer records.

A: Answer: SELECT statement:It is used to retrieve information from the table or database.The syntax…

Q: a. Write a query to find the salesperson and customers who belongs to same city. b. Write a query to…

A: As per our company guidelines, we are not supposed to answer more than three parts per post and…

Q: Use sub queries to answer the following Q1) write a query to display the employees first name and…

A: Note:- since table name is not we had given queries according to question given Syntax: select…

Q: The SQL like operator is case sensitive (in most systems), but the lower() function on strings can…

A: 1)SELECT * FROM tablename WHERE CustomerName LIKE 'sci%' Result --> science 2) SELECT * FROM…

Q: What exactly is a query?

A: Query: A query is a request for data or information from a database table or combination of tables.…

Q: Answer part (4) of question 3.37 but use joins using JOIN ON syntax

A: Lets see the solution.

Q: 3- Write a query to display the customer code, balance, and total purchases for each customer. Total…

A: Actually, SQL is a language to operate databases in searching and filtering the data according to…

Q: How many inner joins are possible in the attached scenario? write a query for inner join, left join,…

A: There are 3 inner joins possible. They are: between country and province; here CtrID is the primary…

Q: In SQL, the data in a relation can be retrieved/displayed in ascending/descending order using…

A: According to the question we generally use sql commands for retrieve the data from database and for…

Q: How does a parameter query differ from a select query?

A: A parameterized query is a sort of SQL query that expects somewhere around one boundary for…

Q: Create a SQL query that selects OrderID and OrderDate from the Orders database and OrderDetailID…

A: Definition A JOIN clause is used to join data from more than "2" tables together based on a common…

Q: What comparison operators are necessary for multiple-row subqueries

A: This question explains about comparison operators are necessary for multiple-row subqueries.

Q: Write a query to display all vendors sorted by vendor name. Write a query to display the product id,…

A: As per our company guidelines we are not supposed to answer more than 3 subparts of question and…

Q: Given the following query:SELECT title, giftFROM books CROSS JOIN promotion;Which of the following…

A: Answer of the above question:

Q: how to write a query using a subquery to list InvoiceNumber, InvoiceDate for those products with a…

A: A Subquery or Inner query or a Nested query is a query within another SQL query and embedded within…

Q: Q1) Write a query that count the employees in each department? Q2) Write a query that retrieve all…

Q: Use multiple-row subquery in a WHERE clause. List order numbers of books, written by an author whose…

A: Multiрle-rоw subqueries аre nested queries thаt саn return mоre thаn оne rоw оf results…

Q: Insert the following records into the tables LIBRARY and MEMBER Table: LIBRARY Вook_Type ok_ID |…

A: INSERT statement inserts records to a table by mentioning the column names and respective values of…

Q: A foreign key is the candidate key that is selected to identify tuples. True or False.

A: Solution: A foreign key is the candidate key that is selected to identify tuples. True or False.

Q: How do you specify conditions for an Access query?

A: How do you specify conditions for an Access query?

Q: Write noncorrelated and correlated subqueries and know when to write each.

A: SQL (Structured Query Language) is designed primarily for managing data in a relational database…

Q: Create a query based on tblEmployee and tblPurchase using the Find Unmatched Query Wizard that lists…

A: Answer: First, Create a table with data. Click Query wizard Choose to Find unmatched query wizard…

Q: The order of operands is significant in EXCEPT (MINUS) queries but is irrelevant in UNION queries?

A: Yes, thia statement is true that The order of operands is significant in EXCEPT (MINUS) queries but…

Q: O b. Natural joins return only matched columns in the result set.

A: We need to solve:

Q: To add new customer to the customer table, the right query is:

A: The INSERT INTO statement is used to insert new records in a table. Syntax- INSERT INTO table_name…

Q: Q2/ what is the difference between the use of (all) and (some) in nested subqueries.

A: SQL stands for Structured Query Language.

Q: The query that will return the employee's ID and his full name is

A: The correct option is A

Q: Write a SQL query that selects OrderID and OrderDate from the Orders table and OrderDetaillD from…

A: Introduction: Structured Query Language (SQL) is an acronym for Structured Query Language. SQL is a…

Q: Q2/ what is the difference between the use of (in) and (not in) in nested subqueries.

A: Below is the complete information about difference between the use of (in) and (not in) in nested…

Q: 4. Write two queries to list the ID of all the authors that do not have any books. a) Using a join:…

A: The requirement is to fetch the author_id from author table for the records where there is no…

Q: Write an SQL query using the UPDDATE and SET operator that willoverwrite all values containing 16…

A: Update statement: The UPDATE statement in the SQL is used to modify existing records present in the…

Q: If a subquery is used in the FROM clause of a query, how are the subquery’s results referenced in…

A: Results of a sub query used in FROM clause The FROM clause is used to list tables and any joins…

Q: What will be the output of the given queries on the given table shown below: Student(SID,…

A: Given Table: Student(SID, NAME,CLASS, SECTION) Requirement: Find the output when the following query…

Q: Justify your use of EXISTS and associated subqueries.

A: EXISTS conditions in SQL check if the result is empty (contains no data) or not after running…

Q: b. Write a query to get the average salary and the total number of employees who work in the History…

A: Functions used: The COUNT() function returns the number of rows. The AND operator displays a record…

Q: ) Create a query that returns a list of all patients and their family member (add a column primary…

A: Below is query if relationship is not considered as independent table . SELECT PatientID ,…

Concept explainers

Multiple Table

In a database, a table is used to store data in the form of rows and columns. Rows are aligned horizontally and identified by one or more values in a specific column. Columns are vertically aligned and identified by a unique column name.

Question

Consider the following genealogical tree:
father (a,b).
father (a,c).
father (b, d).
father (b,e).
father (c, f).
whose graphical representation is:
b
d
e f
Write a prolog program for this genealogy. Say which answers, and in
which order, are generated by your definitions for the queries:
?- brother (X,Y).
?- cousin (X,Y).
?- grandson (X,Y).
?- descendant (X,Y).

Expert Solution

This question has been solved!

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

SEE SOLUTION Check out a sample Q&A here

Step 1 of 3

VIEW

Step 2 of 3

VIEW

Step 3 of 3

VIEW

Step by step

Solved in 3 steps with 1 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

Prolog Depth-first based on the graph search template is not memory efficient because it keeps all active branches while searching for a goal. A more efficient search for graphs looks at one path only and exploits the Prolog built-in backtracking mechanism. Create a file searches.pl and incrementally add to it the following. arc(a, b). arc(a, f). arc(b, c). arc(b, d). arc(b, e). arc(f, g). arc(f, i). arc(i, j). arc(i, k). arc(j, e). arc(j, m). goal(d). goal(i). goal(m). (a) Implement dfs/2 (depth-first search) – this strategy takes a single path 1 as input and then expands that path with a new node until the goal is found, in which case the solution is returned in the second argument. Query your program with: ?- dfs([a], X). for each file in Tests and check you find the right solution.
Let a set be represented by a list of numbers. Write the following Prolog relations: - union(A,B,C) is true if the list C contains only even numbers in either lists A or B - intersection(A,B,C) is true if the list C contains only even numbers in both lists A and B.
Write a Prolog predicate that sees if the list has duplicate numbers. (Course: Programming languages). note: PLEASE DON'T SOLVE IT WITH CODING LIKE(PYTHON, JAVA..ETC) JUST PROLOG PREDICATE. and please help...asap
Consider the program below. If this program had been run with a Datalog and a Prolog engine, would the results be the same? If no, explain why. connection(X, Z) :- connection(X, Y), connection(Y, Z) . connection(X, Z) :- connected(X, Z) . connected(ibkhbf, marktplatz) . connected(marktplatz, hoettingerau) . connected(hoettingerau, technik) . ? -: connection(ibkhbf, technik)
Suppose a Prolog database exists that gives information about the parts in an automobile engine. Predicates of big, small, and partof are included.a. Write a query to find all small items that are part of other items.b. Write a query to find all big items that have small subitems.c. Formulate a recursive rule to define componentof.
Implement a more extensive finite-state grammar for noun groups by using the examples given in Section 13.5 and test it on some NPs. Use an on-line dictionary with parts-of-speech if available; if not, build a more restricted system by hand.
L={anbman | n,m=1,2,3....} is given. Draw the derivation tree for the string aaaabbbaaaa.
Answer with proper explanation and step by step solution. Question: Write a denotational semantics mapping function for java for loop Please explain and everystep!!!
The following must be written in Python programming language: (Please do not copy from other Chegg questions. I want to see if there are other ways to get the output.) For this problem, we need to write a simple arithmetic grammar using parsimonious grammar in Python. Please provide comments as I'm still a beginner in Python. Below is a list of input examples: 6+7 This should create a parse tree with an output of 13. 2+3*4-0 This should create a parse tree with an output of 14.
olog -Short answers 1. What would be the output from ?- append(la,b,c], [one,two,three),Result). 2. Given the following Prolog code: mystery(1, 1). mystery (N, F) :- N1 is N-1, mystery (N1, F1), F is Fl*N. what will be the solution of query: ?- mystery (3, P).
Consider the Prolog gcd program in Figure 1.2. Does this program work “backward” as well as forward? (Given integers d and n, can you use it to generate a sequence of integers m such that gcd(n,m)= d?) Explain your answer.
Develop a system/application in Prolog that will allow grader to: load a set of student’s grades (see samples from the Table C below) query student’s final letter grade (A, B, C, etc.) by a given student’s name. query student(s) whose grade matches to the input letter grade (e.g., A). For example, show student(s) whose final letter grade is A. There are 3 types of grades for each student—HWs, Exams, and Project, with a weight of 20%, 40% and 40%, respectively, to the 100-point final. Table A and B show how the final grades (in points and letter) are computed. Table C shows samples of students’ grades. You will define the execution instructions to answer the following questions so that grader can test out your application in Prolog: how to load your source code to Prolog runtime/compiler how to load students’ grades to Prolog runtime/compiler how to query student’s letter grade how to query student(s) whose letter grade matches to an input letter grade Please DO NOT hard code any…