Using the Schema - data/statistics.Transform following SQL queries into Relational Algebraic queries. Select * from Itemsi, Bill b, Sales s, Customer c where c.City=’Peshawar’Select c.Name from Customer c inner join Sales s on s.CID=c.CID inner join Bill b on s.SID=b.SID(Select * from Customer) Except (Select c.* from Customer c inner join Sales s on c.CID=s.CID)Select * from Customer where City=’Sahiwal’ or City=’Peshawar’Select I_Name from Items I, Bill b where ID in(1,4,2) ItemsSalesID_NamePriceSupplierSIDS_DateCID1Ketchup50Block Factory2012-5-232012-5-24UniqueManufacturerS&S2Salt4042016-4-232016-2-124Soap3062016-1-101International4Toothpaste33BrothersEnterpriseGeneralSugar20BillTraders6Detergent34AlibabaSIDIDExpress13.Customer4CIDName21CityLahorePeshawarSahiwal24AqibSuleman1223Nadeem2534PeshawarPeshawar4SarimSohail4NadirOkara42NasirPeshawar44KamalLahore

Required : SQL query to relational algebra query Note : As per guidelines of company, we are…

Answered: Using the Schema -…

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

Related questions

Question

Using the Schema - data/statistics.Transform following SQL queries into Relational Algebraic queries.

Select * from Itemsi, Bill b, Sales s, Customer c where c.City=’Peshawar’
Select c.Name from Customer c inner join Sales s on s.CID=c.CID inner join Bill b on s.SID=b.SID
(Select * from Customer) Except (Select c.* from Customer c inner join Sales s on c.CID=s.CID)
Select * from Customer where City=’Sahiwal’ or City=’Peshawar’
Select I_Name from Items I, Bill b where ID in(1,4,2)