ItemsSalesID_NamePriceSupplierSIDS DateCIDKetchup12012-5-231.50Block Factory2012-5-242UniqueManufacturerS&S2Salt4042016-4-2332016-2-124Soap3062016-1-10International4Toothpaste33BrothersEnterpriseGeneral5Sugar20BillTraders6.Detergent34AlibabaSIDIDExpress213Customer4CIDName21CityLahorePeshawar24AqibSuleman22SahiwalPeshawar2NadeemSarim44SohailPeshawar436NadirOkara4244PeshawarLahoreNasirKamalU sing the Schem a - data/statistics Can follow ing queries be executed on above relationsor not.lf not then justify with reason.1) (Select ID, I_Name from item s where I_Name like '% a % ') Unio n (Select Nam e,CID fromCustomer)2)(Select * fro m items where P rice > 20) In tersect (Select * from Customer)3)Select * from Customer inner jo in Sales wh ere City='Lahore' and Custom er.CID=Sales.CID4) Select distin ct Name, City from Custom er5) In sert into Sales values (3,'2016-2-12',4)

1. (Select ID,I_name from items where I_name like '%a%' ) union (Select name, CID from Customer)This…

Items Sales ID Name Price Supplier SID SDate CID Ketchup 50 Block Factory 2012-5-23 2012-5-24 2 Salt 40 Unique Manufacturer S&S International 4 2016-4-23 2016-2-12 4 Soap 30 6. 2016-1-10 1 4 Toothpaste 33 Brothers Enterprise General Traders Sugar 20 Bill 6. Detergent 34 Alibaba SID ID Express 1 2 1 Customer 4 CID Name 2 City Lahore 1. 4 Aqib Suleman Peshawar 3 3. Nadeem Sahiwal 5 4. Sarim Peshawar 4 5. Sohail Peshawar Okara Peshawar Lahore 6. Nadir 2 Nasir 4 4 Kamal U sing the Schem a - data/statistics Can follow ing queries be executed on above relations or not.lf not then justify with reason. 1) (Select ID, I_N ame from item s where _Name like '% a % ') Union (Select Nam e,CID from Customer) 2)(Select * fro m items where Price > 20) In tersect (Select * from Customer) 3)Select * from Customer inner jo in Sales where City='Lahore' and Custom er.CID=Sales.CID 4) Select distinct Name, City from Custom er 5) In sert into Sales values (3,'2016-2-12',4) 222344

Items Sales ID Name Price Supplier SID SDate CID Ketchup 50 Block Factory 2012-5-23 2012-5-24 2 Salt 40 Unique Manufacturer S&S International 4 2016-4-23 2016-2-12 4 Soap 30 6. 2016-1-10 1 4 Toothpaste 33 Brothers Enterprise General Traders Sugar 20 Bill 6. Detergent 34 Alibaba SID ID Express 1 2 1 Customer 4 CID Name 2 City Lahore 1. 4 Aqib Suleman Peshawar 3 3. Nadeem Sahiwal 5 4. Sarim Peshawar 4 5. Sohail Peshawar Okara Peshawar Lahore 6. Nadir 2 Nasir 4 4 Kamal U sing the Schem a - data/statistics Can follow ing queries be executed on above relations or not.lf not then justify with reason. 1) (Select ID, I_N ame from item s where _Name like '% a % ') Union (Select Nam e,CID from Customer) 2)(Select * fro m items where Price > 20) In tersect (Select * from Customer) 3)Select * from Customer inner jo in Sales where City='Lahore' and Custom er.CID=Sales.CID 4) Select distinct Name, City from Custom er 5) In sert into Sales values (3,'2016-2-12',4) 222344

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

With regards to Jacob Nielsen's 10 usability heuristics, identify THE CHANGES needed for the Abenson website's checkout process design to be compliant and HIGHLIGHT THE CHANGES made.
Cree la base de datos en MySQL para el siguiente ERD y entregeue el documento .sg/ al final Products PK Product ID 8 Product Name Product Price Product Quantity Stock Product Status Product Description Customer Type PK Customer Type ID Customer Type Description PX FK FK FK Orders Order ID Product ID Customer Type 10 Payment Type ID Order Quantity Order Date Time Order Status Payments Type PK Payment Type 10 Payment Type Description
What is Power Pivot & Power Query?
Make 5 intelligent questions about each chart along with the answers (10 in total)
Question 1 What is a reason an employee should update their TD1 form? O They got a promotion O It's the start of a new quarter O They have had a major persona life event (marriage, divorce, birth of a child, etc.) OIt's the end of a pay period Question 2 What annual return are employers required to file with CRA every February for the previous calendar year? Record of Employment TB1 O Payroll Summary O T4
What is Power Pivot & Power Query?
ed1 x emp x A 7 Filter EMPNO ENAME DNAME JOB HIREDATE LOC SALARY 8876 adams research clerk 2017-07-23 Johor 5000 8499 allen sales salesman 2018-01-23 KL 3400 8698 blake sales manager 2016-03-11 KL 10000 8782 ali accounting manager 2015-06-25 Penang 11000 8902 ford research analyst 2016-02-03 Johor 8700 8900 james sales clerk 2017-12-13 KL 3500 8566 jones research manager 2015-04-02 Johor 9000 8839 king accounting president 2019-11-17 Penang NA 8654 martin sales salesman 2012-06-17 KL 3250 8934 miller accounting clerk 2012-01-23 Penang 3000 8788 scott research analyst 2017-04-19 Johor 7500 8369 smith research clerk 2016-12-17 Johor 5600 8844 turner sales salesman 2018-09-08 KL 3000 8521 andrew sales salesman 2018-02-22 KL 3200 Which of the following can be used to return the maximum salary (SALARY) for each location (LOC) Select one: O emp %>% group_by(LOC) %>% summarise(max_sal=max(emp$SALARY, na.m = T)) O emp %>% fiter(LOC="Penang') %>% group_by(LOC) %>% summarise(max_sal=max(SALARY,…
How accurate is sentiment analysis? How do you believe it is accomplished?
Please answer this questions as well with thorough analysis and scholar academic source information for 21 0z (621ml), Jergens original scent, cherry almond essence 1) Describe the product that you have chosen(2) Comment on the information provided on the label(3) How does the price of the product compare to the prices of the similar products in the category?
Find top 2 largest departments in terms of number of employees
How can mail merge help senior highschool students?
Please provide answer and explanation as well