Draw three tables that can result by executing each of the following SQL statements. (Put your answer in a document word then upload it).1. SELECT p. productName, p. unitPrice, p. expiryDate, o. Quantity, o. priceFROM Products AS pINNER JOIN Orders AS oON p. productID = 0. productID;2. SELECT p. productName, p. unitPrice, p. expiryDate, o. Quantity, o. priceFROM Products AS pLEFT OUTER JOIN Orders AS oON p. productID = 0. productID;3.SELECT p. productName, p. unitPrice, p. expiryDate, o. Quantity, o. priceFROM Products AS pRIGHT OUTER JOIN Orders AS oON p. productID = 0. productID; Consider the following two tables:Table1: ProductsproductNameDell LaptopApple mobileSamsung MobileproductIDunitPriceentryDateexpiryDateP135016-10-201630-10-2016P242017-02-201802-03-2018P333020-08-202030-08-2020Р4HP Printer8021-09-201905-10-2019P5Canon Printer15015-05-202020-06-2020Table2: OrdersorderIDQuantityPriceproductID1103300P321800P13201600Р44203000P5591100P782250P10Draw three tables that can result by executing each of the following SQL statements. (Put your answer in a document word then upload it).1. SELECT p. productName, p. unitPrice, p. expiryDate, o. Quantity, o. priceFROM Products AS p

A. Select the product information which is been ordered. Here productID which is not present in…

