Reference no: EM132174995

Using the supplier-part database provided below, answer each of the following relational algebra questions. (Note: Does not require the use of SQL or any database software. The results must be manually generated.)

1. Show the result of a project operation that lists the SNO, SNAME, and STATUS attributes of all suppliers (S table).

2. Show the result of a restrict operation that lists the suppliers (S table) in Paris and Athens.

3. Show the result of project and restriction operations that list the SNO, SNAME, and STATUS attributes of the suppliers (S table) in London and Athens.

S Table (for Suppliers) ======================= SNO SNAME STATUS CITY ======================= S1 Smith 20 London S2 Jones 10 Paris S3 Blake 30 Paris S4 Clark 20 London S5 Adams 30 Athens ======================= P Table (for Parts) ============================= PNO PNAME COLOR WEIGHT CITY ============================= P1 Nut Red 12 London P2 Bolt Green 17 Paris P3 Screw Blue 17 Rome P4 Screw Red 14 London P5 Cam Blue 12 Paris P6 Cog Red 19 London ============================= SP Table =========== SNO PNO QTY =========== S1 P1 300 S1 P2 200 S1 P3 400 S1 P4 200 S1 P5 100 S1 P6 100 S2 P1 300 S2 P2 400 S3 P2 200 S4 P2 200 S4 P4 300 S4 P5 400 =========== info: (QTY stands for quantity.) SP table shows which supplier (SNO) supplied how many units (QTY) of which part (PNO).