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

10. Show SNO of supplier(s) who supplied all parts in P table. That is, show the result of the divide operation in which SP table (with SNO and PNO columns) is divided by P table (with PNO column).

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-q22282371