Can I get just the written code for the question above, I do not need screenshot of answers

Part 2 (50 marks) Consider the following Supplier-Part database with three tables Suppler, Part, keys are underlined and foreign keys are obvious. Use both relational algebra ( (TRC) to express the following queries. Each query is 10 marks: Each Al result is 2 marks. and SP. e primary ALG) and tuple cale C is 4 marks and th The Prue calc Supplier S#NAME STATUS CITY S1 Smith 20 London S2 Jones 30 Paris S3 Blake 30 Paris S4 Clark 20 ss Adams 30 Athens SP S1 P1 300 SI P2 200 SI P3 400 SI P4 200 S1 P5 100 S1 P6 100 London Part PH NAME COLOR WEIGHT CITY Pl Nut Red 12.0 London P2 Bolt Green 17.0 Paris P3 Screw Blue 17.0 Oslo P4 Screw Red 14.0 London Ps Cam S2 P1 300 S2 P2 400 S3 P2 200 S4 P2 200 S4 P3 300 $4 P4 400 P5 Cam Blue 12.0 Paris P6 Cog Red 19.0 London S4 P5 500 S4 P6 600 1. Get the names of suppies who supply PL. 2. Get the names of suppliers who do not supply any part 3. Get names of suppliers who supply all parts. 4. Get the names of suppliers who supply all parts except P. 5. Get the names of suppliers who supply more than two parts using aggregate operati