v three tables that can result by executing each of the following SQL statements. (Put your answer SELECT p. productName, p. unitPrice, p. expiryDate, o. Quantity, o. price FROM Products AS p INNER JOIN Orders AS o ON p. productID = 0. productID; SELECT p. productName, p. unitPrice, p. expiryDate, o. Quantity, o. price FROM Products AS p LEFT OUTER JOIN Orders AS o ON p. productID = o. productID; SELECT p. productName, p. unitPrice, p. expiryDate, o. Quantity, o. price FROM Products AS p RIGHT OUTER JOIN Orders AS o ON p. productID = 0. productID;

v three tables that can result by executing each of the following SQL statements. (Put your answer SELECT p. productName, p. unitPrice, p. expiryDate, o. Quantity, o. price FROM Products AS p INNER JOIN Orders AS o ON p. productID = 0. productID; SELECT p. productName, p. unitPrice, p. expiryDate, o. Quantity, o. price FROM Products AS p LEFT OUTER JOIN Orders AS o ON p. productID = o. productID; SELECT p. productName, p. unitPrice, p. expiryDate, o. Quantity, o. price FROM Products AS p RIGHT OUTER JOIN Orders AS o ON p. productID = 0. productID;

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

The following two SQL statements will produce the same results. SELECT P_DESCRIPT, P_QOH,P_PRICE FROM PRODUCT WHERE P_QOH >(SELECT P_QOH FROM PRODUCT WHERE P_CODE='11QER/31') AND P_PRICE>(SELECT P_PRICE FROM PRODUCT WHERE P_CODE='11QER/31'); SELECT P_DESCRIPT, P_QOH,P_PRICE FROM PRODUCT WHERE (P_QOH,P_PRICE) > (SELECT P_QOH,P_PRICE FROM PRODUCT WHERE P_CODE='11QER/31'); A) True B) False
What happens if we don’t specify the WHERE clause in an SQL DELETE FROM statement? a) statement compilation causes a “Syntax error”, and the statement is not executed. b) all the tuples of the relaton are deleted. c) none of the tuples of the relation is deleted. d) all the tuples not satisfying the condition are deleted. e) none of the above. Which one(s) of the following is(are) procedural? a) Relational Algebra b) Relational Calculus c) Tuple Relational Calculus d) Domain Relational Calculus e) SQL f) (a) and (e) e) (b) and (e).
Question 35 If there are several operators with same priority in an arithmetic expression of an SQL statement then the priority will be For division for multiplication From left to right For addition
Answer the following questions based on the information in the PATIENT table below. Write SQL queries statement and provide the output of each query. (Screenshot the interface in MySQL that show SQL statement and output for each question). PATIENT PID 1001 JAMAL 35 1002 TAN 52 PNAME AGE ADATE 1003 MARIAM 30 1004 JOE 27 1005 SOFEA 19 GENDER 2000-10-28 M 2000-11-20 M 2000-07-16 F 2000-12-18 M 2000-04-25 F 2. Find the name of patient who admits on the same date as Sofea.
q5) Examine the EMPLOYEES table and the given SQL statement: EID Name Dept Salary 1001 Aminah IT 600 1002 Zainab Admin 400 1003 Tafal IT SELECT Name, Dept, SalaryFROM employeesWHERE name LIKE ‘_a%’ AND salary IS NULL; Which of the following will be the output after executing the statement? a. Name Dept Salary Tafal IT b. Name Dept Salary Zainab Admin 400 c. Name Dept Salary Aminah IT 600 d. Name Dept Salary Aminah IT 600 Zainab Admin 400
write Sql statements to write query for the given table .. the query statements are. Display first name of doctors whose first name contains any of vowels (a,e,i,o,u). Display names of those patients whose name’s second letter is neither ‘a’ nor ‘d’ Display details of those patients whose name contains less than 5 characters. Display first 4 doctors who are earning least salary. Display details of all patients in such a way that female patients are shown before male patients. Display names of those patients whose names starts with either ‘a’ or ‘b’ or‘d’ and don’t ends on‘s’. Display 1/4 records of patients.
By using this table answer this question: Write ONE SQL statement which uses the SUBSTR function (as many times as you need to) to extract the following three words: ‘I’, ‘am’, ‘here’ from the string ‘Where am I?’ and put the three words together using a combination of the CONCAT function and the ||. E.g. The starting string used in the SQL statement is: ‘Where am I?’ The output of the SQL statement after we run it will be: TRANS ---------- I am here
Quèstion 13 Given the following relation: Student (StudentID, studentName, StudentAddress, MobileNumber) Write a PL/SQL block of code that performs the following tasks: 1. Read a student id provided by user at run time and store it'h a variable. ii. Fetch the name and mobile number of the student having the entered id and store them inside two variables. ii. Display the fetched student name and mobile number. TTTT Paragraph Arial 3 (12pt) 品DOQ T T. J. O Mashups 曲 P 四HTML CS 直。
Q1. Please write a query statement from emp table to display employee's empno, ename, length of ename, number of 'S',and number of 'L'. SQL> SELECT empno AS "EmpNo", ename AS "Emp Name", ... AS "Name Length", .... AS "# Of S", .... AS "# Of L"FROM emp; [IMAGE below] Material to answer the question above: Material: https://drive.google.com/file/d/14OwWDIybjAIeuHCO7McupV08gJs9nB-8/view?usp=sharing https://drive.google.com/file/d/1npRH8JoJ6GYBzPU3iNjLXluvCyhr2tMu/view?usp=sharing
From: the Salesman and Customer tables· below, write SQL· statements to· do: the following: 1 a)+List the salesman id, rating and names of those salesmen who 'get-rating from 3 to:5, sorted DESCENDING·by:rating.1 b)+List all- the- customers' information: whose name starts with: 'F' and the fourth: character-is I',rests•may·be any character. c)+List the name and country of those customers and salesmen who belongs to the same country. Salesman table: Salesman Salesman_ rating country id name 2001 Mc Lyon 3 Italy 2005 James hood Canada 2045 Paul Hen 6 USA 2010 Nail Alex 4 France 2060 Salm E 5 KSA Customer table: Cust_id Cust_nam grade country Salesman e id 1. Nick 100 France 2010 Rimando 2 Brad Davis 400 Canada 2005 3 Fabian 200 Japan 2045 Johnson 4 Jozy 100 UK 2010 Altidor 5 Brad Guzan 500 Canada 2005
(b) Consider the schema of Customer table and write SQL statements for the following queries. sid sname address age occupation salary Pavment mode gender 123 sam yacoas 31 manager 60000 cash 124 david flaca 38 administrator 45000 credit i. Write the SQL query to set salary of all supervisors to Rs 40 000. ii. Write the SQL query to display details of clients whose names end with character 'e'. iii. Write the SQL code to display details of those clients who come from Vacoas or mahebourg,