1 TOSCOW NH 2 3 4 5 6 7 8 9 LO 11 12 L3 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 30 31 32 83 34 85 36 37 38 39 Below we have some logical facts and some potential queries that could be run with those facts. Your goal is to fill in what these queries do. Ignore any warnings for this file. As a hint, you can run this file directly by: 8 swipl -s 5_exercises.pl ...and then issuing the queries at the prompt. Consider the following Prolog logicbase: 8 a (al, 1). a (A, 2). a (a3, N). b (1,bl). b (2,B). b (N, b3). C (X,Y) :- a (X,N), b (N, Y). d (X,Y) :- a (X,N), b (Y, N). d (X,Y) :- a (N, X), b (N, Y). Write out whether or not the following queries are true or false, replacing ??? where appropriate. If a query is true and involves variable instantiations, then write out all possible variable instantiations which make the query 8 true. Some have already been done for you, to give an example of the expected format. If you wish, you may simply copy and paste the output of SWI-PL here directly; we will be grading this by hand, so the output format isn't important.

1 TOSCOW NH 2 3 4 5 6 7 8 9 LO 11 12 L3 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 30 31 32 83 34 85 36 37 38 39 Below we have some logical facts and some potential queries that could be run with those facts. Your goal is to fill in what these queries do. Ignore any warnings for this file. As a hint, you can run this file directly by: 8 swipl -s 5_exercises.pl ...and then issuing the queries at the prompt. Consider the following Prolog logicbase: 8 a (al, 1). a (A, 2). a (a3, N). b (1,bl). b (2,B). b (N, b3). C (X,Y) :- a (X,N), b (N, Y). d (X,Y) :- a (X,N), b (Y, N). d (X,Y) :- a (N, X), b (N, Y). Write out whether or not the following queries are true or false, replacing ??? where appropriate. If a query is true and involves variable instantiations, then write out all possible variable instantiations which make the query 8 true. Some have already been done for you, to give an example of the expected format. If you wish, you may simply copy and paste the output of SWI-PL here directly; we will be grading this by hand, so the output format isn't important.

Programming with Microsoft Visual Basic 2017

8th Edition

ISBN:9781337102124

Author:Diane Zak

Publisher:Diane Zak

Chapter12: Database Queries With Sql

Section: Chapter Questions

Problem 2MQ2

See similar textbooks

Similar questions

