A. Give the relational algebra expression for the following English queries.
1. Get the supplier# who supply all the blue parts
2. Get the suppliers names who supply all the parts located in London
3. Give the details of suppliers in Athens
4. Give details of shipments where the quantity shipped is less than 200
5. Give details of parts stored in Paris
6. Give the names and numbers of London-based suppliers
7. Give the names of blue Parts
8. Give the part number for parts weighting less than 20
9. Give details of parts supplied by S2
10. Give the color of parts supplied by S3
11. Where are the suppliers of P2 located
12. Get supplier numbers for suppliers who supply parts located in either Paris or London
13. Get part numbers for parts supplied by a supplier in the same city as the part
14. Get part numbers for parts based in London, supplied by a London supplier
15. Get supplier numbers for suppliers not supplying red parts
B. Based on the database, show the result relation in each case (15 marks)
1. result:= select S where status >"20"
2. Result:= project P over city
3. R1:= project S over S#, city
R2:=project P over P#, city
result:=join R1, R2 over city
C. Show the result relation for each step. You must show how the divide operation works
to get full marks (10 marks).
R0:=select P where Pname="CAM"
R1:= project R0 over P#
R2:=project SP over S#, P#
Result:= divide R2 by R1