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.)

7. Show the result of a full outer join between the S (supplier) and P (part) tables using the common CITY column.

8. Show the result of a summarize operation on P table. The grouping column is CITY and the aggregate calculation is COUNT.

9. Show the result of a summarize operation on SP. The grouping column is CITY and the aggregate calculations are the minimum and maximum STATUS values.

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). 

More related questions need help:  

https://www.chegg.com/homework-help/questions-and-answers/using-supplier-part-database-provided-answer-following-relational-algebra-questions-note-r-q22282331

https://www.chegg.com/homework-help/questions-and-answers/using-supplier-part-database-provided-answer-following-relational-algebra-questions-note-r-q22282351

https://www.chegg.com/homework-help/questions-and-answers/using-supplier-part-database-provided-answer-following-relational-algebra-questions-note-r-q22282397