Plz someone help me out ! ! !?

consider the following database


s(sno,sname,status,city),


p(pno,pname,weight,color,city),


j(jno,jname,city),


spj(sno,pno,,jno,qty),


1.Now Pleez answer the following queries using SQL syntax:


a.Get full details of all projects in Peshawer as well as in Lahore.


b.Get supplier name of all suppliers who supplies project J1 in supplier name order.


c.Get complete detail of all shipments where quantity ranges from 200 to 700


d.Get the total quantity of part P1 supplied by supplier S2


e.Get the project number and city information for projects where city has an ‘I’ as the second





letter of its name.


f.Get the supplier name with complete parts information where part color is red.


g.Delete all projects for which there is no shipment.


h.Change the name of supplier to Asmat,his city to lahore, where supplier no is 101


2.answer the following queries using Relational Algebra syntax:


i.Get full details of all projects in Peshawer as well as in Lahore.


j.Get supplier name, parts name,project name and project city


of those supplier who supply part p1 with quantity greater thkan 100.


k.Get complete details of all shipments where quantity ranges between 200 to 700


l.Get the supplier name with complete parts information where part color is red.

Plz someone help me out ! ! !?
Read C.J.Date "An Introduction To Database Systems".