Implement a query containing a subquery to display the total number of rentals for the customer (unknown before query) who belongs to the city London. Exact display as the following use sakila as Database Thank you 100% C 103:1 Result Grid I & Filter Rows: Q Search customer_id first_name last_name Rental_Count 252 МАTTIE HOFFMAN 22 512 СЕCIL VINES 26
What is the result of the query below: SELECT V_CODE, COUNT (P_CODE) FROM PRODUCT HAVING V_CODE != 21344; A) A list of V_CODE, and the number of products for each V_CODE that is equal to 21344. B) An error message. C) A list of V_CODE, and the number of products for each V_CODE that is not equal to 21344. D) The number of counts for each P_CODE that has a V_CODE that is not equal to 21344.
Correct and detailed answer is must for Upvote. Thank you!
SQL: Create a SQL query that uses an uncorrelated subquery and no joins to display the descriptions for products provided by a vendor in area code 615. Remember, the main difference between a correlated subquery and uncorrelated subquery is that, in a correlated subquery, the inner query is dependent upon the outer query, while, with an uncorrelated query, the inner query does not depend upon the outer query. Instead, it runs just once. You should NOT use union, minus, or intersect in this query. The outer query will use the PRODUCT table and the inner query will use the VENDOR table [hint: you should have 9 records of output]. My code: select p_descript from product where (select v_areacode from vendor where v_areacode = '615' ; I am getting this error, problem is I can't see what is missing any assistance is appreciated. ORA-00936: missing expression
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.
Orderltem OrderlD item quantity 1 Fahita 1 Menu 1 Pepsi Item type price 1 Shawarma Соса Drink 1.5 1 Water Fahita Sandwich 2 Coca 3 Pepsi Drink 1.5 2 Steak 3 Shawarma Sandwich 3 Fahita Steak Plate 10 Steak 2 Water Drink 1 water 1 The query that gives the price of the Steak' Select one: All the answers are correct Select price from orderitem where item='Steak Select price from menu where item='Steak Select price from menu where item=steak Consider the table called STATION (ID, CITY, STATE, LAT_N, LONG W); few rows are inserted to the table STATION: ID CITY STATE LAT_N LONG W 13 Phoenix AZ 33 112 44 Denver CO 40 105 66 Caribou МЕ 47 68 ID CITY STATE LAT_N LONG_W Which query gives the the following table : 44 Denver CO 40 105 66 Caribou ME 47 68 Select one: O a SELECT * FROM STATION WHERE LAT_N > 39.7; O b. SELECT city,ID WHERE LAT_N > 39.7; SELECT * FROM STATION WHERE LAT_N > 40; O d. None of these
grade varchar(30), salesman_id int, CONSTRAINT FK_salesman_id FOREIGN KEY (salesman_id) REFERENCES salesman(salesman_id) ); insert into customer (customer_id, cust_name, city, grade, salesman_id) values (3002, 'Nick Rimando', 'New York', 100, 5001); insert into customer (customer_id, cust_name, city, grade, salesman_id) values (3007, 'Brad Davis', 'New York', 200, 5001); insert into customer (customer_id, cust_name, city, grade, salesman_id) values (3005, 'Graham Zusi', "California', 200, 5002); insert into customer (customer_id, cust_name, city, grade, salesman_id) values (3008, Julian Green', "London', 300, 5002); insert into customer (customer_id, cust_name, city, grade, salesman_id) values (3004, 'Fabian Johnson', 'Paris', 300, 5006); insert into customer (customer_id, cust_name, city, grade, salesman_id) values (3009, 'Geoff Cameron', "Berlin', 100, 5003); insert into customer (customer_id, cust_name, city, grade, salesman_id) values (3003, 'Jozy Altidor, 'Moscow', 200, 5007);…
SQL ( ORACLE SQL DEVELOPER ) : THIS IS FIRST , SECOND AND THIRD TABLE for the Task 1 to solve : create table author_45( auth_name char(50), gender char(1), age number(3), nationality char(50), PRIMARY KEY (auth_name) ); create table book_45( isbn number(10), title char(50), ver_no number(2), publisher char(50), PRIMARY KEY (isbn) ); create table writtenBy_45( isbn number(10), auth_name char(50), yr_published number(4), price number(3), no_copy number(4), PRIMARY KEY (isbn,auth_name), foreign key (isbn) references book_45, foreign key (auth_name) references author_45 ); insert into author_45 values ('Benoit','F',42,'French'); insert into author_ 45 values ('Antonini','M',33,'Italian'); insert into author_ 45 values ('McAven','F',31,'Australian'); insert into author_ 45 values ('Williams','M',90,'British'); insert into book_45 values (101,'atabases',1,'Possum'); insert into book_45 values (202,'SQL Primer',2,'Hall'); insert into book_45 values…
Create a query based on tblEmployee and tblPurchase using the Find Unmatched Query Wizard that lists the EmployeelDFirstName, and LastName of any employee who has not yet made a sale. Save the query as qryEmployeeNoSales and then close the query
Write an SQL query that uses a multiple-column subquery in a FROM clause. Explain what the query is intended to do. Write an SQL query that is based on multiple tables and uses a subquery with the GROUP BY statement and HAVING clause. Explain what the query is intended to do. Write an SQL query that is based on multiple tables and uses a multiple-row subquery in a WHERE clause. The subquery will include the GROUP BY statement and another multiple-row subquery in a HAVING clause. Explain what the query is intended to do. Write an SQL query that joins three tables and uses any type of a subquery. Explain what the query is intended to do. Write an SQL query that is based on multiple tables and uses the DECODE function. Explain what the query is intended to do.
3. Show the ID of all the authors that do not have any books. a). Using a join: b). Using a subquery:
Task 2: List the owner number and last name for all owners located in the city of Seattle. Your query should ignore case. For example, a customer with the city Seattle should be included, as should customers whose city is SEATTLE, SEAttle, SeAttle, and so on.